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 PER_ALL_ASSIGNMENTS_F

Line 140: ,per_all_assignments_f paaf

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
143: WHERE pas.payroll_action_id = ppa.payroll_action_id
144: AND ppp.pre_payment_id = pas.pre_payment_id

Line 184: FROM per_all_assignments_f paf

180: ,'PRE_PAYMENT_ID=P',min(ppp.pre_payment_id)
181: ,'IBAN_EE=P',NVL(min(pea.SEGMENT7),' ')
182: ,'BIC_EE=P',nvl(min(pea.SEGMENT6),' ')
183: ,'NATIONAL_IDENTIFIER=P',min(pef.NATIONAL_IDENTIFIER)
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