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_PAYMENT_TYPES

Line 107: pay_payment_types ppt

103: pay_org_payment_methods_f pop,
104: per_all_people_f pef,
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

Line 159: pay_payment_types ppt

155: pay_pre_payments ppp,
156: pay_org_payment_methods_f OPM,
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

Line 238: pay_payment_types ppt

234: pay_pre_payments ppp,
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

Line 256: ,pay_payment_types ppt1

252: AND ppp.org_payment_method_id = opm.org_payment_method_id
253: AND ppt.payment_type_id= opm.payment_type_id
254: AND ( ppt.category not in ('MT') and exists ( select '1' FROM
255: pay_org_payment_methods_f opm1
256: ,pay_payment_types ppt1
257: ,pay_pre_payments ppp1
258: WHERE ppp1.assignment_action_id = act.assignment_action_id--2023513440
259: AND ppp1.org_payment_method_id = opm1.org_payment_method_id
260: AND ppt1.payment_type_id= opm1.payment_type_id

Line 314: pay_payment_types ppt

310: per_all_people_f pef,
311: per_addresses pad,
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