DBA Data[Home] [Help]

APPS.RRS_IMPORT_INTERFACE_PKG dependencies on XLE_ENTITY_PROFILES

Line 2015: FROM xle_entity_profiles xep,

2011: Begin
2012:
2013: SELECT xep.legal_entity_id
2014: into l_le_party_id
2015: FROM xle_entity_profiles xep,
2016: xle_registrations xr,
2017: xle_jurisdictions_vl jur,
2018: hr_locations hl,
2019: hz_geographies b,

Line 2029: AND xr.source_table = 'XLE_ENTITY_PROFILES'

2025: AND xep.geography_id = b.geography_id
2026: AND xr.location_id = hl.location_id
2027: AND xr.source_id = xep.legal_entity_id
2028: AND xr.identifying_flag='Y'
2029: AND xr.source_table = 'XLE_ENTITY_PROFILES'
2030: AND jur.jurisdiction_id=xr.jurisdiction_id
2031: AND l1.lookup_type = 'XLE_REG_CODE'
2032: AND jur.registration_code_le = l1.lookup_code
2033: AND hp.party_id = xep.party_id