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

Line 70: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

66: pay_org_payment_methods_f pop,
67: pay_payment_types ppt,
68: pay_org_pay_method_usages_f ppu
69:
70: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
71: and ppp.pre_payment_id = paa.pre_payment_id
72: and ppp.value > 0
73: and paa.payroll_action_id = ppa.payroll_action_id
74: and paa.assignment_id = paf.assignment_id

Line 122: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

118: -- hr_soft_coding_keyflex hsk,
119: pay_payment_types ppt,
120: pay_payrolls_f ppf
121:
122: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
123: and ppp.pre_payment_id = paa.pre_payment_id
124: and ppp.value > 0
125: and paa.payroll_action_id = ppa.payroll_action_id
126: and pop.org_payment_method_id = ppp.org_payment_method_id

Line 132: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO')

128: and ppt.payment_type_id= pop.payment_type_id
129: and ( ppt.payment_type_name like 'NO Money Order' or ppt.category in ('MT'))
130: and pop.external_account_id = pea.external_account_id
131: and paa.assignment_id = paf.assignment_id
132: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO')
133: /* and hsk.SOFT_CODING_KEYFLEX_ID = paf.SOFT_CODING_KEYFLEX_ID
134: and hsk.enabled_flag = 'Y'
135: and hsk.segment2 in (
136: select hoi2.org_information1

Line 179: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

175: per_all_people_f pap,
176: -- hr_soft_coding_keyflex hsk,
177: pay_payment_types ppt
178:
179: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
180: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
181: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
182: AND pa2.effective_date <= pa1.effective_date
183: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments

Line 181: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))

177: pay_payment_types ppt
178:
179: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
180: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
181: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
182: AND pa2.effective_date <= pa1.effective_date
183: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
184: AND act.payroll_action_id = pa2.payroll_action_id
185: AND act.action_status = 'C'

Line 259: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

255: pay_org_payment_methods_f OPM,
256: per_all_people_f pap,
257: -- hr_soft_coding_keyflex hsk,
258: pay_payment_types ppt
259: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
260: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
261: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
262: AND pa2.effective_date <= pa1.effective_date
263: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments

Line 261: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))

257: -- hr_soft_coding_keyflex hsk,
258: pay_payment_types ppt
259: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
260: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
261: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'ENTERPRISE_NUMBER')),OPM.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
262: AND pa2.effective_date <= pa1.effective_date
263: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
264: AND act.payroll_action_id = pa2.payroll_action_id
265: AND act.action_status = 'C'

Line 338: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

334: pay_external_accounts pea,
335: -- hr_soft_coding_keyflex hsk,
336: pay_payment_types ppt
337:
338: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
339: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
340: and ppp.pre_payment_id = paa.pre_payment_id
341: and ppp.value > 0
342: and paa.payroll_action_id = ppa.payroll_action_id

Line 339: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))

335: -- hr_soft_coding_keyflex hsk,
336: pay_payment_types ppt
337:
338: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
339: and nvl((PAY_NO_PAYPROC_UTILITY.get_parameter(ppa.payroll_action_id,'ENTERPRISE_NUMBER')),pop.pmeth_information1)= to_char(pay_magtape_generic.get_parameter_value('TRANSFER_ENTERPRISE_NO'))
340: and ppp.pre_payment_id = paa.pre_payment_id
341: and ppp.value > 0
342: and paa.payroll_action_id = ppa.payroll_action_id
343: and pop.org_payment_method_id = ppp.org_payment_method_id