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

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

214: P_END_DATE OUT NOCOPY varchar2,
215: P_MODE OUT NOCOPY varchar2
216: ) IS
217: CURSOR csr_get_mag_pact_info IS
218: SELECT pay_mx_utility.get_legi_param_val('GRE',
219: ppa_mag.legislative_parameters),
220: pay_mx_utility.get_legi_param_val('START_DATE',
221: ppa_mag.legislative_parameters),
222: pay_mx_utility.get_legi_param_val('END_DATE',

Line 220: pay_mx_utility.get_legi_param_val('START_DATE',

216: ) IS
217: CURSOR csr_get_mag_pact_info IS
218: SELECT pay_mx_utility.get_legi_param_val('GRE',
219: ppa_mag.legislative_parameters),
220: pay_mx_utility.get_legi_param_val('START_DATE',
221: ppa_mag.legislative_parameters),
222: pay_mx_utility.get_legi_param_val('END_DATE',
223: ppa_mag.legislative_parameters),
224: pay_mx_utility.get_legi_param_val('MODE',

Line 222: pay_mx_utility.get_legi_param_val('END_DATE',

218: SELECT pay_mx_utility.get_legi_param_val('GRE',
219: ppa_mag.legislative_parameters),
220: pay_mx_utility.get_legi_param_val('START_DATE',
221: ppa_mag.legislative_parameters),
222: pay_mx_utility.get_legi_param_val('END_DATE',
223: ppa_mag.legislative_parameters),
224: pay_mx_utility.get_legi_param_val('MODE',
225: ppa_mag.legislative_parameters)
226: FROM pay_payroll_actions ppa_mag

Line 224: pay_mx_utility.get_legi_param_val('MODE',

220: pay_mx_utility.get_legi_param_val('START_DATE',
221: ppa_mag.legislative_parameters),
222: pay_mx_utility.get_legi_param_val('END_DATE',
223: ppa_mag.legislative_parameters),
224: pay_mx_utility.get_legi_param_val('MODE',
225: ppa_mag.legislative_parameters)
226: FROM pay_payroll_actions ppa_mag
227: WHERE ppa_mag.payroll_action_id = p_payroll_action_id;
228:

Line 269: pay_mx_utility.get_legi_param_val ('END_DATE',

265:
266: CURSOR c_get_last_run_date IS
267: SELECT fnd_date.date_to_canonical(
268: fnd_date.canonical_to_date(
269: pay_mx_utility.get_legi_param_val ('END_DATE',
270: ppa.legislative_parameters)) +
271: 1/(24 * 60 * 60))
272: FROM pay_payroll_actions ppa
273: WHERE pay_mx_utility.get_legi_param_val('GRE',

Line 273: WHERE pay_mx_utility.get_legi_param_val('GRE',

269: pay_mx_utility.get_legi_param_val ('END_DATE',
270: ppa.legislative_parameters)) +
271: 1/(24 * 60 * 60))
272: FROM pay_payroll_actions ppa
273: WHERE pay_mx_utility.get_legi_param_val('GRE',
274: ppa.legislative_parameters) =
275: p_gre_id
276: AND ppa.report_type = 'SUA_MAG'
277: AND ppa.report_qualifier = 'SUA_MAG'

Line 313: lv_start_date := pay_mx_utility.get_default_imp_date;

309: FETCH c_get_imp_date INTO lv_start_date;
310: IF ((c_get_imp_date%NOTFOUND) OR (lv_start_date IS NULL)) THEN
311: -- defaulting to Report Implementation Date from
312: -- mx pay legislation info table
313: lv_start_date := pay_mx_utility.get_default_imp_date;
314: END IF;
315: CLOSE c_get_imp_date;
316:
317: IF (p_mode = 'INCREMENT') THEN

Line 373: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',

369: FROM pay_assignment_actions paa_arch,
370: pay_payroll_actions ppa_arch
371: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
372: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
373: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
374: ppa_arch.legislative_parameters))
375: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
376: AND fnd_date.canonical_to_date ('''|| l_new_end_date ||''')
377: */AND ppa_arch.action_type = ''X''

Line 419: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

415: AND paa_arch.assignment_id = paf.assignment_id
416: -- Bug 4518777
417: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id
418: AND paa_arch.tax_unit_id = g_mag_gre_id
419: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
420: 'END_DATE',
421: ppa_arch.legislative_parameters))
422: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
423: AND fnd_date.canonical_to_date(g_mag_end_date)*/

Line 440: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

436: AND fnd_date.canonical_to_date (pai.action_information2) <=
437: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
438: )
439: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
440: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
441: 'END_DATE',
442: ppa_arch.legislative_parameters))
443: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
444: /*Bug 8768679*/

