DBA Data[Home] [Help]

APPS.JA_JAINITCR_XMLP_PKG dependencies on AP_BANK_BRANCHES

Line 160: AP_BANK_BRANCHES

156: ADDRESS_LINE3,
157: CITY
158: INTO P_BANK_NAME,P_BANK_BRANCH_NAME,P_ADD1,P_ADD2,P_ADD3,P_CITY
159: FROM
160: AP_BANK_BRANCHES
161: WHERE BANK_BRANCH_ID in (
162: SELECT
163: BANK_BRANCH_ID
164: FROM

Line 470: AP_BANK_BRANCHES A,

466: CURSOR C_BANK_BRANCH_CODE(P_BANK_ACCOUNT_ID IN NUMBER) IS
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;

Line 474: LV_BANK_BRANCH_CODE AP_BANK_BRANCHES.BANK_NUM%TYPE;

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
476: OPEN C_BANK_BRANCH_CODE(BANK_ACCOUNT_ID);
477: FETCH C_BANK_BRANCH_CODE
478: INTO LV_BANK_BRANCH_CODE;