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_US_NACHA_IAT_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 146: pay_payroll_actions ppa

142: from pay_org_payment_methods_f opm,
143: pay_payment_types pt,
144: pay_org_pay_method_usages_f opmu,
145: pay_payrolls_f pay,
146: pay_payroll_actions ppa
147: where ppa.PAYROLL_ACTION_ID = p_payroll_action_id
148: and ppa.payroll_id = pay.payroll_id
149: and ppa.CONSOLIDATION_SET_ID = pay.CONSOLIDATION_SET_ID
150: and pay.PAYROLL_ID = opmu.PAYROLL_ID

Line 168: FROM pay_payroll_actions ppa , -- Add here to allow join directly to ORG_PAYMENT_METHOD_ID

164:
165: SELECT DISTINCT opm.org_payment_method_id, -- Changed to use OPM, moved PAY_PRE_PAYMENTS fully TO subquery
166: hrorgu.organization_id ,
167: opm.pmeth_information6
168: FROM pay_payroll_actions ppa , -- Add here to allow join directly to ORG_PAYMENT_METHOD_ID
169: pay_org_payment_methods_f opm,
170: hr_organization_units hrorgu ,
171: hr_organization_information hroinf
172: WHERE ppa.payroll_action_id = p_payroll_action_id -- New clause to allow primary key access