APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on PO_VENDORS

Line 911: l_supplier_num po_vendors.segment1%TYPE;

907: AND R.je_header_id = p_journal_rec.je_header_id
908: AND R.je_line_num = p_journal_rec.je_line_num;
909:
910:
911: l_supplier_num po_vendors.segment1%TYPE;
912: l_err_flag NUMBER;
913: l_invoice_line_number NUMBER; -- ER 9435028
914: l_nit ap_invoice_lines_all.merchant_taxpayer_id%TYPE; -- ER 9435028
915: l_nit_name ap_invoice_lines_all.merchant_name%TYPE; -- ER 9435028

Line 1575: FROM po_vendors pov,

1571: pov.global_attribute10,
1572: pov.global_attribute12,
1573: pov.segment1,
1574: pov.vendor_id
1575: FROM po_vendors pov,
1576: (select distinct person_id ,national_identifier from per_all_people_f
1577: WHERE nvl(EFFECTIVE_END_DATE,sysdate) >= sysdate) papf --bug 8664192
1578: WHERE nvl(pov.employee_id, -99) = papf.person_id (+))povpapf
1579: WHERE poha.po_header_id = TO_NUMBER(p_journal_rec.ref_2)

Line 1704: l_customer_num po_vendors.segment1%TYPE;

1700: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1701: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1702: l_ent_dr gl_je_lines.entered_dr%TYPE;
1703: l_ent_cr gl_je_lines.entered_cr%TYPE;
1704: l_customer_num po_vendors.segment1%TYPE;
1705: l_identifier_type VARCHAR2(30);
1706:
1707: BEGIN
1708:

Line 1976: l_customer_num po_vendors.segment1%TYPE;

1972: l_acc_dr gl_je_lines.accounted_dr%TYPE;
1973: l_acc_cr gl_je_lines.accounted_cr%TYPE;
1974: l_ent_dr gl_je_lines.entered_dr%TYPE;
1975: l_ent_cr gl_je_lines.entered_cr%TYPE;
1976: l_customer_num po_vendors.segment1%TYPE;
1977: l_identifier_type VARCHAR2(30);
1978: l_country_code varchar2(30);
1979: l_branch_country_code varchar2(60);
1980: l_party_id number;