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

Line 189: per_assignments_f asg,

185: 'select distinct asg.person_id
186: from pay_payroll_actions ppa,
187: pay_payroll_actions pa1,
188: pay_assignment_actions act,
189: per_assignments_f asg,
190: pay_payrolls_f ppf
191: where ppa.payroll_action_id = :payroll_action_id
192: '||l_consolidation_set_text||'
193: '||l_payroll_text||'

Line 264: per_assignments_f paf

260: from pay_payrolls_f ppf, -- Bug 3372747
261: pay_payroll_actions ppa, /* pre-payments and reversals
262: payroll action id */
263: pay_assignment_actions act,
264: per_assignments_f paf
265: where (c_payroll_id is NULL
266: or ppa.payroll_id = c_payroll_id)
267: and ppa.consolidation_set_id +0 = nvl(c_consolidation_set_id,
268: ppa.consolidation_set_id)

Line 322: PER_ASSIGNMENTS_F PAF ,

318: act.source_action_id,
319: nvl(ppa.start_date,ppa.effective_date)
320: from
321: HR_ASSIGNMENT_SET_AMENDMENTS HASA ,
322: PER_ASSIGNMENTS_F PAF ,
323: PAY_ASSIGNMENT_ACTIONS ACT ,
324: PAY_PAYROLL_ACTIONS PPA ,
325: PAY_PAYROLLS_F PPF
326: where (c_payroll_id is NULL

Line 440: per_assignments_f paf

436: cursor c_payroll_def (cp_assignment_id in number,
437: cp_effective_date in date) is
438: select multi_assignments_flag
439: from pay_payrolls_f ppf,
440: per_assignments_f paf
441: where paf.payroll_id = ppf.payroll_id
442: and cp_effective_date between paf.effective_start_date
443: and paf.effective_end_date
444: and cp_effective_date between ppf.effective_start_date --bug5366862

Line 1320: per_assignments_f paf

1316: ppa.effective_date,
1317: paa.tax_unit_id))),
1318: (select hou.name
1319: from hr_all_organization_units hou, /* Assignment Org */
1320: per_assignments_f paf
1321: where paf.assignment_id = paa.assignment_id
1322: and ppa.effective_date between
1323: paf.effective_start_date and paf.effective_end_date
1324: and hou.organization_id = paf.organization_id

Line 1411: per_assignments_f paf

1407: null)
1408: into return_val
1409: from hr_all_organization_units hou, /* Assignment Org */
1410: hr_locations_all loc,
1411: per_assignments_f paf
1412: where paf.assignment_id = c_assignment_id
1413: and c_effective_date between
1414: paf.effective_start_date and paf.effective_end_date
1415: and hou.organization_id = paf.organization_id