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 218: ' from per_people_f p,' ||

214:
215: -- Archive the payroll action level data and EIT defintions.
216: -- sql string to SELECT a range of assignments eligible for archival.
217: p_sql := ' select distinct p.person_id' ||
218: ' from per_people_f p,' ||
219: ' pay_payroll_actions pa' ||
220: ' where pa.payroll_action_id = :payroll_action_id' ||
221: ' and p.business_group_id = pa.business_group_id' ||
222: ' order by p.person_id';

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

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

Line 802: from per_people_f pap

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

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

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

Line 885: from per_people_f pap

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

Line 967: from per_people_f pap

963: ,c_assignment_id varchar2
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

Line 1293: from per_people_f pap,

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

Line 1374: from per_people_f pap,

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