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.

[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_MAGTAPE_GENERIC

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

478: pad.person_id (+)= pap.person_id
479: AND pad.primary_flag = 'Y' --9403004
480: AND ppa.effective_date BETWEEN nvl(pad.date_from,ppa.effective_date) AND nvl(pad.date_to,to_date('31-12-4712','dd-mm-rrrr')) --9403004
481: AND pap.person_id = p_person_id
482: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
483: /* Modified for bug fix 7664874 */
484: AND ppa.payroll_action_id=pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
485: AND ppa.effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date;
486:

Line 484: AND ppa.payroll_action_id=pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

480: AND ppa.effective_date BETWEEN nvl(pad.date_from,ppa.effective_date) AND nvl(pad.date_to,to_date('31-12-4712','dd-mm-rrrr')) --9403004
481: AND pap.person_id = p_person_id
482: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
483: /* Modified for bug fix 7664874 */
484: AND ppa.payroll_action_id=pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
485: AND ppa.effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date;
486:
487:
488: /* Modified for Pension changes to restrict on Pension Provider*/

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

502: , pay_input_values_f piv4
503: , pay_assignment_actions paa
504: , pay_payroll_actions ppa
505: , pay_element_entries_f pee
506: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
507: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
508: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID
509: AND prrv3.RUN_RESULT_ID = prr1.RUN_RESULT_ID
510: AND pee.ELEMENT_ENTRY_ID = prr1.ELEMENT_ENTRY_ID

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

533: AND prr1.assignment_action_id = paa.assignment_action_id
534: AND prr1.assignment_action_id=prr2.assignment_action_id
535: AND prr1.start_date = prr2.start_date
536: AND prr1.end_date = prr2.end_date
537: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
538: AND paa.assignment_id = p_assignment_id
539: AND ppa.effective_date BETWEEN pet1.effective_start_date and pet1.effective_end_date
540: AND ppa.effective_date BETWEEN pet2.effective_start_date and pet2.effective_end_date
541: AND ppa.effective_date BETWEEN piv1.effective_start_date and piv1.effective_end_date

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

558: /* Added for Pension changes */
559: , pay_input_values_f pivf
560: , pay_element_entry_values_f peev1
561: , pay_element_entry_values_f peev2
562: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
563: AND paa.payroll_action_id = ppa.payroll_action_id
564: AND pee1.assignment_id = paa.assignment_id
565: AND pet.element_name = 'Pension'
566: AND pet.legislation_code ='DK'

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

574: AND pivf.name= 'Third Party Payee'
575: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
576: AND peev1.input_value_id = pivf.input_value_id
577: AND peev1.element_entry_id = pee1.element_entry_id
578: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
579: AND peev2.input_value_id = pivf.input_value_id
580: AND peev2.element_entry_id = pee2.element_entry_id
581: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
582: /* Added for Pension changes -end */

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

577: AND peev1.element_entry_id = pee1.element_entry_id
578: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
579: AND peev2.input_value_id = pivf.input_value_id
580: AND peev2.element_entry_id = pee2.element_entry_id
581: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
582: /* Added for Pension changes -end */
583: AND paa.assignment_id = p_assignment_id
584: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
585: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date

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

583: AND paa.assignment_id = p_assignment_id
584: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
585: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
586: AND pee1.effective_start_date >= ppa.start_date
587: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
588: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /*bug fix 4551283*/
589: AND ppa.effective_date BETWEEN hou.date_from AND nvl(hou.date_to, ppa.effective_date) /*bug fix 4551283*/
590: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id,hou.name;
591:

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

584: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
585: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
586: AND pee1.effective_start_date >= ppa.start_date
587: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
588: AND hou.organization_id = pay_magtape_generic.get_parameter_value('TRANSFER_LE_ID') /*bug fix 4551283*/
589: AND ppa.effective_date BETWEEN hou.date_from AND nvl(hou.date_to, ppa.effective_date) /*bug fix 4551283*/
590: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id,hou.name;
591:
592:

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

601: /* Added for Pension changes */
602: , pay_input_values_f pivf
603: , pay_element_entry_values_f peev1
604: , pay_element_entry_values_f peev2
605: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
606: AND paa.payroll_action_id = ppa.payroll_action_id
607: AND pee1.assignment_id = paa.assignment_id
608: AND pet.element_name = 'Pension'
609: AND pet.legislation_code ='DK'

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

617: AND pivf.name= 'Third Party Payee'
618: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
619: AND peev1.input_value_id = pivf.input_value_id
620: AND peev1.element_entry_id = pee1.element_entry_id
621: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
622: AND peev2.input_value_id = pivf.input_value_id
623: AND peev2.element_entry_id = pee2.element_entry_id
624: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
625: /* Added for Pension changes -end */

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

620: AND peev1.element_entry_id = pee1.element_entry_id
621: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
622: AND peev2.input_value_id = pivf.input_value_id
623: AND peev2.element_entry_id = pee2.element_entry_id
624: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
625: /* Added for Pension changes -end */
626: AND paa.assignment_id = p_assignment_id
627: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
628: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date

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

623: AND peev2.element_entry_id = pee2.element_entry_id
624: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
625: /* Added for Pension changes -end */
626: AND paa.assignment_id = p_assignment_id
627: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
628: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
629: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
630: AND 1=2
631: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;

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

641: /* Added for Pension changes */
642: , pay_input_values_f pivf
643: , pay_element_entry_values_f peev1
644: , pay_element_entry_values_f peev2
645: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
646: AND paa.payroll_action_id = ppa.payroll_action_id
647: AND pee1.assignment_id = paa.assignment_id
648: AND pet.element_name = 'Pension'
649: AND pet.legislation_code ='DK'

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

657: AND pivf.name= 'Third Party Payee'
658: AND ppa.effective_date BETWEEN pivf.effective_start_date AND pivf.effective_end_date
659: AND peev1.input_value_id = pivf.input_value_id
660: AND peev1.element_entry_id = pee1.element_entry_id
661: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
662: AND peev2.input_value_id = pivf.input_value_id
663: AND peev2.element_entry_id = pee2.element_entry_id
664: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
665: /* Added for Pension changes -end */

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

660: AND peev1.element_entry_id = pee1.element_entry_id
661: AND peev1.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
662: AND peev2.input_value_id = pivf.input_value_id
663: AND peev2.element_entry_id = pee2.element_entry_id
664: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
665: /* Added for Pension changes -end */
666: AND pee2.effective_start_date < ppa.start_date
667: AND paa.assignment_id = p_assignment_id
668: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)

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

664: AND peev2.screen_entry_value = PAY_DK_PAYMENT_PROCESS_PKG.get_pension_provider(pay_magtape_generic.get_parameter_value('TRANSFER_RECEIVER_NAME'))
665: /* Added for Pension changes -end */
666: AND pee2.effective_start_date < ppa.start_date
667: AND paa.assignment_id = p_assignment_id
668: AND pay_magtape_generic.get_parameter_value('TRANSFER_INFO_TYPE') NOT IN (300, 400, 800, 900)
669: AND ppa.effective_date BETWEEN pet.effective_start_date and pet.effective_end_date
670: AND ppa.effective_date BETWEEN pee1.effective_start_date and pee1.effective_end_date
671: AND 1=2
672: GROUP BY pee1.effective_start_date,paa.assignment_id,pee1.element_entry_id,pet.element_type_id;