APPS.CE_XML_HDRS_INF_PKG dependencies on CE_BANK_ACCOUNTS

Line 61: l_org_id CE_BANK_ACCOUNTS.ACCOUNT_OWNER_org_id%TYPE;

57: l_temp NUMBER;
58: l_temp2 NUMBER;
59: l_temp3 NUMBER;
60: l_temp4 NUMBER;
61: l_org_id CE_BANK_ACCOUNTS.ACCOUNT_OWNER_org_id%TYPE;
62: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;
63: l_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE;
64: l_curr_code CE_BANK_ACCOUNTS_V.currency_code%TYPE;
65:

Line 64: l_curr_code CE_BANK_ACCOUNTS_V.currency_code%TYPE;

60: l_temp4 NUMBER;
61: l_org_id CE_BANK_ACCOUNTS.ACCOUNT_OWNER_org_id%TYPE;
62: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;
63: l_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE;
64: l_curr_code CE_BANK_ACCOUNTS_V.currency_code%TYPE;
65:
66: l_seq NUMBER;
67:
68: BEGIN

Line 79: FROM CE_BANK_ACCOUNTS BA,

75: count(BB.bank_name),
76: count(BB.bank_branch_name),
77: count(BA.currency_code)
78: INTO l_temp, l_temp2, l_temp3, l_temp4
79: FROM CE_BANK_ACCOUNTS BA,
80: CE_BANK_BRANCHES_V BB
81: WHERE BA.bank_account_num = X_Bank_Account_Num
82: AND BB.branch_party_id = BA.bank_branch_id;
83:

Line 87: FROM CE_BANK_ACCOUNTS

83:
84: IF (l_temp = 1) THEN
85: SELECT ACCOUNT_OWNER_org_id
86: INTO l_org_id
87: FROM CE_BANK_ACCOUNTS
88: WHERE bank_account_num = X_Bank_Account_Num;
89: ELSE
90: l_org_id := TO_NUMBER(null);
91: END IF;

Line 97: FROM CE_BANK_ACCOUNTS BA,

93: IF (X_Bank_Name is null) THEN
94: IF (l_temp2 = 1) THEN
95: SELECT bb.bank_name
96: INTO l_bank_name
97: FROM CE_BANK_ACCOUNTS BA,
98: CE_BANK_BRANCHES_V BB
99: WHERE BA.bank_account_num = X_Bank_Account_Num
100: AND BB.branch_party_id = BA.bank_branch_id;
101: ELSE

Line 112: FROM CE_BANK_ACCOUNTS BA,

108: IF (X_Bank_Branch_Name is null) THEN
109: IF (l_temp3 = 1) THEN
110: SELECT bb.bank_branch_name
111: INTO l_bank_branch_name
112: FROM CE_BANK_ACCOUNTS BA,
113: CE_BANK_BRANCHES_V BB
114: WHERE BA.bank_account_num = X_Bank_Account_Num
115: AND BB.branch_party_id = BA.bank_branch_id;
116: ELSE

Line 127: FROM CE_BANK_ACCOUNTS

123: IF (X_Currency_Code is null) THEN
124: IF (l_temp2 = 1) THEN
125: SELECT currency_code
126: INTO l_curr_code
127: FROM CE_BANK_ACCOUNTS
128: WHERE bank_account_num = X_Bank_Account_Num;
129: ELSE
130: l_curr_code := '';
131: END IF;