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_MX_SOC_SEC_ARCHIVE dependencies on PAY_MX_UTILITY

Line 500: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)

496: FROM hr_all_organization_units
497: WHERE organization_id = cp_organization_id;
498:
499: CURSOR c_get_start_date(cp_tax_unit_id IN NUMBER) IS
500: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)
501: FROM pay_payroll_actions ppa
502: WHERE ppa.report_type = 'SS_ARCHIVE'
503: AND ppa.report_qualifier = 'SS_ARCHIVE'
504: AND ppa.report_category = 'RT'

Line 505: AND pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) =

501: FROM pay_payroll_actions ppa
502: WHERE ppa.report_type = 'SS_ARCHIVE'
503: AND ppa.report_qualifier = 'SS_ARCHIVE'
504: AND ppa.report_category = 'RT'
505: AND pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) =
506: cp_tax_unit_id
507: ORDER BY ppa.payroll_action_id desc ;
508:
509:

Line 594: pay_mx_utility.get_default_imp_date) ;

590:
591: -- defaulting to Report Implementation Date from
592: -- mx pay legislation info table
593: ld_report_imp_date := fnd_date.canonical_to_date(
594: pay_mx_utility.get_default_imp_date) ;
595:
596: END IF;
597:
598: CLOSE c_get_imp_date;

Line 677: ,pay_mx_utility.get_legi_param_val('START_DATE',

673: )
674: IS
675: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
676: SELECT business_group_id
677: ,pay_mx_utility.get_legi_param_val('START_DATE',
678: LEGISLATIVE_PARAMETERS) start_date
679: ,pay_mx_utility.get_legi_param_val('END_DATE',
680: LEGISLATIVE_PARAMETERS) end_date
681: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE

Line 679: ,pay_mx_utility.get_legi_param_val('END_DATE',

675: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
676: SELECT business_group_id
677: ,pay_mx_utility.get_legi_param_val('START_DATE',
678: LEGISLATIVE_PARAMETERS) start_date
679: ,pay_mx_utility.get_legi_param_val('END_DATE',
680: LEGISLATIVE_PARAMETERS) end_date
681: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
682: ,pay_mx_utility.get_legi_param_val('MODE',
683: LEGISLATIVE_PARAMETERS) REPORT_MODE

Line 681: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE

677: ,pay_mx_utility.get_legi_param_val('START_DATE',
678: LEGISLATIVE_PARAMETERS) start_date
679: ,pay_mx_utility.get_legi_param_val('END_DATE',
680: LEGISLATIVE_PARAMETERS) end_date
681: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
682: ,pay_mx_utility.get_legi_param_val('MODE',
683: LEGISLATIVE_PARAMETERS) REPORT_MODE
684: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
685: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE

Line 682: ,pay_mx_utility.get_legi_param_val('MODE',

678: LEGISLATIVE_PARAMETERS) start_date
679: ,pay_mx_utility.get_legi_param_val('END_DATE',
680: LEGISLATIVE_PARAMETERS) end_date
681: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
682: ,pay_mx_utility.get_legi_param_val('MODE',
683: LEGISLATIVE_PARAMETERS) REPORT_MODE
684: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
685: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE
686: FROM pay_payroll_actions

Line 684: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',

680: LEGISLATIVE_PARAMETERS) end_date
681: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
682: ,pay_mx_utility.get_legi_param_val('MODE',
683: LEGISLATIVE_PARAMETERS) REPORT_MODE
684: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
685: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE
686: FROM pay_payroll_actions
687: WHERE payroll_action_id = cp_payroll_action_id;
688:

