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_JP_IWHT_REPORT_PKG dependencies on PAY_CORE_UTILS

Line 377: SELECT pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group

373: IS
374: --
375: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
376: IS
377: SELECT pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year

Line 378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat

374: --
375: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
376: IS
377: SELECT pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent

Line 379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id

375: CURSOR lcr_params(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
376: IS
377: SELECT pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order

Line 380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date

376: IS
377: SELECT pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from

Line 381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year

377: SELECT pay_core_utils.get_parameter('REP_GROUP',legislative_parameters) rep_group
378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from
385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to

Line 382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent

378: ,pay_core_utils.get_parameter('REP_CAT',legislative_parameters) rep_cat
379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from
385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to
386: ,pay_core_utils.get_parameter('ASS_SETID',legislative_parameters) ass_setid

Line 383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order

379: ,pay_core_utils.get_parameter('BG',legislative_parameters) business_group_id
380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from
385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to
386: ,pay_core_utils.get_parameter('ASS_SETID',legislative_parameters) ass_setid
387: FROM pay_payroll_actions PPA

Line 384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from

380: ,TO_DATE(pay_core_utils.get_parameter('EFFDATE',legislative_parameters),'YYYY/MM/DD') effective_date
381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from
385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to
386: ,pay_core_utils.get_parameter('ASS_SETID',legislative_parameters) ass_setid
387: FROM pay_payroll_actions PPA
388: WHERE PPA.payroll_action_id = p_payroll_action_id;

Line 385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to

381: ,pay_core_utils.get_parameter('SUB',legislative_parameters) subject_year
382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from
385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to
386: ,pay_core_utils.get_parameter('ASS_SETID',legislative_parameters) ass_setid
387: FROM pay_payroll_actions PPA
388: WHERE PPA.payroll_action_id = p_payroll_action_id;
389: --

Line 386: ,pay_core_utils.get_parameter('ASS_SETID',legislative_parameters) ass_setid

382: ,pay_core_utils.get_parameter('ITWA',legislative_parameters) withholding_agent
383: ,pay_core_utils.get_parameter('SORT_ORDER',legislative_parameters) sort_order
384: ,TO_DATE(pay_core_utils.get_parameter('TEDF',legislative_parameters),'YYYY/MM/DD') termination_date_from
385: ,TO_DATE(pay_core_utils.get_parameter('TEDT',legislative_parameters),'YYYY/MM/DD') termination_date_to
386: ,pay_core_utils.get_parameter('ASS_SETID',legislative_parameters) ass_setid
387: FROM pay_payroll_actions PPA
388: WHERE PPA.payroll_action_id = p_payroll_action_id;
389: --
390: -- Local Variables

Line 807: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));

803: INTO lc_legislative_parameters
804: FROM pay_payroll_actions
805: WHERE payroll_action_id = p_payroll_action_id;
806: --
807: ln_ass_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ASS_SETID',lc_legislative_parameters));
808: --
809: g_mag_payroll_action_id := p_payroll_action_id;
810: gb_debug := hr_utility.debug_enabled ;
811: --