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 638: from per_all_people_f papf,

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

Line 688: from per_all_people_f papf,

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

Line 842: per_all_people_f papf

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

Line 994: per_all_people_f papf

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

Line 1151: per_all_people_f papf

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