APPS.JG_ZZ_COMMON_PKG dependencies on XLE_ENTITY_PROFILES

Line 287: ,xle_entity_profiles XEP

283: ,hp.party_id
284: -- Adding code for the GLOB006-ER
285: ,HL.region_1
286: FROM xle_registrations XR
287: ,xle_entity_profiles XEP
288: ,hr_locations_all HL
289: ,hz_parties HP
290: ,fnd_territories_vl FT
291: WHERE XR.source_id = XEP.legal_entity_id

Line 292: AND XR.source_table = 'XLE_ENTITY_PROFILES'

288: ,hr_locations_all HL
289: ,hz_parties HP
290: ,fnd_territories_vl FT
291: WHERE XR.source_id = XEP.legal_entity_id
292: AND XR.source_table = 'XLE_ENTITY_PROFILES'
293: AND XEP.legal_entity_id = pn_legal_entity_id
294: AND XR.location_id = HL.location_id
295: AND HL.country = FT.TERRITORY_CODE
296: AND XEP.party_id = HP.party_id

Line 334: from XLE_REGISTRATIONS xler, XLE_JURISDICTIONS_B xlej, xle_entity_profiles xlee

330:
331: /* Added for GLOBE-006 ER*/
332: CURSOR lc_commercial_num IS
333: select nvl(xler.registration_number,'') commercial_number
334: from XLE_REGISTRATIONS xler, XLE_JURISDICTIONS_B xlej, xle_entity_profiles xlee
335: where xlej.JURISDICTION_ID= xler.JURISDICTION_ID
336: and xlej.LEGISLATIVE_CAT_CODE = 'COMMERCIAL_LAW'
337: AND xler.source_id = xlee.LEGAL_ENTITY_ID
338: AND xler.source_TABLE = 'XLE_ENTITY_PROFILES'

Line 338: AND xler.source_TABLE = 'XLE_ENTITY_PROFILES'

334: from XLE_REGISTRATIONS xler, XLE_JURISDICTIONS_B xlej, xle_entity_profiles xlee
335: where xlej.JURISDICTION_ID= xler.JURISDICTION_ID
336: and xlej.LEGISLATIVE_CAT_CODE = 'COMMERCIAL_LAW'
337: AND xler.source_id = xlee.LEGAL_ENTITY_ID
338: AND xler.source_TABLE = 'XLE_ENTITY_PROFILES'
339: and xlee.legal_entity_id = pn_legal_entity_id;
340:
341: ln_party_id HZ_PARTIES.party_id%TYPE;
342:

Line 510: ,xle_entity_profiles XEP

506:
507: SELECT HL.country
508: INTO l_country_code
509: FROM xle_registrations XR
510: ,xle_entity_profiles XEP
511: ,hr_locations_all HL
512: WHERE XR.source_id = XEP.legal_entity_id
513: AND XR.source_table = 'XLE_ENTITY_PROFILES'
514: AND XEP.legal_entity_id = p_legal_entity_id

Line 513: AND XR.source_table = 'XLE_ENTITY_PROFILES'

509: FROM xle_registrations XR
510: ,xle_entity_profiles XEP
511: ,hr_locations_all HL
512: WHERE XR.source_id = XEP.legal_entity_id
513: AND XR.source_table = 'XLE_ENTITY_PROFILES'
514: AND XEP.legal_entity_id = p_legal_entity_id
515: AND XR.location_id = HL.location_id
516: AND xr.identifying_flag = 'Y';
517: