APPS.CE_XML_BS_LOADER dependencies on CE_BANK_BRANCHES_V

Line 69: FROM CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_v BB

65: WHERE BANK_ACCOUNT_NUM = l_bank_account_num;
66: else
67: SELECT count(1)
68: INTO l_cnt
69: FROM CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_v BB
70: WHERE BA.bank_account_num = l_bank_account_num
71: AND BB.bank_name = l_trading_partner
72: AND BB.branch_party_id = BA.bank_branch_id;
73: end if;

Line 100: FROM CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_V BB

96: BA.bank_account_id,
97: BA.ACCOUNT_OWNER_org_id,
98: BB.bank_name
99: INTO l_bank_branch_id, l_bank_account_id, l_org_id, l_trading_partner
100: FROM CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_V BB
101: WHERE BA.bank_account_num = l_bank_account_num
102: AND BB.branch_party_id = BA.bank_branch_id;
103: else
104: SELECT BB.branch_party_id,

Line 108: FROM CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_V BB

104: SELECT BB.branch_party_id,
105: BA.bank_account_id,
106: BA.ACCOUNT_OWNER_org_id
107: INTO l_bank_branch_id, l_bank_account_id, l_org_id
108: FROM CE_BANK_ACCOUNTS BA, CE_BANK_BRANCHES_V BB
109: WHERE BA.bank_account_num = l_bank_account_num
110: AND BB.bank_name = l_trading_partner
111: AND BB.branch_party_id = BA.bank_branch_id;
112: end if;