DBA Data[Home] [Help]

APPS.ZX_SRVC_TYP_PKG dependencies on XLE_ETB_PROFILES

Line 18710: xle_etb_profiles xle_etb

18706:
18707: SELECT xle_etb.establishment_id
18708: INTO l_establishment_id
18709: FROM zx_party_tax_profile ptp,
18710: xle_etb_profiles xle_etb
18711: WHERE ptp.party_id = xle_etb.party_id
18712: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
18713: AND xle_etb.legal_entity_id = l_legal_entity_id
18714: AND xle_etb.main_establishment_flag = 'Y'

Line 18736: xle_etb_profiles xle_etb

18732: IF NOT l_main_estb_for_entity_tbl.EXISTS(l_tbl_index) THEN
18733: SELECT xle_etb.establishment_id
18734: INTO l_establishment_id
18735: FROM zx_party_tax_profile ptp,
18736: xle_etb_profiles xle_etb
18737: WHERE ptp.party_id = xle_etb.party_id
18738: AND ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
18739: AND xle_etb.legal_entity_id = l_legal_entity_id
18740: AND xle_etb.main_establishment_flag = 'Y'