APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on XLE_ETB_PROFILES

Line 161: xle_etb_profiles xle_etb

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
165: AND xle_etb.main_establishment_flag = 'Y';

Line 765: xle_etb_profiles xle_pf ,

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'
769: AND rep_code.reporting_code_id = rep_ass.reporting_code_id

Line 1094: xle_etb_profiles xle_pf

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'
1098: AND rep_code.reporting_code_id = rep_ass.reporting_code_id