eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_WSP_LOOKUP dependencies on HR_ORGANIZATION_INFORMATION

Line 259: , HR_ORGANIZATION_INFORMATION org_i

255: OAV_TL.LANGUAGE,
256: OAV_TL.Source_Lang
257: From OTA_ACTIVITY_VERSIONS OAV
258: , OTA_ACTIVITY_VERSIONS_TL OAV_TL
259: , HR_ORGANIZATION_INFORMATION org_i
260: Where OAV.BUSINESS_GROUP_ID = org_i.ORGANIZATION_ID
261: and org_i.ORG_INFORMATION_CONTEXT = 'Business Group Information'
262: And org_i.ORG_INFORMATION9 = 'ZA'
263: and OAV.START_DATE <= p_end_date

Line 285: , HR_ORGANIZATION_INFORMATION org_i

281: OLP_TL.LANGUAGE,
282: OLP_TL.Source_Lang
283: From OTA_LEARNING_PATHS OLP
284: , OTA_LEARNING_PATHS_TL OLP_TL
285: , HR_ORGANIZATION_INFORMATION org_i
286: Where OLP.business_group_id = org_i.ORGANIZATION_ID
287: and org_i.ORG_INFORMATION_CONTEXT = 'Business Group Information'
288: And org_i.ORG_INFORMATION9 = 'ZA'
289: And OLP.path_source_code = 'CATALOG' --Only for Bg level not at Mgr /Emp/Appriasal

Line 311: , HR_ORGANIZATION_INFORMATION org_i

307: OC_TL.LANGUAGE,
308: OC_TL.Source_Lang
309: From OTA_CERTIFICATIONS_B OC
310: , OTA_CERTIFICATIONS_TL OC_TL
311: , HR_ORGANIZATION_INFORMATION org_i
312: Where OC.business_group_id = org_i.ORGANIZATION_ID
313: and org_i.ORG_INFORMATION_CONTEXT = 'Business Group Information'
314: And org_i.ORG_INFORMATION9 = 'ZA'
315: And OC.START_DATE_ACTIVE <= p_end_date

Line 347: HR_ORGANIZATION_INFORMATION org_i

343: OR PC.DATE_TO is null)
344: and (nvl(PC.business_group_id,0) =0
345: Or exists
346: ( Select 1 from
347: HR_ORGANIZATION_INFORMATION org_i
348: Where PC.business_group_id = org_i.ORGANIZATION_ID
349: And org_i.ORG_INFORMATION_CONTEXT = 'Business Group Information'
350: And org_i.ORG_INFORMATION9 = 'ZA')
351: )

Line 355: , HR_ORGANIZATION_INFORMATION org_i

