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_NL_PAYFILE_SEPA dependencies on PAY_MAGTAPE_GENERIC

Line 93: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

89: ,'INSTR_IDENT=P'
90: ,NVL(pay_nl_general.get_parameter(ppa.legislative_parameters,'INSTR_IDENT'),' ')
91: FROM pay_payroll_actions ppa
92: WHERE ppa.payroll_action_id =
93: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
94: AND EXISTS (
95: SELECT 1
96: FROM pay_assignment_actions pas
97: ,pay_pre_payments ppp

Line 142: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') and

138: PAY_ALL_PAYROLLS_F papf,
139: PAY_EXTERNAL_ACCOUNTS pea,
140: PAY_PAYROLL_ACTIONS ppa
141: where
142: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') and
143: hou.business_group_id = ppa.business_group_id and
144: hoi.org_information_context = 'NL_ORG_INFORMATION' and
145: hou.organization_id = hoi.organization_id and
146: popmu.org_payment_method_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD_ID') and

Line 146: popmu.org_payment_method_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD_ID') and

142: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') and
143: hou.business_group_id = ppa.business_group_id and
144: hoi.org_information_context = 'NL_ORG_INFORMATION' and
145: hou.organization_id = hoi.organization_id and
146: popmu.org_payment_method_id = pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD_ID') and
147: ppa.effective_date between popmu.effective_start_date and popmu.effective_end_date and
148: popmf.org_payment_method_id = popmu.org_payment_method_id and
149: popmf.business_group_id = hou.business_group_id and
150: ppa.effective_date between popmf.effective_start_date and popmf.effective_end_date and

Line 232: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

228: ,pay_assignment_actions paa
229: ,pay_payroll_actions ppa
230: ,pay_personal_payment_methods_f ppmf
231: ,pay_external_accounts pea
232: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
233: AND paa.pre_payment_id = ppp.pre_payment_id
234: AND paa.payroll_action_id = ppa.payroll_action_id
235: AND PPP.personal_payment_method_id = ppmf.personal_payment_method_id
236: AND paa.assignment_id = paf.assignment_id

Line 243: AND ppf.prl_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')

239: AND ppf.payroll_id = paf.payroll_id
240: AND ppa.effective_date BETWEEN ppf.effective_start_date
241: AND ppf.effective_end_date
242: AND ppf.prl_information_category = 'NL'
243: AND ppf.prl_information1 = pay_magtape_generic.get_parameter_value('TRANSFER_ORGANIZATION_ID')
244: AND ppp.value > 0
245: AND pea.external_account_id = ppmf.external_account_id
246: AND ppa.effective_date BETWEEN paf.effective_start_date
247: AND paf.effective_end_date