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 200: SELECT pay_mx_utility.get_legi_param_val('GRE',

196: P_END_DATE OUT NOCOPY varchar2,
197: P_MODE OUT NOCOPY varchar2
198: ) IS
199: CURSOR csr_get_mag_pact_info IS
200: SELECT pay_mx_utility.get_legi_param_val('GRE',
201: ppa_mag.legislative_parameters),
202: pay_mx_utility.get_legi_param_val('START_DATE',
203: ppa_mag.legislative_parameters),
204: pay_mx_utility.get_legi_param_val('END_DATE',

Line 202: pay_mx_utility.get_legi_param_val('START_DATE',

198: ) IS
199: CURSOR csr_get_mag_pact_info IS
200: SELECT pay_mx_utility.get_legi_param_val('GRE',
201: ppa_mag.legislative_parameters),
202: pay_mx_utility.get_legi_param_val('START_DATE',
203: ppa_mag.legislative_parameters),
204: pay_mx_utility.get_legi_param_val('END_DATE',
205: ppa_mag.legislative_parameters),
206: pay_mx_utility.get_legi_param_val('MODE',

Line 204: pay_mx_utility.get_legi_param_val('END_DATE',

200: SELECT pay_mx_utility.get_legi_param_val('GRE',
201: ppa_mag.legislative_parameters),
202: pay_mx_utility.get_legi_param_val('START_DATE',
203: ppa_mag.legislative_parameters),
204: pay_mx_utility.get_legi_param_val('END_DATE',
205: ppa_mag.legislative_parameters),
206: pay_mx_utility.get_legi_param_val('MODE',
207: ppa_mag.legislative_parameters)
208: FROM pay_payroll_actions ppa_mag

Line 206: pay_mx_utility.get_legi_param_val('MODE',

202: pay_mx_utility.get_legi_param_val('START_DATE',
203: ppa_mag.legislative_parameters),
204: pay_mx_utility.get_legi_param_val('END_DATE',
205: ppa_mag.legislative_parameters),
206: pay_mx_utility.get_legi_param_val('MODE',
207: ppa_mag.legislative_parameters)
208: FROM pay_payroll_actions ppa_mag
209: WHERE ppa_mag.payroll_action_id = p_payroll_action_id;
210:

Line 251: pay_mx_utility.get_legi_param_val ('END_DATE',

247:
248: CURSOR c_get_last_run_date IS
249: SELECT fnd_date.date_to_canonical(
250: fnd_date.canonical_to_date(
251: pay_mx_utility.get_legi_param_val ('END_DATE',
252: ppa.legislative_parameters)) +
253: 1/(24 * 60 * 60))
254: FROM pay_payroll_actions ppa
255: WHERE pay_mx_utility.get_legi_param_val('GRE',

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

251: pay_mx_utility.get_legi_param_val ('END_DATE',
252: ppa.legislative_parameters)) +
253: 1/(24 * 60 * 60))
254: FROM pay_payroll_actions ppa
255: WHERE pay_mx_utility.get_legi_param_val('GRE',
256: ppa.legislative_parameters) =
257: p_gre_id
258: AND ppa.report_type = 'SUA_MAG'
259: AND ppa.report_qualifier = 'SUA_MAG'

Line 295: lv_start_date := pay_mx_utility.get_default_imp_date;

291: FETCH c_get_imp_date INTO lv_start_date;
292: IF ((c_get_imp_date%NOTFOUND) OR (lv_start_date IS NULL)) THEN
293: -- defaulting to Report Implementation Date from
294: -- mx pay legislation info table
295: lv_start_date := pay_mx_utility.get_default_imp_date;
296: END IF;
297: CLOSE c_get_imp_date;
298:
299: IF (p_mode = 'INCREMENT') THEN

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

341: FROM pay_assignment_actions paa_arch,
342: pay_payroll_actions ppa_arch
343: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
344: AND paa_arch.tax_unit_id = '|| g_mag_gre_id ||'/*
345: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(''END_DATE'',
346: ppa_arch.legislative_parameters))
347: BETWEEN fnd_date.canonical_to_date ('''|| g_mag_start_date ||''')
348: AND fnd_date.canonical_to_date ('''|| g_mag_end_date ||''')
349: */AND ppa_arch.action_type = ''X''

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

386: AND paa_arch.assignment_id = paf.assignment_id
387: -- Bug 4518777
388: AND paf.person_id BETWEEN p_start_person_id AND p_end_person_id
389: AND paa_arch.tax_unit_id = g_mag_gre_id
390: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
391: 'END_DATE',
392: ppa_arch.legislative_parameters))
393: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
394: AND fnd_date.canonical_to_date(g_mag_end_date)*/

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

447: AND paf.person_id = ppr.person_id
448: AND ppr.chunk_number = p_chunk
449: AND ppr.payroll_action_id = p_payroll_action_id
450: AND paa_arch.tax_unit_id = g_mag_gre_id
451: /*AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val(
452: 'END_DATE',
453: ppa_arch.legislative_parameters))
454: BETWEEN fnd_date.canonical_to_date(g_mag_start_date)
455: AND fnd_date.canonical_to_date(g_mag_end_date)*/

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

500: AND ppa.report_qualifier = 'SUA_MAG'
501: AND ppa.report_category = 'RT'
502: AND ppa.action_type = 'X'
503: AND ppa.action_status = 'C'
504: AND pay_mx_utility.get_legi_param_val('GRE',
505: ppa.legislative_parameters) =
506: g_mag_gre_id
507: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
508: 'END_DATE',

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

503: AND ppa.action_status = 'C'
504: AND pay_mx_utility.get_legi_param_val('GRE',
505: ppa.legislative_parameters) =
506: g_mag_gre_id
507: AND fnd_date.canonical_to_date(pay_mx_utility.get_legi_param_val(
508: 'END_DATE',
509: ppa.legislative_parameters)) >
510: fnd_date.canonical_to_date(g_mag_end_date);
511:

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

744: pay_action_information pai,
745: pay_action_interlocks lck
746: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id
747: AND paa_mag_prev.payroll_action_id = ppa_mag_prev.payroll_action_id
748: AND pay_mx_utility.get_legi_param_val ('GRE',
749: ppa_mag.payroll_action_id) =
750: pay_mx_utility.get_legi_param_val ('GRE',
751: ppa_mag_prev.payroll_action_id)
752: AND ppa_mag_prev.payroll_action_id < ppa_mag.payroll_action_id

Line 750: pay_mx_utility.get_legi_param_val ('GRE',

746: WHERE paa_mag.payroll_action_id = ppa_mag.payroll_action_id
747: AND paa_mag_prev.payroll_action_id = ppa_mag_prev.payroll_action_id
748: AND pay_mx_utility.get_legi_param_val ('GRE',
749: ppa_mag.payroll_action_id) =
750: pay_mx_utility.get_legi_param_val ('GRE',
751: ppa_mag_prev.payroll_action_id)
752: AND ppa_mag_prev.payroll_action_id < ppa_mag.payroll_action_id
753: AND paa_mag_prev.assignment_action_id = lck.locking_action_id
754: AND lck.locked_action_id = pai.action_context_id

Line 785: pay_mx_utility.get_legi_param_val('END_DATE',

781: FROM DUAL
782: UNION
783: SELECT paa.assignment_action_id,
784: fnd_date.canonical_to_date(
785: pay_mx_utility.get_legi_param_val('END_DATE',
786: ppa.legislative_parameters))
787: FROM pay_payroll_actions ppa,
788: pay_assignment_actions paa,
789: per_assignments_f paf

Line 794: pay_mx_utility.get_legi_param_val('END_DATE',

790: WHERE ppa.payroll_action_id = paa.payroll_action_id
791: AND paa.assignment_id = paf.assignment_id
792: AND paf.person_id = cp_person_id
793: AND fnd_date.canonical_to_date(
794: pay_mx_utility.get_legi_param_val('END_DATE',
795: ppa.legislative_parameters))
796: BETWEEN paf.effective_start_date AND paf.effective_end_date
797: AND ppa.action_type = 'X'
798: AND ppa.report_type = 'SUA_MAG'

Line 803: pay_mx_utility.get_legi_param_val('GRE',

799: AND ppa.report_qualifier = 'SUA_MAG'
800: AND ppa.report_category = 'RT'
801: AND ppa.action_status = 'C'
802: /*AND cp_gre_id = fnd_number.canonical_to_number(
803: pay_mx_utility.get_legi_param_val('GRE',
804: ppa.legislative_parameters))
805: AND cp_curr_date > fnd_date.canonical_to_date(
806: pay_mx_utility.get_legi_param_val('END_DATE',
807: ppa.legislative_parameters))*/

Line 806: pay_mx_utility.get_legi_param_val('END_DATE',

802: /*AND cp_gre_id = fnd_number.canonical_to_number(
803: pay_mx_utility.get_legi_param_val('GRE',
804: ppa.legislative_parameters))
805: AND cp_curr_date > fnd_date.canonical_to_date(
806: pay_mx_utility.get_legi_param_val('END_DATE',
807: ppa.legislative_parameters))*/
808: AND fnd_number.canonical_to_number(g_mag_gre_id) =
809: fnd_number.canonical_to_number(
810: pay_mx_utility.get_legi_param_val('GRE',

Line 810: pay_mx_utility.get_legi_param_val('GRE',

806: pay_mx_utility.get_legi_param_val('END_DATE',
807: ppa.legislative_parameters))*/
808: AND fnd_number.canonical_to_number(g_mag_gre_id) =
809: fnd_number.canonical_to_number(
810: pay_mx_utility.get_legi_param_val('GRE',
811: ppa.legislative_parameters))
812: AND fnd_date.canonical_to_date(g_mag_end_date) >
813: fnd_date.canonical_to_date(
814: pay_mx_utility.get_legi_param_val('END_DATE',

Line 814: pay_mx_utility.get_legi_param_val('END_DATE',

810: pay_mx_utility.get_legi_param_val('GRE',
811: ppa.legislative_parameters))
812: AND fnd_date.canonical_to_date(g_mag_end_date) >
813: fnd_date.canonical_to_date(
814: pay_mx_utility.get_legi_param_val('END_DATE',
815: ppa.legislative_parameters))
816: ORDER BY 2 DESC;
817:
818: CURSOR csr_prev_idw (cp_person_id VARCHAR2) IS

Line 839: pay_mx_utility.get_legi_param_val('GRE',

835: AND ppa_sua.report_category = 'RT'
836: AND ppa_sua.action_status = 'C'
837: AND fnd_number.canonical_to_number(g_mag_gre_id) =
838: fnd_number.canonical_to_number(
839: pay_mx_utility.get_legi_param_val('GRE',
840: ppa_sua.legislative_parameters))
841: AND fnd_date.canonical_to_date(g_mag_end_date) >
842: fnd_date.canonical_to_date(
843: pay_mx_utility.get_legi_param_val('END_DATE',

Line 843: pay_mx_utility.get_legi_param_val('END_DATE',

839: pay_mx_utility.get_legi_param_val('GRE',
840: ppa_sua.legislative_parameters))
841: AND fnd_date.canonical_to_date(g_mag_end_date) >
842: fnd_date.canonical_to_date(
843: pay_mx_utility.get_legi_param_val('END_DATE',
844: ppa_sua.legislative_parameters))
845: -- Bug 5998981
846: AND DECODE (pai.action_information_category,
847: 'MX SS TRANSACTIONS',

Line 851: pay_mx_utility.get_legi_param_val('START_DATE',

847: 'MX SS TRANSACTIONS',
848: fnd_date.canonical_to_date(pai.action_information2),
849: hr_general.start_of_time)
850: BETWEEN fnd_date.canonical_to_date(
851: pay_mx_utility.get_legi_param_val('START_DATE',
852: ppa_sua.legislative_parameters))
853: AND fnd_date.canonical_to_date(
854: pay_mx_utility.get_legi_param_val('END_DATE',
855: ppa_sua.legislative_parameters))

Line 854: pay_mx_utility.get_legi_param_val('END_DATE',

850: BETWEEN fnd_date.canonical_to_date(
851: pay_mx_utility.get_legi_param_val('START_DATE',
852: ppa_sua.legislative_parameters))
853: AND fnd_date.canonical_to_date(
854: pay_mx_utility.get_legi_param_val('END_DATE',
855: ppa_sua.legislative_parameters))
856: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
857:
858: CURSOR c_get_imp_date (cp_gre_id NUMBER) IS

Line 939: ld_imp_date := pay_mx_utility.get_default_imp_date;

935: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);
936: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
937:
938: IF ld_imp_date IS NULL THEN
939: ld_imp_date := pay_mx_utility.get_default_imp_date;
940: END IF;
941: hr_utility_trace ('Actual Implementation Date is : '|| ld_imp_date);
942: OPEN csr_person(ln_assignment_action_id);
943: FETCH csr_person INTO lv_person_id;