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 66: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

62: pay_assignment_actions paa,
63: per_all_assignments_f paf,
64: pay_pre_payments ppp
65:
66: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
67: and ppp.pre_payment_id = paa.pre_payment_id
68: and ppp.value > 0
69: and paa.payroll_action_id = ppa.payroll_action_id
70: and paa.assignment_id = paf.assignment_id

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

105: pay_external_accounts pea,
106: hr_soft_coding_keyflex hsk,
107: pay_payment_types ppt
108:
109: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
110: and ppp.pre_payment_id = paa.pre_payment_id
111: and ppp.value > 0
112: and paa.payroll_action_id = ppa.payroll_action_id
113: and pop.org_payment_method_id = ppp.org_payment_method_id

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

157: per_all_people_f pap,
158: hr_soft_coding_keyflex hsk,
159: pay_payment_types ppt
160:
161: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
162: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
163: AND pa2.effective_date <= pa1.effective_date
164: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
165: AND act.payroll_action_id = pa2.payroll_action_id

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

235: pay_org_payment_methods_f OPM,
236: per_all_people_f pap,
237: hr_soft_coding_keyflex hsk,
238: pay_payment_types ppt
239: WHERE pa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
240: AND pa2.payroll_id = NVL(to_number(PAY_NO_PAYPROC_UTILITY.get_parameter(pa1.payroll_action_id,'PAYROLL_ID')),pa2.payroll_id)
241: AND pa2.effective_date <= pa1.effective_date
242: AND pa2.action_type IN ('U','P') -- Prepayments or Quickpay Prepayments
243: AND act.payroll_action_id = pa2.payroll_action_id

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

312: pay_external_accounts pea,
313: hr_soft_coding_keyflex hsk,
314: pay_payment_types ppt
315:
316: where ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
317: and ppp.pre_payment_id = paa.pre_payment_id
318: and ppp.value > 0
319: and paa.payroll_action_id = ppa.payroll_action_id
320: and pop.org_payment_method_id = ppp.org_payment_method_id