APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on PO_VENDORS

Line 35: x_vendor_name po_vendors.vendor_name%TYPE;

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:
39: l_return_status VARCHAR2(100);

Line 198: po_vendors pov

194: substr(pov.vendor_name,1,240)
195: INTO s_vendor_site_id,
196: x_vendor_name
197: FROM po_vendor_sites povs,
198: po_vendors pov
199: WHERE povs.global_attribute9 = e_transf_inscription_type
200: AND povs.global_attribute10 = substr(e_transf_inscription_number,4,9)
201: AND povs.global_attribute12 = substr(e_transf_inscription_number,13,2)
202: AND pov.vendor_id = povs.vendor_id;

Line 212: po_vendors pov

208: substr(pov.vendor_name,1,240)
209: INTO s_vendor_site_id,
210: x_vendor_name
211: FROM po_vendor_sites povs,
212: po_vendors pov
213: WHERE povs.global_attribute9 = e_transf_inscription_type
214: AND povs.global_attribute10 = '0'||substr(e_transf_inscription_number,1,8)
215: AND povs.global_attribute11 = substr(e_transf_inscription_number,9,4)
216: AND povs.global_attribute12 = substr(e_transf_inscription_number,13,2)