APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 160: FROM zx_party_tax_profile ptp,

156: p_posting_status VARCHAR2(30);
157:
158: CURSOR establishment_id_csr(c_legal_entity_id number) IS
159: SELECT xle_etb.establishment_id
160: FROM zx_party_tax_profile ptp,
161: xle_etb_profiles xle_etb
162: WHERE ptp.party_id = xle_etb.party_id
163: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
164: AND xle_etb.legal_entity_id = c_legal_entity_id

Line 764: zx_party_tax_profile ptp,

760: l_internal_organization_id_tbl --Bug 5251425
761: FROM zx_reporting_types_b rep_type,
762: zx_reporting_codes_b rep_code,
763: zx_report_codes_assoc rep_ass,
764: zx_party_tax_profile ptp,
765: xle_etb_profiles xle_pf ,
766: zx_rep_trx_detail_t dtl
767: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
768: AND rep_type.reporting_type_code = 'MEMBER STATE'

Line 770: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

766: zx_rep_trx_detail_t dtl
767: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
768: AND rep_type.reporting_type_code = 'MEMBER STATE'
769: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
770: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'
771: AND rep_ass.entity_id = ptp.party_tax_profile_id
772: AND ptp.party_id = xle_pf.party_id
773: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
774: AND xle_pf.establishment_id = l_establishment_id

Line 1093: zx_party_tax_profile ptp,

1089: INTO p_org_vat_num_tbl(i)
1090: FROM zx_reporting_types_b rep_type,
1091: zx_reporting_codes_b rep_code,
1092: zx_report_codes_assoc rep_ass,
1093: zx_party_tax_profile ptp,
1094: xle_etb_profiles xle_pf
1095: -- zx_rep_trx_detail_t dtl
1096: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
1097: AND rep_type.reporting_type_code = 'FSO_REG_NUM'

Line 1099: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'

1095: -- zx_rep_trx_detail_t dtl
1096: WHERE rep_type.reporting_type_id = rep_code.reporting_type_id
1097: AND rep_type.reporting_type_code = 'FSO_REG_NUM'
1098: AND rep_code.reporting_code_id = rep_ass.reporting_code_id
1099: AND rep_ass.entity_code = 'ZX_PARTY_TAX_PROFILE'
1100: AND rep_ass.entity_id = ptp.party_tax_profile_id
1101: AND ptp.party_id = xle_pf.party_id
1102: AND ptp.Party_Type_Code = 'LEGAL_ESTABLISHMENT'
1103: AND xle_pf.establishment_id = p_establishment_id;