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

Line 425: from per_all_assignments_f paaf,

421: -- To fetch other assignments of the PAYE Aggregation
422: cursor fetch_other_paye_agg_asg(p_asg_id number)
423: is
424: select paaf.assignment_id
425: from per_all_assignments_f paaf,
426: pay_payrolls_f pay,
427: hr_soft_coding_keyflex sck
428: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_asg_id)
429: and paaf.assignment_id <> p_asg_id

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

424: select paaf.assignment_id
425: from per_all_assignments_f paaf,
426: pay_payrolls_f pay,
427: hr_soft_coding_keyflex sck
428: where paaf.person_id = (select distinct person_id from per_all_assignments_f where ASSIGNMENT_ID =p_asg_id)
429: and paaf.assignment_id <> p_asg_id
430: and pay.payroll_id = paaf.payroll_id
431: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
432: and sck.SEGMENT1 = l_tax_ref

Line 435: from per_all_assignments_f paaf1

431: and pay.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
432: and sck.SEGMENT1 = l_tax_ref
433: and paaf.EFFECTIVE_START_DATE =
434: ( select max(paaf1.effective_start_date)
435: from per_all_assignments_f paaf1
436: where paaf1.assignment_id = paaf.assignment_id
437: and paaf1.assignment_type = 'E'
438: and paaf1.effective_start_date <= l_effective_date
439: )