APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on CE_BANK_BRANCHES_V

Line 34: x_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;

30: x_aux VARCHAR2(1);
31: x_name jl_br_ap_int_collect.drawee_name%TYPE;
32: x_register_type jl_br_ap_int_collect.drawee_inscription_type%TYPE;
33: x_inscription_number jl_br_ap_int_collect.drawee_inscription_number%TYPE;
34: x_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;
35: x_vendor_name po_vendors.vendor_name%TYPE;
36: x_aux1 NUMBER;
37: x_aux2 NUMBER;
38:

Line 156: FROM ce_bank_branches_v

152:
153: BEGIN
154: SELECT branch_party_id
155: INTO x_bank_branch_id
156: FROM ce_bank_branches_v
157: WHERE bank_number = e_drawee_bank_code
158: AND branch_number = e_drawee_branch_code
159: AND country = 'BR';
160: EXCEPTION

Line 248: FROM ce_bank_branches_v

244: INTO x_aux
245: FROM sys.dual
246: WHERE EXISTS (
247: SELECT null
248: FROM ce_bank_branches_v
249: WHERE bank_number = e_transferor_bank_code
250: AND branch_number = e_transferor_branch_code
251: AND country = 'BR' );
252: EXCEPTION