APPS.PAY_DK_ABSENCE_USER dependencies on PER_ALL_PEOPLE_F

Line 227: ,per_all_people_f per

223: , eev1.screen_entry_value screen_entry_value
224: , iv1.name
225: FROM per_all_assignments_f asg1
226: ,per_all_assignments_f asg2
227: ,per_all_people_f per
228: ,pay_element_links_f el
229: ,pay_element_types_f et
230: ,pay_input_values_f iv1
231: ,pay_element_entries_f ee

Line 475: ,per_all_people_f per

471: , eev1.screen_entry_value screen_entry_value
472: , iv1.name
473: FROM per_all_assignments_f asg1
474: ,per_all_assignments_f asg2
475: ,per_all_people_f per
476: ,pay_element_links_f el
477: ,pay_element_types_f et
478: ,pay_input_values_f iv1
479: ,pay_element_entries_f ee

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

595: FROM PER_ABSENCE_ATTENDANCES PAA
596: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
597:
598: CURSOR csr_person_details IS
599: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf
600: WHERE
601: paaf.assignment_id = p_assignment_id
602: AND p_date_earned BETWEEN paaf.effective_start_date AND paaf.effective_end_date
603: AND papf.person_id = paaf.person_id

Line 645: ,per_all_people_f per

641: , eev1.screen_entry_value screen_entry_value
642: , iv1.name
643: FROM per_all_assignments_f asg1
644: ,per_all_assignments_f asg2
645: ,per_all_people_f per
646: ,pay_element_links_f el
647: ,pay_element_types_f et
648: ,pay_input_values_f iv1
649: ,pay_element_entries_f ee

Line 798: ,per_all_people_f per

794: , eev1.screen_entry_value screen_entry_value
795: , iv1.name
796: FROM per_all_assignments_f asg1
797: ,per_all_assignments_f asg2
798: ,per_all_people_f per
799: ,pay_element_links_f el
800: ,pay_element_types_f et
801: ,pay_input_values_f iv1
802: ,pay_element_entries_f ee