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.8.12000000.5 2007/03/27 11:41:43 nprasath noship $ */
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.8.12000000.5 2007/03/27 11:41:43 nprasath noship $ */
3:
4: --Global parameters
5: g_package CONSTANT varchar2(33) := 'PAY_DK_PAYMENT_PROCESS_PKG.';
6:
7:
8:
9: -----------------------------------------------------------------------------

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

671: Return l_period_per_year;
672:
673: END get_pay_period_per_year;
674:
675: END PAY_DK_PAYMENT_PROCESS_PKG;