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 431: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)

427: FROM hr_all_organization_units
428: WHERE organization_id = cp_organization_id;
429:
430: CURSOR c_get_start_date(cp_tax_unit_id IN NUMBER) IS
431: SELECT pay_mx_utility.get_legi_param_val('END_DATE',LEGISLATIVE_PARAMETERS)
432: FROM pay_payroll_actions ppa
433: WHERE ppa.report_type = 'SS_ARCHIVE'
434: AND ppa.report_qualifier = 'SS_ARCHIVE'
435: AND ppa.report_category = 'RT'

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

432: FROM pay_payroll_actions ppa
433: WHERE ppa.report_type = 'SS_ARCHIVE'
434: AND ppa.report_qualifier = 'SS_ARCHIVE'
435: AND ppa.report_category = 'RT'
436: AND pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) =
437: cp_tax_unit_id
438: ORDER BY ppa.payroll_action_id desc ;
439:
440:

Line 525: pay_mx_utility.get_default_imp_date) ;

521:
522: -- defaulting to Report Implementation Date from
523: -- mx pay legislation info table
524: ld_report_imp_date := fnd_date.canonical_to_date(
525: pay_mx_utility.get_default_imp_date) ;
526:
527: END IF;
528:
529: CLOSE c_get_imp_date;

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

604: )
605: IS
606: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
607: SELECT business_group_id
608: ,pay_mx_utility.get_legi_param_val('START_DATE',
609: LEGISLATIVE_PARAMETERS) start_date
610: ,pay_mx_utility.get_legi_param_val('END_DATE',
611: LEGISLATIVE_PARAMETERS) end_date
612: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE

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

606: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
607: SELECT business_group_id
608: ,pay_mx_utility.get_legi_param_val('START_DATE',
609: LEGISLATIVE_PARAMETERS) start_date
610: ,pay_mx_utility.get_legi_param_val('END_DATE',
611: LEGISLATIVE_PARAMETERS) end_date
612: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
613: ,pay_mx_utility.get_legi_param_val('MODE',
614: LEGISLATIVE_PARAMETERS) REPORT_MODE

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

608: ,pay_mx_utility.get_legi_param_val('START_DATE',
609: LEGISLATIVE_PARAMETERS) start_date
610: ,pay_mx_utility.get_legi_param_val('END_DATE',
611: LEGISLATIVE_PARAMETERS) end_date
612: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
613: ,pay_mx_utility.get_legi_param_val('MODE',
614: LEGISLATIVE_PARAMETERS) REPORT_MODE
615: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
616: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE

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

609: LEGISLATIVE_PARAMETERS) start_date
610: ,pay_mx_utility.get_legi_param_val('END_DATE',
611: LEGISLATIVE_PARAMETERS) end_date
612: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
613: ,pay_mx_utility.get_legi_param_val('MODE',
614: LEGISLATIVE_PARAMETERS) REPORT_MODE
615: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
616: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE
617: FROM pay_payroll_actions

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

611: LEGISLATIVE_PARAMETERS) end_date
612: ,pay_mx_utility.get_legi_param_val('GRE',LEGISLATIVE_PARAMETERS) GRE
613: ,pay_mx_utility.get_legi_param_val('MODE',
614: LEGISLATIVE_PARAMETERS) REPORT_MODE
615: ,pay_mx_utility.get_legi_param_val('PERIOD_ENDING_DATE',
616: LEGISLATIVE_PARAMETERS) PERIOD_ENDING_DATE
617: FROM pay_payroll_actions
618: WHERE payroll_action_id = cp_payroll_action_id;
619:

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

