APPS.JE_IT_XML_LISTING_PKG dependencies on AP_SUPPLIERS

Line 186: ,ap_suppliers pv

182: ,ROUND(je.cm_exempt_amt) EXEMPT_AMT_CM
183: ,ROUND(je.cm_taxable_vat_amt) TAXABLE_VAT_AMT_CM
184: ,ROUND(je.cm_taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT_CM
185: FROM je_it_list_parties_all je
186: ,ap_suppliers pv
187: WHERE je.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
188: AND je.year_of_declaration = P_YEAR_OF_DECLARATION
189: AND je.transmission_num = P_PROG_NUM
190: AND je.application_id = 200

Line 774: FROM ap_suppliers pv,

770: IS
771:
772: CURSOR supplier_taxpayer_id_csr(c_taxpayer_id varchar2) IS
773: SELECT 1
774: FROM ap_suppliers pv,
775: (SELECT distinct person_id
776: ,national_identifier
777: FROM per_all_people_f
778: WHERE nvl(effective_end_date,sysdate) >= sysdate ) papf