APPS.PER_KW_XDO_REPORT dependencies on PER_DISABILITIES_F

Line 56: SELECT /*+ INDEX(disb, PER_DISABILITIES_F_PK) */ people.employee_number

52: AND hoi.org_information_context = 'CLASS'
53: AND hoi.org_information1 = 'HR_LEGAL_EMPLOYER';
54: rec_get_org_id csr_get_org_id%ROWTYPE;
55: CURSOR csr_get_dis_emp IS
56: SELECT /*+ INDEX(disb, PER_DISABILITIES_F_PK) */ people.employee_number
57: ,people.full_name
58: ,period.date_start
59: ,hr3.meaning disability_status
60: ,job.name job_name

Line 72: ,per_disabilities_f disb

68: ,disb.incident_id
69: ,disb.disability_id
70: FROM per_all_assignments_f assg
71: ,per_all_people_f people
72: ,per_disabilities_f disb
73: ,per_jobs job
74: ,per_all_positions pos
75: ,per_periods_of_service period
76: ,hr_lookups hr1