4036: FROM pay_payroll_actions
4037: WHERE report_type = 'SS_ARCHIVE'
4038: AND report_qualifier = 'SS_ARCHIVE'
4039: AND report_category = 'RT'
4040: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )
4041: = ln_gre_id
4042: AND payroll_action_id + 0 < p_payroll_action_id;
4043:
4044: /****************************************************************

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

4142: ,pay_assignment_actions paa_prev
4143: WHERE ppa_prev.report_type = ''SS_ARCHIVE''
4144: AND ppa_prev.report_qualifier = ''SS_ARCHIVE''
4145: AND ppa_prev.report_category = ''RT''
4146: AND pay_mx_utility.get_legi_param_val(''GRE'',
4147: ppa_prev.legislative_parameters) = '||
4148: ln_gre_id|| ' '||
4149: 'AND TRUNC( fnd_date.canonical_to_date (
4150: pay_mx_utility.get_legi_param_val(

Line 4150: pay_mx_utility.get_legi_param_val(

4146: AND pay_mx_utility.get_legi_param_val(''GRE'',
4147: ppa_prev.legislative_parameters) = '||
4148: ln_gre_id|| ' '||
4149: 'AND TRUNC( fnd_date.canonical_to_date (
4150: pay_mx_utility.get_legi_param_val(
4151: ''PERIOD_ENDING_DATE'',
4152: ppa_prev.legislative_parameters) ) ) = ' ||
4153: 'TRUNC(fnd_date.canonical_to_date('''||
4154: gv_periodic_end_date|| ''') ) '||

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

4153: 'TRUNC(fnd_date.canonical_to_date('''||
4154: gv_periodic_end_date|| ''') ) '||
4155: 'AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4156: AND paa_prev.assignment_id = paf.assignment_id
4157: AND pay_mx_utility.get_legi_param_val(''MX_IDWV'',
4158: paa_prev.serial_number) = ''Y'' ) ' ||
4159: 'AND '''|| gv_mode || ''' = ''P'' ) ' ||
4160: 'ORDER BY person_id';
4161:

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

4247: ,pay_assignment_actions paa_prev
4248: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4249: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4250: AND ppa_prev.report_category = 'RT'
4251: AND pay_mx_utility.get_legi_param_val('GRE',
4252: ppa_prev.legislative_parameters) = cp_gre_id
4253: AND TRUNC( fnd_date.canonical_to_date (
4254: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4255: ppa_prev.legislative_parameters) ) ) =

Line 4254: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',

4250: AND ppa_prev.report_category = 'RT'
4251: AND pay_mx_utility.get_legi_param_val('GRE',
4252: ppa_prev.legislative_parameters) = cp_gre_id
4253: AND TRUNC( fnd_date.canonical_to_date (
4254: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4255: ppa_prev.legislative_parameters) ) ) =
4256: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4257: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4258: AND paa_prev.assignment_id = paf.assignment_id

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

4255: ppa_prev.legislative_parameters) ) ) =
4256: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4257: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4258: AND paa_prev.assignment_id = paf.assignment_id
4259: AND pay_mx_utility.get_legi_param_val('MX_IDWV',
4260: paa_prev.serial_number) = 'Y' )
4261: AND gv_mode = 'P'
4262: ORDER BY 1, 2, 3, 4 desc;
4263:

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

4332: ,pay_assignment_actions paa_prev
4333: WHERE ppa_prev.report_type = 'SS_ARCHIVE'
4334: AND ppa_prev.report_qualifier = 'SS_ARCHIVE'
4335: AND ppa_prev.report_category = 'RT'
4336: AND pay_mx_utility.get_legi_param_val('GRE',
4337: ppa_prev.legislative_parameters) = cp_gre_id
4338: AND TRUNC( fnd_date.canonical_to_date (
4339: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4340: ppa_prev.legislative_parameters) ) ) =

Line 4339: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',

4335: AND ppa_prev.report_category = 'RT'
4336: AND pay_mx_utility.get_legi_param_val('GRE',
4337: ppa_prev.legislative_parameters) = cp_gre_id
4338: AND TRUNC( fnd_date.canonical_to_date (
4339: pay_mx_utility.get_legi_param_val( 'PERIOD_ENDING_DATE',
4340: ppa_prev.legislative_parameters) ) ) =
4341: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4342: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4343: AND paa_prev.assignment_id = paf.assignment_id

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

4340: ppa_prev.legislative_parameters) ) ) =
4341: TRUNC(fnd_date.canonical_to_date(cp_periodic_end_date))
4342: AND paa_prev.payroll_action_id = ppa_prev.payroll_action_id
4343: AND paa_prev.assignment_id = paf.assignment_id
4344: AND pay_mx_utility.get_legi_param_val('MX_IDWV',
4345: paa_prev.serial_number) = 'Y' )
4346: AND gv_mode = 'P'
4347: ORDER BY 1, 2, 3, 4 desc;
4348:

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

4731: ** whether this assignment has variable IDW or not.
4732: ***********************************************************/
4733:
4734: gv_variable_idw :=
4735: NVL(pay_mx_utility.get_legi_param_val('MX_IDWV',lv_serial_number), 'N');
4736: hr_utility_trace('--> gv_variable_idw' || gv_variable_idw );
4737:
4738: hr_utility.set_location(gv_package || lv_procedure_name, 20);
4739: ln_step := 2;

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

4960: ,table_name
4961: FROM pay_dated_tables;
4962:
4963: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
4964: SELECT pay_mx_utility.get_legi_param_val('GRE',
4965: LEGISLATIVE_PARAMETERS) GRE,
4966: fnd_date.canonical_to_date(
4967: pay_mx_utility.get_legi_param_val(
4968: 'END_DATE',

Line 4967: pay_mx_utility.get_legi_param_val(

4963: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
4964: SELECT pay_mx_utility.get_legi_param_val('GRE',
4965: LEGISLATIVE_PARAMETERS) GRE,
4966: fnd_date.canonical_to_date(
4967: pay_mx_utility.get_legi_param_val(
4968: 'END_DATE',
4969: LEGISLATIVE_PARAMETERS)) END_DATE
4970: FROM pay_payroll_actions
4971: WHERE payroll_action_id = cp_payroll_action_id;

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

4994: FROM pay_payroll_actions
4995: WHERE report_type = 'SS_ARCHIVE'
4996: AND report_qualifier = 'SS_ARCHIVE'
4997: AND report_category = 'RT'
4998: AND pay_mx_utility.get_legi_param_val('GRE', legislative_parameters )
4999: = ln_gre_id
5000: AND payroll_action_id + 0 < p_payroll_action_id;
5001:
5002: pay_recorded_requests_pkg.get_recorded_date_no_ins(