APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 150: FROM zx_party_tax_profile ptp,

146:
147:
148: CURSOR establishment_id_csr(c_legal_entity_id number) IS
149: SELECT xle_etb.establishment_id
150: FROM zx_party_tax_profile ptp,
151: xle_etb_profiles xle_etb
152: WHERE ptp.party_id = xle_etb.party_id
153: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
154: AND xle_etb.legal_entity_id = c_legal_entity_id

Line 334: zx_party_tax_profile ptp,

330: l_internal_organization_id_tbl --Bug 5251425
331: FROM zx_reporting_types_b rep_type,
332: zx_reporting_codes_b rep_code,
333: zx_report_codes_assoc rep_ass,
334: zx_party_tax_profile ptp,
335: xle_etb_profiles xle_pf ,
336: zx_rep_trx_detail_t dtl
337: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
338: AND rep_type.reporting_type_code = 'MEMBER STATE'

Line 340: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

336: zx_rep_trx_detail_t dtl
337: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
338: AND rep_type.reporting_type_code = 'MEMBER STATE'
339: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
340: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'
341: AND rep_ass.entity_id = ptp.party_tax_profile_id
342: AND ptp.party_id = xle_pf.party_id
343: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
344: AND xle_pf.establishment_id = l_establishment_id

Line 585: zx_party_tax_profile ptp,

581: INTO p_org_vat_num_tbl(i)
582: FROM zx_reporting_types_b rep_type,
583: zx_reporting_codes_b rep_code,
584: zx_report_codes_assoc rep_ass,
585: zx_party_tax_profile ptp,
586: xle_etb_profiles xle_pf
587: -- zx_rep_trx_detail_t dtl
588: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
589: AND rep_type.reporting_type_code = 'FSO_REG_NUM'

Line 591: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

587: -- zx_rep_trx_detail_t dtl
588: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
589: AND rep_type.reporting_type_code = 'FSO_REG_NUM'
590: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
591: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'
592: AND rep_ass.entity_id = ptp.party_tax_profile_id
593: AND ptp.party_id = xle_pf.party_id
594: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
595: AND xle_pf.establishment_id = p_establishment_id;