Line 491: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

487: AND paf.person_id = ppr.person_id
488: AND ppr.chunk_number = p_chunk
489: AND ppr.payroll_action_id = p_payroll_action_id
490: AND paa_arch.tax_unit_id = g_mag_gre_id
491: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
492: 'END_DATE',
493: ppa_arch.legislative_parameters))
494: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
495: AND fnd_date.canonical_to_date(g_mag_end_date)*/

Line 512: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(

508: AND fnd_date.canonical_to_date (pai.action_information2) <=
509: fnd_date.canonical_to_date (decode(pai.action_information4 ,'08',p_end_date,g_mag_end_date))))
510: )
511: OR (pai.action_information_category = 'MX SS PERSON INFORMATION'
512: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
513: 'END_DATE',
514: ppa_arch.legislative_parameters))
515: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
516: /*Bug 8768679*/

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

550: AND ppa.report_qualifier = 'SUA_MAG'
551: AND ppa.report_category = 'RT'
552: AND ppa.action_type = 'X'
553: AND ppa.action_status = 'C'
554: AND pay_mx_utility.get_legi_param_val('GRE',
555: ppa.legislative_parameters) =
556: g_mag_gre_id
557: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
558: 'END_DATE',

Line 557: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(

553: AND ppa.action_status = 'C'
554: AND pay_mx_utility.get_legi_param_val('GRE',
555: ppa.legislative_parameters) =
556: g_mag_gre_id
557: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
558: 'END_DATE',
559: ppa.legislative_parameters)) >
560: fnd_date.canonical_to_date(g_mag_end_date);
561:

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

859: pay_action_information pai,
860: pay_action_interlocks lck
861: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id
862: AND paa_mag_prev.payroll_action_id = ppa_mag_prev.payroll_action_id
863: AND pay_mx_utility.get_legi_param_val ('GRE',
864: ppa_mag.payroll_action_id) =
865: pay_mx_utility.get_legi_param_val ('GRE',
866: ppa_mag_prev.payroll_action_id)
867: AND ppa_mag_prev.payroll_action_id < ppa_mag.payroll_action_id

