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_IE_P35_MAGTAPE dependencies on PAY_ACTION_INTERLOCKS

Line 265: pay_action_interlocks plock

261: pay_payroll_actions ppa_p35,
262: per_assignments_f paaf_p35,
263: pay_all_payrolls_f ppf_p35,
264: hr_soft_coding_keyflex flex_p35,
265: pay_action_interlocks plock
266: WHERE ppa_p35.report_type = 'IEP35MAG'
267: AND paa_p35.action_status = 'C'
268: AND TO_DATE (
269: pay_ie_p35.get_parameter (

Line 451: ,pay_action_interlocks pai

447: sum(to_number(pact.action_information1))*100 TAXABLEBENEFITS
448:
449: FROM pay_assignment_actions paa
450: ,pay_action_information pact
451: ,pay_action_interlocks pai
452: WHERE paa.payroll_action_id = p_payroll_action_id
453: AND paa.source_action_id IS NULL
454: AND pai.locking_action_id = paa.assignment_action_id
455: AND pact.action_context_id = pai.locked_action_id

Line 478: ,pay_action_interlocks pai

474: TRUNC(sum(to_number(pact.action_information1)))*100 TAXABLEBENEFITS
475:
476: FROM pay_assignment_actions paa
477: ,pay_action_information pact
478: ,pay_action_interlocks pai
479: WHERE paa.payroll_action_id = p_payroll_action_id
480: AND paa.source_action_id IS NULL
481: AND pai.locking_action_id = paa.assignment_action_id
482: AND pact.action_context_id = pai.locked_action_id

Line 559: ,pay_action_interlocks pai

555: nvl((sum(to_number(pact.action_information19))*100),0) empr_income_band /* sum of first band, second band and third band values */
556: ,nvl((sum(to_number(pact.action_information7))*100),0) tol_usc --12382953
557: FROM pay_assignment_actions paa
558: ,pay_action_information pact
559: ,pay_action_interlocks pai
560: WHERE paa.payroll_action_id = p_payroll_action_id
561: AND paa.source_action_id IS NULL
562: AND pai.locking_action_id = paa.assignment_action_id
563: AND pact.action_context_id = pai.locked_action_id

Line 577: ,pay_action_interlocks pai

573: nvl((SUM(TRUNC(to_number(pact.action_information19)))*100),0) empr_income_band
574: ,nvl((SUM(TRUNC(to_number(pact.action_information7)))*100),0) tol_usc --12382953
575: FROM pay_assignment_actions paa
576: ,pay_action_information pact
577: ,pay_action_interlocks pai
578: WHERE paa.payroll_action_id = p_payroll_action_id
579: AND paa.source_action_id IS NULL
580: AND pai.locking_action_id = paa.assignment_action_id
581: AND pact.action_context_id = pai.locked_action_id