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.PYUSDAR_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 239: per_all_assignments_f paf1,

235: select act.assignment_action_id,
236: act.assignment_id,
237: act.tax_unit_id
238: from pay_assignment_actions act,
239: per_all_assignments_f paf1,
240: per_all_assignments_f paf2,
241: per_periods_of_service pos,
242: pay_payroll_actions ppa_dar,
243: pay_payroll_actions ppa_mag_pmts,

Line 240: per_all_assignments_f paf2,

236: act.assignment_id,
237: act.tax_unit_id
238: from pay_assignment_actions act,
239: per_all_assignments_f paf1,
240: per_all_assignments_f paf2,
241: per_periods_of_service pos,
242: pay_payroll_actions ppa_dar,
243: pay_payroll_actions ppa_mag_pmts,
244: pay_payrolls_f pay --Bug 3343621

Line 376: per_all_assignments_f paf1,

372: act.assignment_id,
373: act.tax_unit_id,
374: ppa_mag.effective_date
375: from pay_assignment_actions act,
376: per_all_assignments_f paf1,
377: per_all_assignments_f paf2,
378: per_periods_of_service pos,
379: pay_payroll_actions ppa_dar,
380: pay_payroll_actions ppa_mag,

Line 377: per_all_assignments_f paf2,

373: act.tax_unit_id,
374: ppa_mag.effective_date
375: from pay_assignment_actions act,
376: per_all_assignments_f paf1,
377: per_all_assignments_f paf2,
378: per_periods_of_service pos,
379: pay_payroll_actions ppa_dar,
380: pay_payroll_actions ppa_mag,
381: pay_org_payment_methods_f popm --Bug 3009643

Line 969: per_all_assignments_f paf,

965: --Bug 3331028-- Rule hint is used only for database version < 10.0
966: sqlstr := 'select '||l_db_version||' paa.rowid
967: from hr_all_organization_units hou,
968: per_all_people_f ppf,
969: per_all_assignments_f paf,
970: pay_assignment_actions paa,
971: pay_payroll_actions ppa
972: where ppa.payroll_action_id = :pactid
973: and paa.payroll_action_id = ppa.payroll_action_id

Line 977: from per_all_assignments_f paf1

973: and paa.payroll_action_id = ppa.payroll_action_id
974: and paa.assignment_id = paf.assignment_id
975: and paf.effective_start_date =
976: (select max(paf1.effective_start_date)
977: from per_all_assignments_f paf1
978: where paf1.assignment_id = paf.assignment_id
979: and paf1.effective_start_date <= ppa.effective_date
980: and paf1.effective_end_date >= ppa.start_date
981: )