APPS.PER_MX_SS_AFFILIATION dependencies on PAY_MX_UTILITY

Line 164: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',

160: SELECT fnd_date.date_to_canonical (effective_date + 1/(24 * 60 * 60))
161: FROM pay_payroll_actions
162: WHERE report_type = 'SS_AFFILIATION'
163: AND report_qualifier IN ('HIRES', 'SEPARATIONS', 'SALARY')
164: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
165: legislative_parameters,
166: ' ') = TO_CHAR(p_trans_gre)
167: ORDER BY payroll_action_id DESC;
168:

Line 173: pay_mx_utility.get_legi_param_val('END_DATE',

169:
170: CURSOR csr_get_date_affl IS
171: SELECT fnd_date.date_to_canonical(
172: fnd_date.canonical_to_date(
173: pay_mx_utility.get_legi_param_val('END_DATE',
174: legislative_parameters)) +
175: 1/(24 * 60 * 60))
176: FROM pay_payroll_actions
177: WHERE report_type = 'MX_SS_AFFL'

Line 179: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',

175: 1/(24 * 60 * 60))
176: FROM pay_payroll_actions
177: WHERE report_type = 'MX_SS_AFFL'
178: AND report_qualifier = 'MX_SS_AFFL'
179: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
180: legislative_parameters) =
181: TO_CHAR(p_trans_gre)
182: ORDER BY payroll_action_id DESC;
183:

Line 228: l_start_date := pay_mx_utility.get_default_imp_date;

224: FETCH c_get_imp_date INTO l_start_date;
225: CLOSE c_get_imp_date;
226:
227: IF l_start_date IS NULL THEN
228: l_start_date := pay_mx_utility.get_default_imp_date;
229: END IF;
230: END IF;
231: END IF;
232:

Line 252: SELECT pay_mx_utility.get_legi_param_val('TRANS_GRE',

248: P_START_DATE OUT NOCOPY varchar2,
249: P_END_DATE OUT NOCOPY varchar2
250: ) IS
251: CURSOR csr_get_pact_info IS
252: SELECT pay_mx_utility.get_legi_param_val('TRANS_GRE',
253: ppa.legislative_parameters),
254: pay_mx_utility.get_legi_param_val('START_DATE',
255: ppa.legislative_parameters),
256: pay_mx_utility.get_legi_param_val('END_DATE',

Line 254: pay_mx_utility.get_legi_param_val('START_DATE',

250: ) IS
251: CURSOR csr_get_pact_info IS
252: SELECT pay_mx_utility.get_legi_param_val('TRANS_GRE',
253: ppa.legislative_parameters),
254: pay_mx_utility.get_legi_param_val('START_DATE',
255: ppa.legislative_parameters),
256: pay_mx_utility.get_legi_param_val('END_DATE',
257: ppa.legislative_parameters),
258: business_group_id

Line 256: pay_mx_utility.get_legi_param_val('END_DATE',

252: SELECT pay_mx_utility.get_legi_param_val('TRANS_GRE',
253: ppa.legislative_parameters),
254: pay_mx_utility.get_legi_param_val('START_DATE',
255: ppa.legislative_parameters),
256: pay_mx_utility.get_legi_param_val('END_DATE',
257: ppa.legislative_parameters),
258: business_group_id
259: FROM pay_payroll_actions ppa
260: WHERE ppa.payroll_action_id = p_payroll_action_id;

Line 690: pay_mx_utility.get_legi_param_val(cp_gre_token,

686: AND ppa_mag.report_qualifier = p_report_qualifier
687: AND ppa_mag.report_category = p_report_category
688: AND ppa_mag.action_status = 'C'
689: AND p_gre_id = fnd_number.canonical_to_number(
690: pay_mx_utility.get_legi_param_val(cp_gre_token,
691: ppa_mag.legislative_parameters))
692: AND p_end_date > fnd_date.canonical_to_date(
693: pay_mx_utility.get_legi_param_val('END_DATE',
694: ppa_mag.legislative_parameters))

Line 693: pay_mx_utility.get_legi_param_val('END_DATE',

689: AND p_gre_id = fnd_number.canonical_to_number(
690: pay_mx_utility.get_legi_param_val(cp_gre_token,
691: ppa_mag.legislative_parameters))
692: AND p_end_date > fnd_date.canonical_to_date(
693: pay_mx_utility.get_legi_param_val('END_DATE',
694: ppa_mag.legislative_parameters))
695: -- Bug 5998981
696: AND DECODE (pai.action_information_category,
697: 'MX SS TRANSACTIONS',

Line 701: pay_mx_utility.get_legi_param_val('START_DATE',

697: 'MX SS TRANSACTIONS',
698: TRUNC(fnd_date.canonical_to_date(pai.action_information2)),
699: hr_general.start_of_time)
700: BETWEEN TRUNC(fnd_date.canonical_to_date(
701: pay_mx_utility.get_legi_param_val('START_DATE',
702: ppa_mag.legislative_parameters)))
703: AND TRUNC (fnd_date.canonical_to_date(
704: pay_mx_utility.get_legi_param_val('END_DATE',
705: ppa_mag.legislative_parameters)))

Line 704: pay_mx_utility.get_legi_param_val('END_DATE',

700: BETWEEN TRUNC(fnd_date.canonical_to_date(
701: pay_mx_utility.get_legi_param_val('START_DATE',
702: ppa_mag.legislative_parameters)))
703: AND TRUNC (fnd_date.canonical_to_date(
704: pay_mx_utility.get_legi_param_val('END_DATE',
705: ppa_mag.legislative_parameters)))
706: ORDER BY fnd_date.canonical_to_date (pai.action_information2) DESC;
707:
708: l_proc_name VARCHAR2(100);

Line 855: pay_mx_utility.get_legi_param_val('END_DATE',

851: FROM dual
852: UNION
853: SELECT paa.assignment_action_id,
854: fnd_date.canonical_to_date(
855: pay_mx_utility.get_legi_param_val('END_DATE',
856: ppa.legislative_parameters))
857: FROM pay_payroll_actions ppa,
858: pay_assignment_actions paa,
859: pay_action_information pai,

Line 870: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',

866: AND ppa.report_type = 'MX_SS_AFFL'
867: AND ppa.report_qualifier = 'MX_SS_AFFL'
868: AND ppa.report_category = 'RT'
869: AND ppa.action_status = 'C'
870: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
871: ppa.legislative_parameters) =
872: g_trans_gre_id
873: AND fnd_date.canonical_to_date(
874: pay_mx_utility.get_legi_param_val('END_DATE',

Line 874: pay_mx_utility.get_legi_param_val('END_DATE',

870: AND pay_mx_utility.get_legi_param_val('TRANS_GRE',
871: ppa.legislative_parameters) =
872: g_trans_gre_id
873: AND fnd_date.canonical_to_date(
874: pay_mx_utility.get_legi_param_val('END_DATE',
875: ppa.legislative_parameters)) <
876: fnd_date.canonical_to_date (g_end_date)
877: ORDER BY 2 DESC;*/
878:

Line 1043: ld_imp_date := pay_mx_utility.get_default_imp_date;

1039: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);
1040: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1041:
1042: IF ld_imp_date IS NULL THEN
1043: ld_imp_date := pay_mx_utility.get_default_imp_date;
1044: END IF;
1045: hr_utility_trace ('Actual Implementation Date is : '|| ld_imp_date);
1046:
1047: OPEN csr_person (ln_assignment_action_id);