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 1926: XLE_JURISDICTIONS_VL jur

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