APPS.PAY_FR_SICKNESS_CALC dependencies on PER_ALL_ASSIGNMENTS_F

Line 221: per_all_assignments_f pasg

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
225: AND papf.person_id = pasg.person_id

Line 333: per_all_assignments_f pasg

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
337: AND papf.person_id = pasg.person_id

Line 3274: per_all_assignments_f pas

3270: INTO l_svc_in_years
3271: --l_parent_absence_start_date
3272: FROM per_absence_attendances paa,
3273: per_periods_of_service ps,
3274: per_all_assignments_f pas
3275: WHERE ps.person_id = pas.person_id
3276: AND pas.assignment_id = l_assgt_id
3277: AND paa.absence_attendance_id = l_parent_absence_id
3278: AND paa.person_id = pas.person_id

Line 4077: per_all_assignments_f pasg,

4073: , nvl(abs_information2, 'Y') subrogated
4074: , nvl(pabs.abs_information8, 'N') estimated
4075: , nvl(pwi.inc_information1,'N') work_incident
4076: from per_absence_attendances pabs,
4077: per_all_assignments_f pasg,
4078: per_absence_attendance_types pabt,
4079: per_work_incidents pwi
4080: where pabs.business_group_id = p_business_group_id
4081: and pabs.abs_information_category ='FR_S'