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_DK_PAYMENT_PROCESS_PKG

Line 1: PACKAGE BODY PAY_DK_PAYMENT_PROCESS_PKG as

1: PACKAGE BODY PAY_DK_PAYMENT_PROCESS_PKG as
2: /* $Header: pydkpaypr.pkb 120.27.12020000.2 2013/03/15 05:53:21 rsahai ship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_PAYMENT_PROCESS_PKG.';

Line 5: g_package CONSTANT varchar2(33) := 'PAY_DK_PAYMENT_PROCESS_PKG.';

1: PACKAGE BODY PAY_DK_PAYMENT_PROCESS_PKG as
2: /* $Header: pydkpaypr.pkb 120.27.12020000.2 2013/03/15 05:53:21 rsahai ship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_PAYMENT_PROCESS_PKG.';
6:
7: --12759416
8: FUNCTION DK_PBS_GET_ATP_TAX_INFO(
9: p_payroll_action_id IN NUMBER,

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 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 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 964: END PAY_DK_PAYMENT_PROCESS_PKG;

960:
961: END get_collective_agr_no;
962: --15985354
963:
964: END PAY_DK_PAYMENT_PROCESS_PKG;