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_PAYFILE_SEPA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 81: FROM pay_assignment_actions pas

77: AND ppa.org_payment_method_id = popmf.org_payment_method_id --15971893
78: AND hou.business_group_id = ppa.business_group_id --15971893
79: AND hou.organization_id = ppa.business_group_id --15971893
80: AND EXISTS (SELECT 1
81: FROM pay_assignment_actions pas
82: ,pay_pre_payments ppp
83: WHERE pas.payroll_action_id = ppa.payroll_action_id
84: AND ppp.pre_payment_id = pas.pre_payment_id
85: AND ppp.value > 0 );

Line 138: FROM pay_assignment_actions pas

134: and --restricting employer who doesn't have any assignment to pay.
135: EXISTS
136: (
137: SELECT 1
138: FROM pay_assignment_actions pas
139: ,pay_pre_payments ppp
140: ,per_all_assignments_f paaf
141: ,pay_all_payrolls_f ppf
142: -- ,hr_soft_coding_keyflex hsck

Line 188: ,pay_assignment_actions paa

184: FROM per_all_assignments_f paf
185: ,per_all_people_f pef
186: ,pay_all_payrolls_f ppf
187: ,pay_pre_payments ppp
188: ,pay_assignment_actions paa
189: ,pay_payroll_actions ppa
190: ,pay_personal_payment_methods_f ppmf
191: ,pay_external_accounts pea
192: --,hr_soft_coding_keyflex hsck