SELECT
    DISTINCT(A.PAY_ID),
    A.PAY_AMT,
    A.PAY_STATUS_FLG,
    A.PAY_EVENT_ID,
    TRUNC(B.FREEZE_DTTM) AS FREEZE_DT
FROM
    CI_PAY A,
    CI_FT B
WHERE A.ACCT_ID = :F1
AND A.PAY_STATUS_FLG IN ('50','60')
AND B.PARENT_ID = A.PAY_ID
[(F2) AND B.SA_ID = (:F2)]
AND B.FT_TYPE_FLG IN ('PS','PX')
AND TRUNC(B.FREEZE_DTTM) >= :F3
AND TRUNC(B.FREEZE_DTTM) <= :F4
ORDER BY FREEZE_DT DESC

SELECT
   ADJ.ADJ_ID
  ,ADJ.CRE_DT
  ,ADJ.ADJ_STATUS_FLG
  ,ADJ.ADJ_TYPE_CD
  ,ADJ.SA_ID
  ,FT.FT_TYPE_FLG
  ,FT.ARS_DT
  ,FT.CUR_AMT
  ,FT.TOT_AMT
FROM
  CI_ADJ ADJ,
  CI_FT FT
WHERE
  ADJ.SA_ID IN (SELECT SA.SA_ID FROM CI_SA SA WHERE SA.ACCT_ID  = :F1)
  [(F2) AND ADJ.SA_ID = (:F2)]
  AND FT.SIBLING_ID = ADJ.ADJ_ID
  AND FT.FT_TYPE_FLG IN ('AD','AX')
  AND TRUNC(FT.FREEZE_DTTM) >= :F3
  AND TRUNC(FT.FREEZE_DTTM) <= :F4
  AND NOT EXISTS (SELECT 'X'
                  FROM CI_ADJ ADJ2, CI_SA SA2
                  WHERE ADJ2.XFER_ADJ_ID = ADJ.ADJ_ID
                  AND ADJ2.ADJ_STATUS_FLG IN ('50','60')
                  AND SA2.SA_ID = ADJ2.SA_ID
                  AND SA2.ACCT_ID = :F1)

SELECT
    SIBLING_ID AS PAY_SEGMENT_ID,
    SA_ID,
    FT_TYPE_FLG,
    CUR_AMT,
    TOT_AMT,
    ARS_DT
FROM CI_FT
WHERE PARENT_ID = :F1
[(F2) AND SA_ID = (:F2)]