351: )
352: And exists
353: ( Select 1 from
354: Per_competence_elements pce
355: , HR_ORGANIZATION_INFORMATION org_i
356: , per_all_people_f pp
357: , per_all_assignments_f paa
358: Where pce.competence_id = pc.COMPETENCE_ID
359: And pce.type = 'PERSONAL'

Line 401: , HR_ORGANIZATION_INFORMATION org_i

397: per_qualifications pq
398: , PER_ESTABLISHMENT_ATTENDANCES pea
399: , per_all_people_f pp
400: , per_all_assignments_f paa
401: , HR_ORGANIZATION_INFORMATION org_i
402: Where pqt.qualification_type_id = pq.qualification_type_id
403: And paa.person_id = pp.person_id
404: and paa.assignment_type = 'E'
405: and paa.primary_flag = 'Y'

Line 449: , HR_ORGANIZATION_INFORMATION org_i

445: Select count(*)
446: into l_count
447: From
448: OTA_LP_ENROLLMENTS OLE
449: , HR_ORGANIZATION_INFORMATION org_i
450: , OTA_LP_MEMBER_ENROLLMENTS OLME
451: , per_all_people_f pp
452: , per_all_assignments_f paa
453: Where OLE.LEARNING_PATH_ID = lp_rec.LOOKUP_CODE

Line 510: , HR_ORGANIZATION_INFORMATION org_i

506: from
507: OTA_EVENTS oe
508: , OTA_DELEGATE_BOOKINGS odb
509: , OTA_BOOKING_STATUS_TYPES obst
510: , HR_ORGANIZATION_INFORMATION org_i
511: , per_all_people_f pp
512: , per_all_assignments_f paa
513: wHERE ACTIVITY_VERSION_ID = course_rec.LOOKUP_CODE
514: aND oe.EVENT_TYPE in ( 'SCHEDULED', 'SELFPACED')

Line 572: , HR_ORGANIZATION_INFORMATION org_i

568: Select count(*)
569: into l_count
570: From
571: OTA_CERT_ENROLLMENTS OCE
572: , HR_ORGANIZATION_INFORMATION org_i
573: , per_all_people_f pp
574: , per_all_assignments_f paa
575: Where
576: OCE.CERTIFICATION_ID = cert_rec.LOOKUP_CODE

Line 645: , HR_ORGANIZATION_INFORMATION org_i

641: Select count(*)
642: into l_count
643: From
644: OTA_LP_ENROLLMENTS OLE
645: , HR_ORGANIZATION_INFORMATION org_i
646: , OTA_LP_MEMBER_ENROLLMENTS OLME
647: Where OLE.LEARNING_PATH_ID = lp_rec.LOOKUP_CODE
648: And OLE.PATH_STATUS_CODE = 'COMPLETED'
649: And OLME.LP_ENROLLMENT_ID = OLE.LP_ENROLLMENT_ID

Line 697: , HR_ORGANIZATION_INFORMATION org_i

693: from
694: OTA_EVENTS oe
695: , OTA_DELEGATE_BOOKINGS odb
696: , OTA_BOOKING_STATUS_TYPES obst
697: , HR_ORGANIZATION_INFORMATION org_i
698: , per_all_people_f pp
699: , per_all_assignments_f paa
700: wHERE ACTIVITY_VERSION_ID = course_rec.LOOKUP_CODE
701: aND oe.EVENT_TYPE in ( 'SCHEDULED', 'SELFPACED')

Line 761: , HR_ORGANIZATION_INFORMATION org_i

757: Select count(*)
758: into l_count
759: From
760: OTA_CERT_ENROLLMENTS OCE
761: , HR_ORGANIZATION_INFORMATION org_i
762: Where
763: OCE.CERTIFICATION_ID = cert_rec.LOOKUP_CODE
764: And OCE.BUSINESS_GROUP_ID = org_i.ORGANIZATION_ID
765: And OCE.CERTIFICATION_STATUS_CODE = 'CERTIFIED'

Line 1859: from hr_organization_information org_Legal_ent

1855: Select org_unit.organization_id
1856: , org_unit.organization_id || '_' || substr(org_unit_tl.NAME,1,79 - length(org_unit.organization_id)) user_column_name
1857: , org_unit.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
1858: , org_bg.ORG_INFORMATION9 legislation_code
1859: from hr_organization_information org_Legal_ent
1860: , hr_all_organization_units org_unit
1861: , hr_organization_information org_bg
1862: , hr_all_organization_units_tl org_unit_tl
1863: Where org_Legal_ent.ORG_INFORMATION_CONTEXT = 'CLASS'

Line 1861: , hr_organization_information org_bg

1857: , org_unit.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
1858: , org_bg.ORG_INFORMATION9 legislation_code
1859: from hr_organization_information org_Legal_ent
1860: , hr_all_organization_units org_unit
1861: , hr_organization_information org_bg
1862: , hr_all_organization_units_tl org_unit_tl
1863: Where org_Legal_ent.ORG_INFORMATION_CONTEXT = 'CLASS'
1864: And org_Legal_ent.ORG_INFORMATION1 = 'HR_LEGAL'
1865: and org_Legal_ent.ORGANIZATION_ID = org_unit.ORGANIZATION_ID