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_ASSIGNMENTS_F

Line 465: per_all_assignments_f paaf

461: SELECT scl.segment1
462: FROM hr_soft_coding_keyflex scl,
463: fnd_sessions fs,
464: pay_payrolls_f ppf,
465: per_all_assignments_f paaf
466: WHERE paaf.assignment_id = p_assignment_id
467: AND fs.session_id = userenv('sessionid')
468: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
469: AND ppf.payroll_id = paaf.payroll_id

Line 532: FROM per_all_assignments_f paaf,

528: FUNCTION get_person_id(p_assignment_id IN NUMBER) RETURN NUMBER IS
529:
530: CURSOR get_person(p_assignment_id IN NUMBER) IS
531: SELECT person_id
532: FROM per_all_assignments_f paaf,
533: fnd_sessions fs
534: WHERE fs.session_id = userenv('sessionid')
535: AND paaf.assignment_id =p_assignment_id
536: AND fs.effective_date between paaf.effective_start_date and paaf.effective_end_date;

Line 560: FROM per_all_assignments_f papf,

556: ) RETURN NUMBER IS
557:
558: CURSOR get_freq IS
559: SELECT ptpt.number_per_fiscal_year
560: FROM per_all_assignments_f papf,
561: pay_all_payrolls_f pap,
562: per_time_period_types ptpt
563: WHERE papf.assignment_id = p_assignment_id
564: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date

Line 592: FROM per_all_assignments_f papf,

588: ) RETURN DATE IS
589:
590: CURSOR get_curr_pay_date IS
591: SELECT nvl(ptp.regular_payment_date , to_date('01-01-0001','DD-MM-YYYY'))
592: FROM per_all_assignments_f papf,
593: pay_all_payrolls_f pap,
594: per_time_periods ptp
595: WHERE papf.assignment_id = p_assignment_id
596: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date

Line 637: per_all_assignments_f paaf1,

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 ,
641: pay_input_values_f piv2,

Line 638: per_all_assignments_f paaf2,

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 ,
641: pay_input_values_f piv2,
642: pay_element_entries_f peef1,

Line 687: per_all_assignments_f paaf1,

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 ,
691: pay_input_values_f piv2,

Line 688: per_all_assignments_f paaf2,

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 ,
691: pay_input_values_f piv2,
692: pay_element_entries_f peef1,

Line 733: FROM per_all_assignments_f paaf1,

729:
730: --
731: CURSOR chk_prim_asg(p_asg_tax_ref IN VARCHAR2) IS
732: SELECT 1 cnt
733: FROM per_all_assignments_f paaf1,
734: per_all_assignments_f paaf2,
735: pay_all_payrolls_f ppf,
736: hr_soft_coding_keyflex scl,
737: pay_element_entries_f peef,

Line 734: per_all_assignments_f paaf2,

730: --
731: CURSOR chk_prim_asg(p_asg_tax_ref IN VARCHAR2) IS
732: SELECT 1 cnt
733: FROM per_all_assignments_f paaf1,
734: per_all_assignments_f paaf2,
735: pay_all_payrolls_f ppf,
736: hr_soft_coding_keyflex scl,
737: pay_element_entries_f peef,
738: pay_element_entry_values_f peev

Line 833: FROM per_all_assignments_f paaf1,

829: AND p_date_earned =ptp.regular_payment_date;
830:
831: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) is
832: SELECT ppf.payroll_id
833: FROM per_all_assignments_f paaf1,
834: per_all_assignments_f paaf2,
835: pay_all_payrolls_f ppf,
836: hr_soft_coding_keyflex scl,
837: pay_element_entries_f peef,

Line 834: per_all_assignments_f paaf2,

830:
831: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) is
832: SELECT ppf.payroll_id
833: FROM per_all_assignments_f paaf1,
834: per_all_assignments_f paaf2,
835: pay_all_payrolls_f ppf,
836: hr_soft_coding_keyflex scl,
837: pay_element_entries_f peef,
838: pay_element_entry_values_f peev,

Line 867: FROM per_all_assignments_f paaf1,

863:
864:
865: CURSOR get_prim_payroll_id(p_asg_tax_ref VARCHAR2) IS
866: SELECT ppf.payroll_id
867: FROM per_all_assignments_f paaf1,
868: per_all_assignments_f paaf2,
869: pay_all_payrolls_f ppf,
870: hr_soft_coding_keyflex scl,
871: pay_element_entries_f peef,

Line 868: per_all_assignments_f paaf2,

864:
865: CURSOR get_prim_payroll_id(p_asg_tax_ref VARCHAR2) IS
866: SELECT ppf.payroll_id
867: FROM per_all_assignments_f paaf1,
868: per_all_assignments_f paaf2,
869: pay_all_payrolls_f ppf,
870: hr_soft_coding_keyflex scl,
871: pay_element_entries_f peef,
872: pay_element_entry_values_f peev

