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_INFORMATION

Line 186: pay_action_information pai,

182: IS
183: SELECT DISTINCT paa.assignment_id,paa.assignment_action_id,paa.payroll_action_id
184: FROM pay_assignment_actions paa,
185: pay_payroll_actions ppa,
186: pay_action_information pai,
187: per_assignments_f paaf,
188: pay_all_payrolls_f ppf,
189: hr_soft_coding_keyflex flex
190: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 450: ,pay_action_information pact

446: sum(to_number(pact.action_information6))*100 EMP_RAC_BAL,
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

Line 477: ,pay_action_information pact

473: TRUNC(sum(to_number(pact.action_information6)))*100 EMP_RAC_BAL,
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

Line 558: ,pay_action_information pact

554: sum(to_number(pact.action_information23))*100 EMP_PARKING_BAL ,
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

Line 576: ,pay_action_information pact

572: TRUNC(SUM(to_number(pact.action_information23)))*100 EMP_PARKING_BAL ,
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