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 450: INDEX(paa per_assignments_f_fk1)

446: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
447: ,c_assignment_id varchar2
448: ) is
449: SELECT /*+ INDEX(pap per_people_f_pk)
450: INDEX(paa per_assignments_f_fk1)
451: INDEX(paa per_assignments_f_N12)
452: INDEX(rppa pay_payroll_actions_pk)
453: INDEX(pps per_periods_of_service_n3)
454: */ distinct paa.assignment_id

Line 451: INDEX(paa per_assignments_f_N12)

447: ,c_assignment_id varchar2
448: ) is
449: SELECT /*+ INDEX(pap per_people_f_pk)
450: INDEX(paa per_assignments_f_fk1)
451: INDEX(paa per_assignments_f_N12)
452: INDEX(rppa pay_payroll_actions_pk)
453: INDEX(pps per_periods_of_service_n3)
454: */ distinct paa.assignment_id
455: from per_people_f pap

Line 456: ,per_assignments_f paa

452: INDEX(rppa pay_payroll_actions_pk)
453: INDEX(pps per_periods_of_service_n3)
454: */ distinct paa.assignment_id
455: from per_people_f pap
456: ,per_assignments_f paa
457: ,pay_payroll_actions rppa
458: ,per_periods_of_service pps
459: where rppa.payroll_action_id = c_payroll_action_id
460: and pap.person_id between c_start_person and c_end_person

Line 470: From per_assignments_f iipaf

466: and nvl(pps.actual_termination_date, c_lst_year_start) >= c_lst_year_start
467: and c_fin_year_end between pap.effective_start_date and pap.effective_end_date
468: -- 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
469: and paa.effective_end_date = (select max(effective_end_date) /*4377367*/
470: From per_assignments_f iipaf
471: WHERE iipaf.assignment_id = paa.assignment_id
472: and iipaf.effective_end_date >= c_fbt_year_start
473: and iipaf.effective_start_date <= c_fin_year_end
474: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/

Line 481: FROM per_assignments_f paaf

477: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
478: INDEX(rpac pay_assignment_actions_n1)
479: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
480: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
481: FROM per_assignments_f paaf
482: ,pay_payroll_actions rppa
483: ,pay_assignment_actions rpac
484: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
485: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */

Line 524: INDEX(paa per_assignments_f_fk1)

520: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
521: ,c_assignment_id varchar2
522: ) is
523: SELECT /*+ INDEX(pap per_people_f_pk)
524: INDEX(paa per_assignments_f_fk1)
525: INDEX(paa per_assignments_f_N12)
526: INDEX(rppa pay_payroll_actions_pk)
527: INDEX(pps per_periods_of_service_n3)
528: */ distinct paa.assignment_id

Line 525: INDEX(paa per_assignments_f_N12)

521: ,c_assignment_id varchar2
522: ) is
523: SELECT /*+ INDEX(pap per_people_f_pk)
524: INDEX(paa per_assignments_f_fk1)
525: INDEX(paa per_assignments_f_N12)
526: INDEX(rppa pay_payroll_actions_pk)
527: INDEX(pps per_periods_of_service_n3)
528: */ distinct paa.assignment_id
529: from per_people_f pap

Line 530: ,per_assignments_f paa

526: INDEX(rppa pay_payroll_actions_pk)
527: INDEX(pps per_periods_of_service_n3)
528: */ distinct paa.assignment_id
529: from per_people_f pap
530: ,per_assignments_f paa
531: ,pay_payroll_actions rppa
532: ,per_periods_of_service pps
533: where rppa.payroll_action_id = c_payroll_action_id
534: and pap.person_id between c_start_person and c_end_person

Line 544: From per_assignments_f iipaf

