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 467: per_all_assignments_f paaf

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

Line 534: FROM per_all_assignments_f paaf,

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

Line 562: FROM per_all_assignments_f papf,

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

Line 594: FROM per_all_assignments_f papf,

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

Line 639: per_all_assignments_f paaf1,

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

Line 640: per_all_assignments_f paaf2,

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 ,
643: pay_input_values_f piv2,
644: pay_element_entries_f peef1,

Line 689: per_all_assignments_f paaf1,

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

Line 690: per_all_assignments_f paaf2,

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 ,
693: pay_input_values_f piv2,
694: pay_element_entries_f peef1,

Line 735: FROM per_all_assignments_f paaf1,

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

Line 736: per_all_assignments_f paaf2,

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

Line 835: FROM per_all_assignments_f paaf1,

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

Line 836: per_all_assignments_f paaf2,

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

Line 869: FROM per_all_assignments_f paaf1,

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

Line 870: per_all_assignments_f paaf2,

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

Line 987: FROM per_all_assignments_f paaf1,

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

Line 988: per_all_assignments_f paaf2,

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

Line 1020: per_all_assignments_f paaf1,

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

Line 1021: per_all_assignments_f paaf2,

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

Line 1144: FROM per_all_assignments_f paaf1,

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

Line 1145: per_all_assignments_f paaf2,

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

Line 1180: per_all_assignments_f paaf1,

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

Line 1181: per_all_assignments_f paaf2,

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

Line 1363: from per_all_assignments_f paaf1,

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

Line 1364: per_all_assignments_f paaf2,

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

Line 1586: PER_ALL_ASSIGNMENTS_F PAAF,

1582: is
1583: SELECT MAX(ASSIGNMENT_ACTION_ID) assignment_action_id
1584: FROM PAY_PAYROLL_ACTIONS PPA,
1585: PAY_ASSIGNMENT_ACTIONS PAA,
1586: PER_ALL_ASSIGNMENTS_F PAAF,
1587: PER_TIME_PERIODS PTP
1588: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
1589: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE
1590: AND ptp.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID

Line 1592: AND PAAF.PERSON_ID in ( select PERSON_ID from per_all_assignments_f

1588: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
1589: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE
1590: AND ptp.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID
1591: AND PAA.ASSIGNMENT_ID = PAAF.ASSIGNMENT_ID
1592: AND PAAF.PERSON_ID in ( select PERSON_ID from per_all_assignments_f
1593: where assignment_id = p_assignment_id
1594: and p_date_earned between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE)
1595: AND PPA.ACTION_TYPE IN ('Q','R')
1596: AND PPA.EFFECTIVE_DATE BETWEEN p_start_date AND p_end_date

Line 1718: select assignment_id from per_all_assignments_f

1714: l_assignment_id number;
1715: --l_payroll_id number;
1716:
1717: Cursor c_get_all_assignments is
1718: select assignment_id from per_all_assignments_f
1719: where person_id in (select person_id from per_all_assignments_f
1720: where assignment_id = p_assignment_id
1721: and p_date_earned between effective_start_date and effective_end_date)
1722: and p_date_earned between effective_start_date and effective_end_date;

Line 1719: where person_id in (select person_id from per_all_assignments_f

1715: --l_payroll_id number;
1716:
1717: Cursor c_get_all_assignments is
1718: select assignment_id from per_all_assignments_f
1719: where person_id in (select person_id from per_all_assignments_f
1720: where assignment_id = p_assignment_id
1721: and p_date_earned between effective_start_date and effective_end_date)
1722: and p_date_earned between effective_start_date and effective_end_date;
1723: /*

Line 1783: payroll_id in (select payroll_id from per_all_assignments_f where assignment_id = p_asg_id

1779: is
1780: l_payroll varchar2(20);
1781: cursor c_payroll is
1782: select period_type from pay_payrolls_f where
1783: payroll_id in (select payroll_id from per_all_assignments_f where assignment_id = p_asg_id
1784: and p_date_earned between effective_start_date and effective_end_date)
1785: and p_date_earned between effective_start_date and effective_end_date;
1786:
1787: begin