DBA Data[Home] [Help]

APPS.JA_JAINITCR_XMLP_PKG dependencies on AP_BANK_ACCOUNTS_ALL

Line 165: AP_BANK_ACCOUNTS_ALL

161: WHERE BANK_BRANCH_ID in (
162: SELECT
163: BANK_BRANCH_ID
164: FROM
165: AP_BANK_ACCOUNTS_ALL
166: WHERE BANK_ACCOUNT_ID IN (
167: SELECT
168: DISTINCT
169: EXTERNAL_BANK_ACCOUNT_ID

Line 471: AP_BANK_ACCOUNTS_ALL B

467: SELECT
468: A.BANK_NUM
469: FROM
470: AP_BANK_BRANCHES A,
471: AP_BANK_ACCOUNTS_ALL B
472: WHERE A.BANK_BRANCH_ID = B.BANK_BRANCH_ID
473: AND B.BANK_ACCOUNT_ID = P_BANK_ACCOUNT_ID;
474: LV_BANK_BRANCH_CODE AP_BANK_BRANCHES.BANK_NUM%TYPE;
475: BEGIN