Line 4269: AND pay_mx_utility.get_legi_param_val('GRE',

4265: ,pay_assignment_actions paa_prev
4266: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4267: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4268: AND ppa_prev.report_category = 'RT'
4269: AND pay_mx_utility.get_legi_param_val('GRE',
4270: ppa_prev.legislative_parameters) = p_gre_id
4271: AND TRUNC( fnd_date.canonical_to_date (
4272: pay_mx_utility.get_legi_param_val(
4273: 'PERIOD_ENDING_DATE',

Line 4272: pay_mx_utility.get_legi_param_val(

4268: AND ppa_prev.report_category = 'RT'
4269: AND pay_mx_utility.get_legi_param_val('GRE',
4270: ppa_prev.legislative_parameters) = p_gre_id
4271: AND TRUNC( fnd_date.canonical_to_date (
4272: pay_mx_utility.get_legi_param_val(
4273: 'PERIOD_ENDING_DATE',
4274: ppa_prev.legislative_parameters) ) ) =
4275: TRUNC(p_periodic_end_date)
4276: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id

Line 4278: AND pay_mx_utility.get_legi_param_val('MX_IDWV',

4274: ppa_prev.legislative_parameters) ) ) =
4275: TRUNC(p_periodic_end_date)
4276: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4277: AND paa_prev.assignment_id = p_assignment_id
4278: AND pay_mx_utility.get_legi_param_val('MX_IDWV',
4279: paa_prev.serial_number) = 'Y';
4280:
4281:
4282: BEGIN

Line 4429: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )

4425: FROM pay_payroll_actions
4426: WHERE report_type = 'SS_ARCHIVE'
4427: AND report_qualifier = 'SS_ARCHIVE'
4428: AND report_category = 'RT'
4429: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )
4430: = ln_gre_id
4431: AND payroll_action_id + 0 < p_payroll_action_id;
4432:
4433: /****************************************************************

Line 4582: AND pay_mx_utility.get_legi_param_val('GRE',

4578: ,pay_assignment_actions paa_prev
4579: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4580: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4581: AND ppa_prev.report_category = 'RT'
4582: AND pay_mx_utility.get_legi_param_val('GRE',
4583: ppa_prev.legislative_parameters) = cp_gre_id
4584: AND TRUNC( fnd_date.canonical_to_date (
4585: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4586: ppa_prev.legislative_parameters) ) ) =

Line 4585: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',

4581: AND ppa_prev.report_category = 'RT'
4582: AND pay_mx_utility.get_legi_param_val('GRE',
4583: ppa_prev.legislative_parameters) = cp_gre_id
4584: AND TRUNC( fnd_date.canonical_to_date (
4585: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4586: ppa_prev.legislative_parameters) ) ) =
4587: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4588: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4589: AND paa_prev.assignment_id = paf.assignment_id

Line 4590: AND pay_mx_utility.get_legi_param_val('MX_IDWV',

4586: ppa_prev.legislative_parameters) ) ) =
4587: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4588: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4589: AND paa_prev.assignment_id = paf.assignment_id
4590: AND pay_mx_utility.get_legi_param_val('MX_IDWV',
4591: paa_prev.serial_number) = 'Y' )
4592: AND gv_mode = 'P'
4593: ORDER BY 1, 2, 3, 4 desc;
4594:

Line 4667: AND pay_mx_utility.get_legi_param_val('GRE',

4663: ,pay_assignment_actions paa_prev
4664: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4665: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4666: AND ppa_prev.report_category = 'RT'
4667: AND pay_mx_utility.get_legi_param_val('GRE',
4668: ppa_prev.legislative_parameters) = cp_gre_id
4669: AND TRUNC( fnd_date.canonical_to_date (
4670: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4671: ppa_prev.legislative_parameters) ) ) =

Line 4670: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',

4666: AND ppa_prev.report_category = 'RT'
4667: AND pay_mx_utility.get_legi_param_val('GRE',
4668: ppa_prev.legislative_parameters) = cp_gre_id
4669: AND TRUNC( fnd_date.canonical_to_date (
4670: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4671: ppa_prev.legislative_parameters) ) ) =
4672: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4673: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4674: AND paa_prev.assignment_id = paf.assignment_id

Line 4675: AND pay_mx_utility.get_legi_param_val('MX_IDWV',

4671: ppa_prev.legislative_parameters) ) ) =
4672: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4673: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4674: AND paa_prev.assignment_id = paf.assignment_id
4675: AND pay_mx_utility.get_legi_param_val('MX_IDWV',
4676: paa_prev.serial_number) = 'Y' )
4677: AND gv_mode = 'P'
4678: ORDER BY 1, 2, 3, 4 desc;*/
4679: -- bug:15839415 start

Line 5202: NVL(pay_mx_utility.get_legi_param_val('MX_IDWV',lv_serial_number), 'N');

5198: ** whether this assignment has variable IDW or not.
5199: ***********************************************************/
5200:
5201: gv_variable_idw :=
5202: NVL(pay_mx_utility.get_legi_param_val('MX_IDWV',lv_serial_number), 'N');
5203: hr_utility_trace('--> gv_variable_idw' || gv_variable_idw );
5204:
5205: hr_utility.set_location(gv_package || lv_procedure_name, 20);
5206: ln_step := 2;

Line 5431: SELECT pay_mx_utility.get_legi_param_val('GRE',

5427: ,table_name
5428: FROM pay_dated_tables;
5429:
5430: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
5431: SELECT pay_mx_utility.get_legi_param_val('GRE',
5432: LEGISLATIVE_PARAMETERS) GRE,
5433: fnd_date.canonical_to_date(
5434: pay_mx_utility.get_legi_param_val(
5435: 'END_DATE',

Line 5434: pay_mx_utility.get_legi_param_val(

5430: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
5431: SELECT pay_mx_utility.get_legi_param_val('GRE',
5432: LEGISLATIVE_PARAMETERS) GRE,
5433: fnd_date.canonical_to_date(
5434: pay_mx_utility.get_legi_param_val(
5435: 'END_DATE',
5436: LEGISLATIVE_PARAMETERS)) END_DATE
5437: FROM pay_payroll_actions
5438: WHERE payroll_action_id = cp_payroll_action_id;

Line 5465: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )

5461: FROM pay_payroll_actions
5462: WHERE report_type = 'SS_ARCHIVE'
5463: AND report_qualifier = 'SS_ARCHIVE'
5464: AND report_category = 'RT'
5465: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )
5466: = ln_gre_id
5467: AND payroll_action_id + 0 < p_payroll_action_id;
5468:
5469: pay_recorded_requests_pkg.get_recorded_date_no_ins(