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.PAY_FR_SICKNESS_CALC dependencies on PER_ALL_PEOPLE_F

Line 220: FROM per_all_people_f papf,

216:
217: -- Cursor to retrieve person's hiredate
218: Cursor csr_hiredate IS
219: SELECT papf.original_date_of_hire
220: FROM per_all_people_f papf,
221: per_all_assignments_f pasg
222: WHERE pasg.assignment_id = p_assignment_id
223: AND pasg.Business_group_id= p_business_group_id
224: AND p_absence_start_date BETWEEN pasg.effective_start_date and pasg.effective_end_date

Line 332: FROM per_all_people_f papf,

328:
329: -- Cursor to retrive person's hiredate
330: Cursor csr_hiredate IS
331: SELECT papf.original_date_of_hire
332: FROM per_all_people_f papf,
333: per_all_assignments_f pasg
334: WHERE pasg.assignment_id = p_assignment_id
335: AND pasg.Business_group_id= p_Business_group_id
336: AND p_absence_start_date BETWEEN pasg.effective_start_date and pasg.effective_end_date

Line 835: per_all_people_f papf

831: pabs.abs_information1 parent_abs,
832: papf.original_date_of_hire hiredate,
833: pabs.date_start abs_start
834: FROM per_absence_attendances pabs,
835: per_all_people_f papf
836: WHERE pabs.absence_attendance_id = p_absence_id
837: AND pabs.business_group_id = p_business_group_id
838: AND pabs.abs_information_category ='FR_S'
839: AND papf.person_id = pabs.person_id