APPS.JL_BR_AP_VALIDATE_COLLECTION dependencies on PO_VENDORS

Line 36: x_vendor_name po_vendors.vendor_name%TYPE;

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

Line 201: po_vendors pov

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

Line 218: po_vendors pov

214: substr(pov.vendor_name,1,240)
215: INTO s_vendor_site_id,
216: x_vendor_name
217: FROM po_vendor_sites povs,
218: po_vendors pov
219: WHERE povs.global_attribute9 = e_transf_inscription_type
220: AND povs.global_attribute10 = '0'||substr(e_transf_inscription_number,1,8)
221: AND povs.global_attribute11 = substr(e_transf_inscription_number,9,4)
222: AND povs.global_attribute12 = substr(e_transf_inscription_number,13,2)