DBA Data[Home] [Help]

APPS.XLE_UTILITIES_GRP dependencies on XLE_JURISDICTIONS_VL

Line 66: XLE_JURISDICTIONS_VL jur

62: hrl.country
63: FROM XLE_ENTITY_PROFILES lep,
64: XLE_REGISTRATIONS reg,
65: HR_LOCATIONS_ALL hrl,
66: XLE_JURISDICTIONS_VL jur
67: WHERE
68: lep.legal_entity_id = reg.source_id
69: AND reg.source_table = 'XLE_ENTITY_PROFILES'
70: AND hrl.location_id = reg.location_id

Line 115: XLE_JURISDICTIONS_VL jur

111: hrl.country
112: FROM XLE_ETB_PROFILES etb,
113: XLE_REGISTRATIONS reg,
114: HR_LOCATIONS_ALL hrl,
115: XLE_JURISDICTIONS_VL jur
116: WHERE
117: etb.establishment_id = reg.source_id
118: AND reg.source_table = 'XLE_ETB_PROFILES'
119: AND hrl.location_id = reg.location_id

Line 1928: XLE_JURISDICTIONS_VL jur

1924: CURSOR regnum_c IS
1925: SELECT reg.registration_number,jur.legislative_cat_code
1926: FROM XLE_ETB_PROFILES etbp,
1927: XLE_REGISTRATIONS reg,
1928: XLE_JURISDICTIONS_VL jur
1929: WHERE etbp.establishment_id = reg.source_id
1930: AND trunc(reg.source_table) = 'XLE_ETB_PROFILES'
1931: AND reg.jurisdiction_id = jur.jurisdiction_id
1932: AND etbp.party_id = p_party_id;