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_AU_REC_DET_PAYSUM_MODE dependencies on PER_ASSIGNMENTS_F

Line 797: INDEX(paa per_assignments_f_fk1)

793: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
794: ,c_assignment_id varchar2
795: ) is
796: SELECT /*+ INDEX(pap per_people_f_pk)
797: INDEX(paa per_assignments_f_fk1)
798: INDEX(paa per_assignments_f_N12)
799: INDEX(rppa pay_payroll_actions_pk)
800: INDEX(pps per_periods_of_service_n3)
801: */ distinct paa.assignment_id

Line 798: INDEX(paa per_assignments_f_N12)

794: ,c_assignment_id varchar2
795: ) is
796: SELECT /*+ INDEX(pap per_people_f_pk)
797: INDEX(paa per_assignments_f_fk1)
798: INDEX(paa per_assignments_f_N12)
799: INDEX(rppa pay_payroll_actions_pk)
800: INDEX(pps per_periods_of_service_n3)
801: */ distinct paa.assignment_id
802: from per_people_f pap

Line 803: ,per_assignments_f paa

799: INDEX(rppa pay_payroll_actions_pk)
800: INDEX(pps per_periods_of_service_n3)
801: */ distinct paa.assignment_id
802: from per_people_f pap
803: ,per_assignments_f paa
804: ,pay_payroll_actions rppa
805: ,per_periods_of_service pps
806: where rppa.payroll_action_id = c_payroll_action_id
807: and pap.person_id between c_start_person and c_end_person

Line 817: From per_assignments_f iipaf

813: and nvl(pps.actual_termination_date, c_lst_year_start) >= c_lst_year_start
814: and c_fin_year_end between pap.effective_start_date and pap.effective_end_date
815: -- and least(nvl(pps.actual_termination_date,v_fin_year_end),v_fin_year_end) between a.effective_start_date and a.effective_end_date
816: and paa.effective_end_date = (select max(effective_end_date) /*4377367*/
817: From per_assignments_f iipaf
818: WHERE iipaf.assignment_id = paa.assignment_id
819: and iipaf.effective_end_date >= c_fbt_year_start
820: and iipaf.effective_start_date <= c_fin_year_end
821: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/

Line 825: FROM per_assignments_f paaf

821: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
822: and paa.payroll_id like c_payroll_id
823: and paa.assignment_id like c_assignment_id
824: AND EXISTS (SELECT /*+ ORDERED */''
825: FROM per_assignments_f paaf
826: ,pay_assignment_actions rpac
827: ,pay_payroll_actions rppa
828: WHERE rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
829: AND rppa.action_type in ('R','Q','B','I')

Line 839: FROM per_assignments_f paaf

835: AND paaf.assignment_id = paa.assignment_id
836: AND rppa.effective_date between paaf.effective_start_date AND paaf.effective_end_date
837: UNION
838: SELECT /*+ ORDERED */''
839: FROM per_assignments_f paaf
840: ,pay_assignment_actions rpac
841: ,pay_payroll_actions rppa
842: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
843: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end

Line 880: INDEX(paa per_assignments_f_fk1)

876: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
877: ,c_assignment_id varchar2
878: ) is
879: SELECT /*+ INDEX(pap per_people_f_pk)
880: INDEX(paa per_assignments_f_fk1)
881: INDEX(paa per_assignments_f_N12)
882: INDEX(rppa pay_payroll_actions_pk)
883: INDEX(pps per_periods_of_service_n3)
884: */ distinct paa.assignment_id

Line 881: INDEX(paa per_assignments_f_N12)

877: ,c_assignment_id varchar2
878: ) is
879: SELECT /*+ INDEX(pap per_people_f_pk)
880: INDEX(paa per_assignments_f_fk1)
881: INDEX(paa per_assignments_f_N12)
882: INDEX(rppa pay_payroll_actions_pk)
883: INDEX(pps per_periods_of_service_n3)
884: */ distinct paa.assignment_id
885: from per_people_f pap

