APPS.PAY_DK_ABSENCE_USER dependencies on PER_ALL_PEOPLE_F

Line 258: ,per_all_people_f per

254: , eev1.screen_entry_value screen_entry_value
255: , iv1.name
256: FROM per_all_assignments_f asg1
257: ,per_all_assignments_f asg2
258: ,per_all_people_f per
259: ,pay_element_links_f el
260: ,pay_element_types_f et
261: ,pay_input_values_f iv1
262: ,pay_element_entries_f ee

Line 510: ,per_all_people_f per

506: , eev1.screen_entry_value screen_entry_value
507: , iv1.name
508: FROM per_all_assignments_f asg1
509: ,per_all_assignments_f asg2
510: ,per_all_people_f per
511: ,pay_element_links_f el
512: ,pay_element_types_f et
513: ,pay_input_values_f iv1
514: ,pay_element_entries_f ee

Line 634: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf

630: FROM PER_ABSENCE_ATTENDANCES PAA
631: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
632:
633: CURSOR csr_person_details IS
634: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf
635: WHERE
636: paaf.assignment_id = p_assignment_id
637: AND p_date_earned BETWEEN paaf.effective_start_date AND paaf.effective_end_date
638: AND papf.person_id = paaf.person_id

Line 680: ,per_all_people_f per

676: , eev1.screen_entry_value screen_entry_value
677: , iv1.name
678: FROM per_all_assignments_f asg1
679: ,per_all_assignments_f asg2
680: ,per_all_people_f per
681: ,pay_element_links_f el
682: ,pay_element_types_f et
683: ,pay_input_values_f iv1
684: ,pay_element_entries_f ee

Line 833: ,per_all_people_f per

829: , eev1.screen_entry_value screen_entry_value
830: , iv1.name
831: FROM per_all_assignments_f asg1
832: ,per_all_assignments_f asg2
833: ,per_all_people_f per
834: ,pay_element_links_f el
835: ,pay_element_types_f et
836: ,pay_input_values_f iv1
837: ,pay_element_entries_f ee