540: and nvl(pps.actual_termination_date, c_lst_year_start) >= c_lst_year_start
541: and c_fin_year_end between pap.effective_start_date and pap.effective_end_date
542: -- 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
543: and paa.effective_end_date = (select max(effective_end_date) /*4377367*/
544: From per_assignments_f iipaf
545: WHERE iipaf.assignment_id = paa.assignment_id
546: and iipaf.effective_end_date >= c_fbt_year_start
547: and iipaf.effective_start_date <= c_fin_year_end
548: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/

Line 555: FROM per_assignments_f paaf

551: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
552: INDEX(rpac pay_assignment_actions_n1)
553: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
554: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
555: FROM per_assignments_f paaf
556: ,pay_payroll_actions rppa
557: ,pay_assignment_actions rpac
558: where (rppa.effective_date between c_fin_year_start and c_fin_year_end /*Bug3048962 */
559: or ( pps.actual_termination_date between c_lst_fbt_yr_start and c_fbt_year_end /*Bug3263659 */

Line 604: INDEX(paa per_assignments_f_N12)

600: IS
601: SELECT /*+ INDEX(pap per_people_f_pk)
602: INDEX(rppa pay_payroll_actions_pk)
603: INDEX(ppr PAY_POPULATION_RANGES_N4)
604: INDEX(paa per_assignments_f_N12)
605: INDEX(pps per_periods_of_service_PK)
606: */ paa.assignment_id
607: from per_people_f pap
608: ,per_assignments_f paa

Line 608: ,per_assignments_f paa

604: INDEX(paa per_assignments_f_N12)
605: INDEX(pps per_periods_of_service_PK)
606: */ paa.assignment_id
607: from per_people_f pap
608: ,per_assignments_f paa
609: ,pay_payroll_actions rppa
610: ,per_periods_of_service pps
611: ,pay_population_ranges ppr
612: WHERE rppa.payroll_action_id = c_payroll_action_id

Line 624: FROM per_assignments_f iipaf

620: AND rppa.business_group_id=paa.business_group_id
621: AND nvl(pps.actual_termination_date, c_lst_year_start) >= c_lst_year_start
622: AND c_fin_year_end between pap.effective_start_date AND pap.effective_end_date
623: AND paa.effective_end_date = (SELECT MAX(effective_end_date) /*4377367*/
624: FROM per_assignments_f iipaf
625: WHERE iipaf.assignment_id = paa.assignment_id
626: AND iipaf.effective_end_date >= c_fbt_year_start
627: AND iipaf.effective_start_date <= c_fin_year_end
628: AND iipaf.payroll_id IS NOT NULL) /*Bug 4688800*/

Line 634: FROM per_assignments_f paaf

630: AND paa.assignment_id like c_assignment_id
631: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
632: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
633: */''
634: FROM per_assignments_f paaf
635: ,pay_payroll_actions rppa
636: ,pay_assignment_actions rpac
637: WHERE (rppa.effective_date between c_fin_year_start AND c_fin_year_end /*Bug3048962 */
638: or ( pps.actual_termination_date between c_lst_fbt_yr_start AND c_fbt_year_end /*Bug3263659 */

Line 920: per_assignments_f paa,

916: hou.NAME organization_name,
917: hou1.name legal_employer
918: -- papf.payroll_name /*Bug 4688800*/
919: from per_people_f pap,
920: per_assignments_f paa,
921: per_grades_tl pgr,
922: per_periods_of_service pps,
923: per_pay_bases ppb,
924: per_pay_proposals pro,

Line 947: from per_assignments_f

943: -- and c_end_date between papf.effective_start_date and papf.effective_end_date /*Bug 4688800*/
944: and pps.period_of_service_id = paa.period_of_service_id
945: and paa.assignment_status_type_id = past.assignment_status_type_id
946: and paa.effective_end_date = ( select max(effective_end_date)
947: from per_assignments_f
948: WHERE assignment_id = paa.assignment_id
949: and effective_end_date >= c_start_date
950: and effective_start_date <= c_end_date)
951: and c_end_date between pap.effective_start_date and pap.effective_end_date

Line 973: From per_assignments_f iipaf

969: FROM per_all_assignments_f paaf,
970: pay_payrolls_f pay
971: WHERE paaf.assignment_id = c_assignment_id
972: and paaf.effective_end_date = (select max(effective_end_date)
973: From per_assignments_f iipaf
974: WHERE iipaf.assignment_id = c_assignment_id
975: and iipaf.effective_end_date >= c_start_date
976: and iipaf.effective_start_date <= c_end_date
977: AND iipaf.payroll_id IS NOT NULL)

Line 1000: per_assignments_f paf,

996: paf.assignment_id,
997: pps.date_start,
998: pps.actual_termination_date
999: from per_people_f pap,
1000: per_assignments_f paf,
1001: per_periods_of_service pps,
1002: pay_assignment_actions paa
1003: where pap.person_id = paf.person_id
1004: and paf.assignment_id = paa.assignment_id

Line 1010: from per_assignments_f

1006: and pps.period_of_service_id = paf.period_of_service_id
1007: and paf.business_group_id = c_business_group_id
1008: and paa.assignment_action_id = c_archive_assignment_action_id
1009: and paf.effective_end_date = ( select max(effective_end_date)
1010: from per_assignments_f
1011: WHERE assignment_id = paf.assignment_id
1012: and effective_end_date >= c_start_date
1013: and effective_start_date <= c_end_date)
1014: and c_end_date between pap.effective_start_date and pap.effective_end_date;

Line 1030: , per_assignments_f paf

1026: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1027: ,max(paa.action_sequence) action_sequence
1028: from pay_assignment_actions paa
1029: , pay_payroll_actions ppa
1030: , per_assignments_f paf
1031: where paa.assignment_id = paf.assignment_id
1032: and paf.assignment_id = c_assignment_id
1033: and ppa.payroll_action_id = paa.payroll_action_id
1034: and ppa.effective_date between c_start_date and c_end_date

Line 1412: , per_assignments_f paf

1408: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
1409: ,max(paa.action_sequence) action_sequence
1410: from pay_assignment_actions paa
1411: , pay_payroll_actions ppa
1412: , per_assignments_f paf
1413: where paa.assignment_id = paf.assignment_id
1414: and paf.assignment_id = c_assignment_id
1415: and ppa.payroll_action_id = paa.payroll_action_id
1416: and ppa.effective_date between c_start_date and c_end_date

Line 1563: ,per_assignments_f paaf

1559: ,pay_input_values_f piv1
1560: ,pay_element_classifications pec
1561: ,pay_assignment_actions paa
1562: ,pay_payroll_actions ppa
1563: ,per_assignments_f paaf
1564: ,pay_run_results prr
1565: ,pay_run_result_values prrv1
1566: ,pay_element_classifications pec2
1567: ,pay_sub_classification_rules_f pscr

Line 1871: from per_assignments_f paf,

1867: ,c_year_end in DATE
1868: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type )
1869: IS
1870: select max(paa.assignment_action_id) assignment_action_id
1871: from per_assignments_f paf,
1872: pay_payroll_Actions ppa,
1873: pay_assignment_Actions paa,
1874: per_time_periods ptp
1875: where ppa.payroll_Action_id = paa.payroll_Action_id