APPS.JE_IT_XML_LISTING_PKG dependencies on HZ_PARTIES

Line 156: ,hz_parties hzp

152: ,ROUND(je.cm_exempt_amt) EXEMPT_AMT_CM
153: ,ROUND(je.cm_taxable_vat_inv_amt) TAXABLE_VAT_INV_AMT_CM
154: FROM je_it_list_parties_all je
155: ,hz_cust_accounts hzca
156: ,hz_parties hzp
157: WHERE je.vat_reporting_entity_id = P_VAT_REPORTING_ENTITY_ID
158: AND je.year_of_declaration = P_YEAR_OF_DECLARATION
159: AND je.application_id = 222
160: AND je.transmission_num = P_PROG_NUM

Line 783: SELECT 1 FROM hz_parties

779: WHERE pv.employee_id = papf.person_id (+)
780: AND NVL(papf.national_identifier,NVL(pv.individual_1099,pv.num_1099)) = c_taxpayer_id;
781:
782: CURSOR customer_taxpayer_id_csr(c_taxpayer_id varchar2) IS
783: SELECT 1 FROM hz_parties
784: WHERE jgzz_fiscal_code = c_taxpayer_id;
785:
786:
787: l_count number :=0;