APPS.CE_XML_HDRS_INF_PKG dependencies on CE_BANK_BRANCHES_V

Line 62: l_bank_name CE_BANK_BRANCHES_V.bank_name%TYPE;

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:
66: l_seq NUMBER;

Line 63: l_bank_branch_name CE_BANK_BRANCHES_V.bank_branch_name%TYPE;

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:
66: l_seq NUMBER;
67:

Line 80: CE_BANK_BRANCHES_V BB

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:
84: IF (l_temp = 1) THEN

Line 98: CE_BANK_BRANCHES_V BB

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
102: l_bank_name := '';

Line 113: CE_BANK_BRANCHES_V BB

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
117: l_bank_branch_name := '';