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_GB_ROLLBACK dependencies on PER_ALL_ASSIGNMENTS_F

Line 273: from per_all_assignments_f paaf,

269: -- To fetch other assignments of the PAYE Aggregation
270: cursor fetch_other_paye_agg_asg(p_asg_id number)
271: is
272: select paaf.assignment_id
273: from per_all_assignments_f paaf,
274: pay_payrolls_f pay,
275: hr_soft_coding_keyflex sck
276: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_asg_id)
277: and paaf.assignment_id <> p_asg_id

Line 276: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_asg_id)

272: select paaf.assignment_id
273: from per_all_assignments_f paaf,
274: pay_payrolls_f pay,
275: hr_soft_coding_keyflex sck
276: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_asg_id)
277: and paaf.assignment_id <> p_asg_id
278: and pay.payroll_id = paaf.payroll_id
279: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
280: and sck.SEGMENT1 = l_tax_ref

Line 283: from per_all_assignments_f paaf1

279: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
280: and sck.SEGMENT1 = l_tax_ref
281: and paaf.EFFECTIVE_START_DATE =
282: ( select max(paaf1.effective_start_date)
283: from per_all_assignments_f paaf1
284: where paaf1.assignment_id = paaf.assignment_id
285: and paaf1.assignment_type = 'E'
286: and paaf1.effective_start_date <= l_effective_date
287: )