Line 865: pay_mx_utility.get_legi_param_val ('GRE',

861: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id
862: AND paa_mag_prev.payroll_action_id = ppa_mag_prev.payroll_action_id
863: AND pay_mx_utility.get_legi_param_val ('GRE',
864: ppa_mag.payroll_action_id) =
865: pay_mx_utility.get_legi_param_val ('GRE',
866: ppa_mag_prev.payroll_action_id)
867: AND ppa_mag_prev.payroll_action_id < ppa_mag.payroll_action_id
868: AND paa_mag_prev.assignment_action_id = lck.locking_action_id
869: AND lck.locked_action_id = pai.action_context_id

Line 900: pay_mx_utility.get_legi_param_val('END_DATE',

896: FROM DUAL
897: UNION
898: SELECT paa.assignment_action_id,
899: fnd_date.canonical_to_date(
900: pay_mx_utility.get_legi_param_val('END_DATE',
901: ppa.legislative_parameters))
902: FROM pay_payroll_actions ppa,
903: pay_assignment_actions paa,
904: per_assignments_f paf

Line 909: pay_mx_utility.get_legi_param_val('END_DATE',

905: WHERE ppa.payroll_action_id = paa.payroll_action_id
906: AND paa.assignment_id = paf.assignment_id
907: AND paf.person_id = cp_person_id
908: AND fnd_date.canonical_to_date(
909: pay_mx_utility.get_legi_param_val('END_DATE',
910: ppa.legislative_parameters))
911: BETWEEN paf.effective_start_date AND paf.effective_end_date
912: AND ppa.action_type = 'X'
913: AND ppa.report_type = 'SUA_MAG'

Line 918: pay_mx_utility.get_legi_param_val('GRE',

914: AND ppa.report_qualifier = 'SUA_MAG'
915: AND ppa.report_category = 'RT'
916: AND ppa.action_status = 'C'
917: /*AND cp_gre_id = fnd_number.canonical_to_number(
918: pay_mx_utility.get_legi_param_val('GRE',
919: ppa.legislative_parameters))
920: AND cp_curr_date > fnd_date.canonical_to_date(
921: pay_mx_utility.get_legi_param_val('END_DATE',
922: ppa.legislative_parameters))*/

Line 921: pay_mx_utility.get_legi_param_val('END_DATE',

917: /*AND cp_gre_id = fnd_number.canonical_to_number(
918: pay_mx_utility.get_legi_param_val('GRE',
919: ppa.legislative_parameters))
920: AND cp_curr_date > fnd_date.canonical_to_date(
921: pay_mx_utility.get_legi_param_val('END_DATE',
922: ppa.legislative_parameters))*/
923: AND fnd_number.canonical_to_number(g_mag_gre_id) =
924: fnd_number.canonical_to_number(
925: pay_mx_utility.get_legi_param_val('GRE',

Line 925: pay_mx_utility.get_legi_param_val('GRE',

921: pay_mx_utility.get_legi_param_val('END_DATE',
922: ppa.legislative_parameters))*/
923: AND fnd_number.canonical_to_number(g_mag_gre_id) =
924: fnd_number.canonical_to_number(
925: pay_mx_utility.get_legi_param_val('GRE',
926: ppa.legislative_parameters))
927: AND fnd_date.canonical_to_date(g_mag_end_date) >
928: fnd_date.canonical_to_date(
929: pay_mx_utility.get_legi_param_val('END_DATE',

Line 929: pay_mx_utility.get_legi_param_val('END_DATE',

925: pay_mx_utility.get_legi_param_val('GRE',
926: ppa.legislative_parameters))
927: AND fnd_date.canonical_to_date(g_mag_end_date) >
928: fnd_date.canonical_to_date(
929: pay_mx_utility.get_legi_param_val('END_DATE',
930: ppa.legislative_parameters))
931: ORDER BY 2 DESC;
932:
933: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS

Line 954: pay_mx_utility.get_legi_param_val('GRE',

950: AND ppa_sua.report_category = 'RT'
951: AND ppa_sua.action_status = 'C'
952: AND fnd_number.canonical_to_number(g_mag_gre_id) =
953: fnd_number.canonical_to_number(
954: pay_mx_utility.get_legi_param_val('GRE',
955: ppa_sua.legislative_parameters))
956: AND fnd_date.canonical_to_date(g_mag_end_date) >
957: fnd_date.canonical_to_date(
958: pay_mx_utility.get_legi_param_val('END_DATE',

Line 958: pay_mx_utility.get_legi_param_val('END_DATE',

954: pay_mx_utility.get_legi_param_val('GRE',
955: ppa_sua.legislative_parameters))
956: AND fnd_date.canonical_to_date(g_mag_end_date) >
957: fnd_date.canonical_to_date(
958: pay_mx_utility.get_legi_param_val('END_DATE',
959: ppa_sua.legislative_parameters))
960: -- Bug 5998981
961: AND DECODE (pai.action_information_category,
962: 'MX SS TRANSACTIONS',

Line 966: pay_mx_utility.get_legi_param_val('START_DATE',

962: 'MX SS TRANSACTIONS',
963: fnd_date.canonical_to_date(pai.action_information2),
964: hr_general.start_of_time)
965: BETWEEN fnd_date.canonical_to_date(
966: pay_mx_utility.get_legi_param_val('START_DATE',
967: ppa_sua.legislative_parameters))
968: AND fnd_date.canonical_to_date(
969: pay_mx_utility.get_legi_param_val('END_DATE',
970: ppa_sua.legislative_parameters))

Line 969: pay_mx_utility.get_legi_param_val('END_DATE',

965: BETWEEN fnd_date.canonical_to_date(
966: pay_mx_utility.get_legi_param_val('START_DATE',
967: ppa_sua.legislative_parameters))
968: AND fnd_date.canonical_to_date(
969: pay_mx_utility.get_legi_param_val('END_DATE',
970: ppa_sua.legislative_parameters))
971: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
972:
973: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS

Line 1062: ld_imp_date := pay_mx_utility.get_default_imp_date;

1058: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);
1059: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1060:
1061: IF ld_imp_date IS NULL THEN
1062: ld_imp_date := pay_mx_utility.get_default_imp_date;
1063: END IF;
1064: hr_utility_trace ('Actual Implementation Date is : '|| ld_imp_date);
1065: OPEN csr_person(ln_assignment_action_id);
1066: FETCH csr_person INTO lv_person_id;