Line 985: FROM per_all_assignments_f paaf1,

981:
982: --
983: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2, p_person_id NUMBER) IS
984: SELECT ppf.payroll_id
985: FROM per_all_assignments_f paaf1,
986: per_all_assignments_f paaf2,
987: pay_all_payrolls_f ppf,
988: hr_soft_coding_keyflex scl,
989: pay_element_entries_f peef,

Line 986: per_all_assignments_f paaf2,

982: --
983: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2, p_person_id NUMBER) IS
984: SELECT ppf.payroll_id
985: FROM per_all_assignments_f paaf1,
986: per_all_assignments_f paaf2,
987: pay_all_payrolls_f ppf,
988: hr_soft_coding_keyflex scl,
989: pay_element_entries_f peef,
990: pay_element_entry_values_f peev,

Line 1018: per_all_assignments_f paaf1,

1014: --
1015: CURSOR get_prim_payroll_id(p_asg_tax_ref VARCHAR2) IS
1016: SELECT ppf.payroll_id
1017: FROM fnd_sessions fs,
1018: per_all_assignments_f paaf1,
1019: per_all_assignments_f paaf2,
1020: pay_all_payrolls_f ppf,
1021: hr_soft_coding_keyflex scl,
1022: pay_element_entries_f peef,

Line 1019: per_all_assignments_f paaf2,

1015: CURSOR get_prim_payroll_id(p_asg_tax_ref VARCHAR2) IS
1016: SELECT ppf.payroll_id
1017: FROM fnd_sessions fs,
1018: per_all_assignments_f paaf1,
1019: per_all_assignments_f paaf2,
1020: pay_all_payrolls_f ppf,
1021: hr_soft_coding_keyflex scl,
1022: pay_element_entries_f peef,
1023: pay_element_entry_values_f peev

Line 1142: FROM per_all_assignments_f paaf1,

1138: l_person_id NUMBER;
1139:
1140: CURSOR get_main_entry_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) IS
1141: SELECT peef.element_entry_id
1142: FROM per_all_assignments_f paaf1,
1143: per_all_assignments_f paaf2,
1144: pay_all_payrolls_f ppf,
1145: hr_soft_coding_keyflex scl,
1146: pay_element_entries_f peef,

Line 1143: per_all_assignments_f paaf2,

1139:
1140: CURSOR get_main_entry_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) IS
1141: SELECT peef.element_entry_id
1142: FROM per_all_assignments_f paaf1,
1143: per_all_assignments_f paaf2,
1144: pay_all_payrolls_f ppf,
1145: hr_soft_coding_keyflex scl,
1146: pay_element_entries_f peef,
1147: pay_element_entry_values_f peev,

Line 1178: per_all_assignments_f paaf1,

1174: --
1175: CURSOR chk_prim_entry_id(p_asg_tax_ref VARCHAR2) IS
1176: SELECT peef.element_entry_id
1177: FROM
1178: per_all_assignments_f paaf1,
1179: per_all_assignments_f paaf2,
1180: pay_all_payrolls_f ppf,
1181: hr_soft_coding_keyflex scl,
1182: pay_element_entries_f peef,

Line 1179: per_all_assignments_f paaf2,

1175: CURSOR chk_prim_entry_id(p_asg_tax_ref VARCHAR2) IS
1176: SELECT peef.element_entry_id
1177: FROM
1178: per_all_assignments_f paaf1,
1179: per_all_assignments_f paaf2,
1180: pay_all_payrolls_f ppf,
1181: hr_soft_coding_keyflex scl,
1182: pay_element_entries_f peef,
1183: pay_element_entry_values_f peev

Line 1361: from per_all_assignments_f paaf1,

1357:
1358: CURSOR get_main_value(p_asg_tax_ref IN VARCHAR2) IS
1359: SELECT /*+ ORDERED use_nl(paaf1, paaf2, ppf, piv1, piv2, peef1, peef2, scl)*/
1360: peev2.screen_entry_value main_entry_value
1361: from per_all_assignments_f paaf1,
1362: per_all_assignments_f paaf2,
1363: pay_all_payrolls_f ppf,
1364: pay_input_values_f piv1 ,
1365: pay_input_values_f piv2,

Line 1362: per_all_assignments_f paaf2,

1358: CURSOR get_main_value(p_asg_tax_ref IN VARCHAR2) IS
1359: SELECT /*+ ORDERED use_nl(paaf1, paaf2, ppf, piv1, piv2, peef1, peef2, scl)*/
1360: peev2.screen_entry_value main_entry_value
1361: from per_all_assignments_f paaf1,
1362: per_all_assignments_f paaf2,
1363: pay_all_payrolls_f ppf,
1364: pay_input_values_f piv1 ,
1365: pay_input_values_f piv2,
1366: pay_element_entries_f peef1,