APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on CE_BANK_BRANCHES_V

Line 35: x_bank_branch_id ce_bank_branches_v.branch_party_id%TYPE;

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

Line 159: FROM ce_bank_branches_v

155:
156: BEGIN
157: SELECT branch_party_id
158: INTO x_bank_branch_id
159: FROM ce_bank_branches_v
160: WHERE bank_number = e_drawee_bank_code
161: AND branch_number = e_drawee_branch_code
162: AND bank_home_country = 'BR';
163: EXCEPTION

Line 257: FROM ce_bank_branches_v

253: INTO x_aux
254: FROM sys.dual
255: WHERE EXISTS (
256: SELECT null
257: FROM ce_bank_branches_v
258: WHERE bank_number = e_transferor_bank_code
259: AND branch_number = e_transferor_branch_code
260: AND bank_home_country = 'BR' );
261: EXCEPTION