DBA Data[Home] [Help]

APPS.CE_CEPURGE_XMLP_PKG dependencies on CE_BANK_ACCOUNTS

Line 62: CE_BANK_ACCOUNTS BA

58: AND SH.BANK_ACCOUNT_ID IN (
59: SELECT
60: BANK_ACCOUNT_ID
61: FROM
62: CE_BANK_ACCOUNTS BA
63: WHERE BA.BANK_BRANCH_ID = NVL(P_BANK_BRANCH
64: ,BA.BANK_BRANCH_ID) )
65: AND TRUNC(SH.STATEMENT_DATE) >= NVL(P_STATEMENT_DATE_FROM
66: ,TRUNC(SH.STATEMENT_DATE))

Line 595: CE_BANK_ACCOUNTS ABA

591: AND SH.BANK_ACCOUNT_ID IN (
592: SELECT
593: ABA.BANK_ACCOUNT_ID
594: FROM
595: CE_BANK_ACCOUNTS ABA
596: WHERE ABA.BANK_BRANCH_ID = P_BANK_BRANCH )
597: AND SH.STATEMENT_DATE >= NVL(P_STATEMENT_DATE_FROM
598: ,SH.STATEMENT_DATE)
599: AND SH.STATEMENT_DATE <= NVL(P_STATEMENT_DATE_TO1

Line 1445: CE_BANK_ACCOUNTS ABA

1441: WHERE CSH.BANK_ACCOUNT_ID IN (
1442: SELECT
1443: ABA.BANK_ACCOUNT_ID
1444: FROM
1445: CE_BANK_ACCOUNTS ABA
1446: WHERE ABA.BANK_BRANCH_ID = P_BANK_BRANCH )
1447: AND TRUNC(CSH.STATEMENT_DATE) >= NVL(P_STATEMENT_DATE_FROM
1448: ,TRUNC(CSH.STATEMENT_DATE))
1449: AND TRUNC(CSH.STATEMENT_DATE) <= NVL(P_STATEMENT_DATE_TO1