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

Line 228: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900);

224: , per_all_people_f pap
225: WHERE /*pad.person_id = p_person_id*/
226: pad.person_id (+)= pap.person_id
227: AND pap.person_id = p_person_id
228: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900);
229:
230:
231: /* Modified for Pension changes to restrict on Pension Provider*/
232: CURSOR get_is_record_04_details_local(p_assignment_id NUMBER,p_pp_id VARCHAR2) IS

Line 249: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

245: , pay_input_values_f piv4
246: , pay_assignment_actions paa
247: , pay_payroll_actions ppa
248: , pay_element_entries_f pee
249: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
250: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
251: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID
252: AND prrv3.RUN_RESULT_ID = prr1.RUN_RESULT_ID
253: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID

Line 280: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

276: AND prr1.assignment_action_id = paa.assignment_action_id
277: AND prr1.assignment_action_id=prr2.assignment_action_id
278: AND prr1.start_date = prr2.start_date
279: AND prr1.end_date = prr2.end_date
280: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
281: AND paa.assignment_id = p_assignment_id
282: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
283: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
284: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date

Line 305: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

301: /* Added for Pension changes */
302: , pay_input_values_f pivf
303: , pay_element_entry_values_f peev1
304: , pay_element_entry_values_f peev2
305: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
306: AND paa.payroll_action_id = ppa.payroll_action_id
307: AND pee1.assignment_id = paa.assignment_id
308: AND pet.element_name = 'Pension'
309: AND pet.legislation_code ='DK'

Line 321: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

317: AND pivf.name= 'Third Party Payee'
318: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
319: AND peev1.input_value_id = pivf.input_value_id
320: AND peev1.element_entry_id = pee1.element_entry_id
321: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
322: AND peev2.input_value_id = pivf.input_value_id
323: AND peev2.element_entry_id = pee2.element_entry_id
324: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
325: /* Added for Pension changes -end */

Line 324: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

320: AND peev1.element_entry_id = pee1.element_entry_id
321: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
322: AND peev2.input_value_id = pivf.input_value_id
323: AND peev2.element_entry_id = pee2.element_entry_id
324: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
325: /* Added for Pension changes -end */
326: AND paa.assignment_id = p_assignment_id
327: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
328: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date

Line 330: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

326: AND paa.assignment_id = p_assignment_id
327: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
328: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
329: AND pee1.effective_start_date >= ppa.start_date
330: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
331: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /*bug fix 4551283*/
332: AND ppa.effective_date BETWEEN hou.date_from AND nvl(hou.date_to, ppa.effective_date) /*bug fix 4551283*/
333: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id,hou.name;
334:

Line 331: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /bug fix 4551283/

327: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
328: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
329: AND pee1.effective_start_date >= ppa.start_date
330: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
331: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /*bug fix 4551283*/
332: AND ppa.effective_date BETWEEN hou.date_from AND nvl(hou.date_to, ppa.effective_date) /*bug fix 4551283*/
333: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id,hou.name;
334:
335:

Line 348: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

344: /* Added for Pension changes */
345: , pay_input_values_f pivf
346: , pay_element_entry_values_f peev1
347: , pay_element_entry_values_f peev2
348: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
349: AND paa.payroll_action_id = ppa.payroll_action_id
350: AND pee1.assignment_id = paa.assignment_id
351: AND pet.element_name = 'Pension'
352: AND pet.legislation_code ='DK'

Line 364: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

360: AND pivf.name= 'Third Party Payee'
361: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
362: AND peev1.input_value_id = pivf.input_value_id
363: AND peev1.element_entry_id = pee1.element_entry_id
364: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
365: AND peev2.input_value_id = pivf.input_value_id
366: AND peev2.element_entry_id = pee2.element_entry_id
367: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
368: /* Added for Pension changes -end */

Line 367: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

363: AND peev1.element_entry_id = pee1.element_entry_id
364: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
365: AND peev2.input_value_id = pivf.input_value_id
366: AND peev2.element_entry_id = pee2.element_entry_id
367: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
368: /* Added for Pension changes -end */
369: AND paa.assignment_id = p_assignment_id
370: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
371: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date

Line 370: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

366: AND peev2.element_entry_id = pee2.element_entry_id
367: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
368: /* Added for Pension changes -end */
369: AND paa.assignment_id = p_assignment_id
370: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
371: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
372: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
373: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;
374:

Line 387: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

383: /* Added for Pension changes */
384: , pay_input_values_f pivf
385: , pay_element_entry_values_f peev1
386: , pay_element_entry_values_f peev2
387: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
388: AND paa.payroll_action_id = ppa.payroll_action_id
389: AND pee1.assignment_id = paa.assignment_id
390: AND pet.element_name = 'Pension'
391: AND pet.legislation_code ='DK'

Line 403: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

399: AND pivf.name= 'Third Party Payee'
400: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
401: AND peev1.input_value_id = pivf.input_value_id
402: AND peev1.element_entry_id = pee1.element_entry_id
403: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
404: AND peev2.input_value_id = pivf.input_value_id
405: AND peev2.element_entry_id = pee2.element_entry_id
406: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
407: /* Added for Pension changes -end */

Line 406: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))

402: AND peev1.element_entry_id = pee1.element_entry_id
403: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
404: AND peev2.input_value_id = pivf.input_value_id
405: AND peev2.element_entry_id = pee2.element_entry_id
406: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
407: /* Added for Pension changes -end */
408: AND pee2.effective_start_date < ppa.start_date
409: AND paa.assignment_id = p_assignment_id
410: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

Line 410: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

406: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
407: /* Added for Pension changes -end */
408: AND pee2.effective_start_date < ppa.start_date
409: AND paa.assignment_id = p_assignment_id
410: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
411: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
412: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
413: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;
414: