DBA Data[Home] [Help]

APPS.PER_NO_SICKLEAVEMONITORING dependencies on HR_ORGANIZATION_INFORMATION

Line 123: ,hr_organization_information hoi

119: ,per_all_assignments_f paaf
120: ,per_assignment_status_types past
121: ,per_all_people_f papf
122: ,hr_soft_coding_keyflex hsc
123: ,hr_organization_information hoi
124: WHERE paa.person_id = papf.person_id
125: AND paa.absence_attendance_type_id = paat.absence_attendance_type_id
126: AND paaf.person_id = papf.person_id
127: AND paaf.assignment_status_type_id = past.assignment_status_type_id

Line 320: FROM hr_organization_information

316: ,3,org_information3
317: ,4,org_information4
318: ,5,org_information5
319: ,9999) days
320: FROM hr_organization_information
321: WHERE organization_id = c_org_id
322: AND org_information_context = 'NO_SLM_OVERRIDE';
323:
324: DAYS NUMBER :=9999;