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_ORG_PAYMENT_METHODS_F

Line 142: from pay_org_payment_methods_f opm,

138: p_payroll_action_id number,
139: p_effective_date date ) IS
140: select opm.ORG_PAYMENT_METHOD_ID,
141: ppa.payroll_id
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

Line 169: pay_org_payment_methods_f opm,

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
173: AND ppa.org_payment_method_id = opm.org_payment_method_id -- join PPA to OPM to narrow to one method