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_GB_STUDENT_LOANS_PKG dependencies on PER_ALL_PEOPLE_F

Line 636: from per_all_people_f papf,

632:
633: CURSOR get_main_count(p_asg_tax_ref IN VARCHAR2,p_person_id IN NUMBER,p_entry_value IN VARCHAR2) IS
634: SELECT /*+ ORDERED use_nl(papf, paaf1, paaf2, ppf, piv1, piv2, peef1, peef2, scl)*/
635: count(*) cnt
636: from per_all_people_f papf,
637: per_all_assignments_f paaf1,
638: per_all_assignments_f paaf2,
639: pay_all_payrolls_f ppf,
640: pay_input_values_f piv1 ,

Line 686: from per_all_people_f papf,

682:
683: CURSOR get_main_entry_count(p_asg_tax_ref IN VARCHAR2,p_person_id IN NUMBER) IS
684: SELECT /*+ ORDERED use_nl(papf, paaf1, paaf2, ppf, piv1, piv2, peef1, peef2, scl)*/
685: count(*) cnt
686: from per_all_people_f papf,
687: per_all_assignments_f paaf1,
688: per_all_assignments_f paaf2,
689: pay_all_payrolls_f ppf,
690: pay_input_values_f piv1 ,

Line 840: per_all_people_f papf

836: hr_soft_coding_keyflex scl,
837: pay_element_entries_f peef,
838: pay_element_entry_values_f peev,
839: pay_element_entry_values_f peev1,
840: per_all_people_f papf
841: WHERE
842: p_date_earned BETWEEN paaf1.effective_start_date and paaf1.effective_end_date
843: AND paaf1.person_id = paaf2.person_id
844: AND p_date_earned BETWEEN paaf2.effective_start_date and paaf2.effective_end_date

Line 992: per_all_people_f papf

988: hr_soft_coding_keyflex scl,
989: pay_element_entries_f peef,
990: pay_element_entry_values_f peev,
991: pay_element_entry_values_f peev1,
992: per_all_people_f papf
993: WHERE p_date_earned BETWEEN paaf1.effective_start_date and paaf1.effective_end_date
994: AND paaf1.person_id = paaf2.person_id
995: AND p_date_earned BETWEEN paaf2.effective_start_date and paaf2.effective_end_date
996: AND paaf2.payroll_id = ppf.payroll_id

Line 1149: per_all_people_f papf

1145: hr_soft_coding_keyflex scl,
1146: pay_element_entries_f peef,
1147: pay_element_entry_values_f peev,
1148: pay_element_entry_values_f peev1,
1149: per_all_people_f papf
1150: WHERE --paaf1.assignment_id = p_assignment_id AND
1151: p_date_earned BETWEEN paaf1.effective_start_date AND paaf1.effective_end_date
1152: AND paaf1.person_id = paaf2.person_id
1153: AND p_date_earned BETWEEN paaf2.effective_start_date AND paaf2.effective_end_date