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_PEOPLE_F

Line 116: ' from per_people_f p,' ||

112:
113: -- Archive the payroll action level data and EIT defintions.
114: -- sql string to SELECT a range of assignments eligible for archival.
115: p_sql := ' select distinct p.person_id' ||
116: ' from per_people_f p,' ||
117: ' pay_payroll_actions pa' ||
118: ' where pa.payroll_action_id = :payroll_action_id' ||
119: ' and p.business_group_id = pa.business_group_id' ||
120: ' order by p.person_id';

Line 449: SELECT /*+ INDEX(pap per_people_f_pk)

445: ,c_lst_year_start date
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)

Line 455: from per_people_f pap

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
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

Line 523: SELECT /*+ INDEX(pap per_people_f_pk)

519: ,c_lst_year_start date
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)

Line 529: from per_people_f pap

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
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

Line 601: SELECT /*+ INDEX(pap per_people_f_pk)

597: ,c_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type
598: ,c_assignment_id varchar2
599: )
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)

Line 607: from per_people_f pap

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
609: ,pay_payroll_actions rppa
610: ,per_periods_of_service pps
611: ,pay_population_ranges ppr

Line 919: from per_people_f pap,

915: hsc.segment1 tax_unit_id,
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,

Line 999: from per_people_f pap,

995: paf.assignment_number,
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