Line 886: ,per_assignments_f paa

882: INDEX(rppa pay_payroll_actions_pk)
883: INDEX(pps per_periods_of_service_n3)
884: */ distinct paa.assignment_id
885: from per_people_f pap
886: ,per_assignments_f paa
887: ,pay_payroll_actions rppa
888: ,per_periods_of_service pps
889: where rppa.payroll_action_id = c_payroll_action_id
890: and pap.person_id between c_start_person and c_end_person

Line 900: From per_assignments_f iipaf

896: and nvl(pps.actual_termination_date, c_lst_year_start) >= c_lst_year_start
897: and c_fin_year_end between pap.effective_start_date and pap.effective_end_date
898: -- and least(nvl(pps.actual_termination_date,v_fin_year_end),v_fin_year_end) between a.effective_start_date and a.effective_end_date
899: and paa.effective_end_date = (select max(effective_end_date) /*4377367*/
900: From per_assignments_f iipaf
901: WHERE iipaf.assignment_id = paa.assignment_id
902: and iipaf.effective_end_date >= c_fbt_year_start
903: and iipaf.effective_start_date <= c_fin_year_end
904: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/

Line 908: FROM per_assignments_f paaf

904: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
905: and paa.payroll_id like c_payroll_id
906: and paa.assignment_id = c_assignment_id
907: AND EXISTS (SELECT /*+ ORDERED */''
908: FROM per_assignments_f paaf
909: ,pay_assignment_actions rpac
910: ,pay_payroll_actions rppa
911: WHERE rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
912: AND rppa.action_type in ('R','Q','B','I')

Line 922: FROM per_assignments_f paaf

918: AND paaf.assignment_id = paa.assignment_id
919: AND rppa.effective_date between paaf.effective_start_date AND paaf.effective_end_date
920: UNION
921: SELECT /*+ ORDERED */''
922: FROM per_assignments_f paaf
923: ,pay_assignment_actions rpac
924: ,pay_payroll_actions rppa
925: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
926: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end

Line 968: ,per_assignments_f paa

964: )
965: IS
966: SELECT paa.assignment_id
967: from per_people_f pap
968: ,per_assignments_f paa
969: ,pay_payroll_actions rppa
970: ,per_periods_of_service pps
971: ,pay_population_ranges ppr
972: WHERE rppa.payroll_action_id = c_payroll_action_id

Line 986: FROM per_assignments_f iipaf

982: AND rppa.business_group_id=paa.business_group_id
983: AND nvl(pps.actual_termination_date, c_lst_year_start) >= c_lst_year_start
984: AND c_fin_year_end between pap.effective_start_date AND pap.effective_end_date
985: AND paa.effective_end_date = (SELECT MAX(effective_end_date) /*4377367*/
986: FROM per_assignments_f iipaf
987: WHERE iipaf.assignment_id = paa.assignment_id
988: and iipaf.person_id = paa.person_id
989: AND iipaf.effective_end_date >= c_fbt_year_start
990: AND iipaf.effective_start_date <= c_fin_year_end

Line 995: FROM per_assignments_f paaf

991: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/
992: AND paa.payroll_id like c_payroll_id
993: AND paa.assignment_id like c_assignment_id
994: AND EXISTS (SELECT /*+ ORDERED */''
995: FROM per_assignments_f paaf
996: ,pay_assignment_actions rpac
997: ,pay_payroll_actions rppa
998: WHERE rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
999: AND rppa.action_type in ('R','Q','B','I')

Line 1009: FROM per_assignments_f paaf

1005: AND paaf.assignment_id = paa.assignment_id
1006: AND rppa.effective_date between paaf.effective_start_date AND paaf.effective_end_date
1007: UNION
1008: SELECT /*+ ORDERED */''
1009: FROM per_assignments_f paaf
1010: ,pay_assignment_actions rpac
1011: ,pay_payroll_actions rppa
1012: WHERE pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */
1013: AND rppa.effective_date between c_fbt_year_start AND c_fbt_year_end

Line 1294: per_assignments_f paa,

1290: hou.NAME organization_name,
1291: hou1.name legal_employer
1292: -- papf.payroll_name /*Bug 4688800*/
1293: from per_people_f pap,
1294: per_assignments_f paa,
1295: per_grades_tl pgr,
1296: per_periods_of_service pps,
1297: per_pay_bases ppb,
1298: per_pay_proposals pro,

Line 1321: from per_assignments_f

1317: -- and c_end_date between papf.effective_start_date and papf.effective_end_date /*Bug 4688800*/
1318: and pps.period_of_service_id = paa.period_of_service_id
1319: and paa.assignment_status_type_id = past.assignment_status_type_id
1320: and paa.effective_end_date = ( select max(effective_end_date)
1321: from per_assignments_f
1322: WHERE assignment_id = paa.assignment_id
1323: and effective_end_date >= c_start_date
1324: and effective_start_date <= c_end_date)
1325: and c_end_date between pap.effective_start_date and pap.effective_end_date

Line 1348: From per_assignments_f iipaf

1344: FROM per_all_assignments_f paaf,
1345: pay_payrolls_f pay
1346: WHERE paaf.assignment_id = c_assignment_id
1347: and paaf.effective_end_date = (select max(effective_end_date)
1348: From per_assignments_f iipaf
1349: WHERE iipaf.assignment_id = c_assignment_id
1350: and iipaf.effective_end_date >= c_start_date
1351: and iipaf.effective_start_date <= c_end_date
1352: AND iipaf.payroll_id IS NOT NULL)

Line 1375: per_assignments_f paf,

1371: paf.assignment_id,
1372: pps.date_start,
1373: pps.actual_termination_date
1374: from per_people_f pap,
1375: per_assignments_f paf,
1376: per_periods_of_service pps,
1377: pay_assignment_actions paa
1378: where pap.person_id = paf.person_id
1379: and paf.assignment_id = paa.assignment_id

Line 1385: from per_assignments_f

1381: and pps.period_of_service_id = paf.period_of_service_id
1382: and paf.business_group_id = c_business_group_id
1383: and paa.assignment_action_id = c_archive_assignment_action_id
1384: and paf.effective_end_date = ( select max(effective_end_date)
1385: from per_assignments_f
1386: WHERE assignment_id = paf.assignment_id
1387: and effective_end_date >= c_start_date
1388: and effective_start_date <= c_end_date)
1389: and c_end_date between pap.effective_start_date and pap.effective_end_date;

Line 1405: , per_assignments_f paf

1401: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1402: ,max(paa.action_sequence) action_sequence
1403: from pay_assignment_actions paa
1404: , pay_payroll_actions ppa
1405: , per_assignments_f paf
1406: where paa.assignment_id = paf.assignment_id
1407: and paf.assignment_id = c_assignment_id
1408: and paa.assignment_id = c_assignment_id
1409: and ppa.payroll_action_id = paa.payroll_action_id

Line 2196: , per_assignments_f paf

2192: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
2193: ,max(paa.action_sequence) action_sequence
2194: from pay_assignment_actions paa
2195: , pay_payroll_actions ppa
2196: , per_assignments_f paf
2197: where paa.assignment_id = paf.assignment_id
2198: and paf.assignment_id = c_assignment_id
2199: and paa.assignment_id = c_assignment_id
2200: and ppa.payroll_action_id = paa.payroll_action_id

Line 2494: ,per_assignments_f paaf

2490: ,pay_input_values_f piv1
2491: ,pay_element_classifications pec
2492: ,pay_assignment_actions paa
2493: ,pay_payroll_actions ppa
2494: ,per_assignments_f paaf
2495: ,pay_run_results prr
2496: ,pay_run_result_values prrv1
2497: ,pay_element_classifications pec2
2498: ,pay_sub_classification_rules_f pscr