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_ANNUAL_WRI dependencies on FND_DATE

Line 118: fnd_date.date_to_canonical (start_date),

114: ) IS
115: CURSOR csr_get_mag_pact_info IS
116: SELECT pay_mx_utility.get_legi_param_val('GRE',
117: ppa_mag.legislative_parameters),
118: fnd_date.date_to_canonical (start_date),
119: fnd_date.date_to_canonical (effective_date)
120: FROM pay_payroll_actions ppa_mag
121: WHERE ppa_mag.payroll_action_id = p_payroll_action_id;
122:

Line 119: fnd_date.date_to_canonical (effective_date)

115: CURSOR csr_get_mag_pact_info IS
116: SELECT pay_mx_utility.get_legi_param_val('GRE',
117: ppa_mag.legislative_parameters),
118: fnd_date.date_to_canonical (start_date),
119: fnd_date.date_to_canonical (effective_date)
120: FROM pay_payroll_actions ppa_mag
121: WHERE ppa_mag.payroll_action_id = p_payroll_action_id;
122:
123: l_proc_name varchar2(100);

Line 168: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val

164: pay_payroll_actions ppa_sua,
165: pay_assignment_actions paa_sua
166: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
167: AND paa_sua.assignment_id = paf.assignment_id
168: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
169: (''END_DATE'',
170: ppa_sua.legislative_parameters))
171: BETWEEN paf.effective_start_date
172: AND paf.effective_end_date

Line 173: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val

169: (''END_DATE'',
170: ppa_sua.legislative_parameters))
171: BETWEEN paf.effective_start_date
172: AND paf.effective_end_date
173: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
174: (''END_DATE'',
175: ppa_sua.legislative_parameters))
176: BETWEEN fnd_date.canonical_to_date (''' || g_start_date ||
177: ''') AND fnd_date.canonical_to_date (''' || g_end_date ||

Line 176: BETWEEN fnd_date.canonical_to_date (''' || g_start_date ||

172: AND paf.effective_end_date
173: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
174: (''END_DATE'',
175: ppa_sua.legislative_parameters))
176: BETWEEN fnd_date.canonical_to_date (''' || g_start_date ||
177: ''') AND fnd_date.canonical_to_date (''' || g_end_date ||
178: ''') AND pay_mx_utility.get_legi_param_val (''GRE'',
179: ppa_sua.legislative_parameters) = '||
180: g_gre_id ||

Line 177: ''') AND fnd_date.canonical_to_date (''' || g_end_date ||

173: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
174: (''END_DATE'',
175: ppa_sua.legislative_parameters))
176: BETWEEN fnd_date.canonical_to_date (''' || g_start_date ||
177: ''') AND fnd_date.canonical_to_date (''' || g_end_date ||
178: ''') AND pay_mx_utility.get_legi_param_val (''GRE'',
179: ppa_sua.legislative_parameters) = '||
180: g_gre_id ||
181: ' AND ppa_sua.report_type = ''SUA_MAG''

Line 224: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val

220: AND pai.action_information_category = 'MX SS TRANSACTIONS'
221: AND pai.action_information4 = '12'
222: AND pai.action_information23 IS NOT NULL -- Absence end date
223: AND pai.action_information20 IN ('1', '3')--Type of risk(Bug 5688450)
224: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
225: ('END_DATE',
226: ppa_sua.legislative_parameters))
227: BETWEEN paf.effective_start_date
228: AND paf.effective_end_date

Line 229: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val

225: ('END_DATE',
226: ppa_sua.legislative_parameters))
227: BETWEEN paf.effective_start_date
228: AND paf.effective_end_date
229: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
230: ('END_DATE',
231: ppa_sua.legislative_parameters))
232: BETWEEN fnd_date.canonical_to_date (g_start_date)
233: AND fnd_date.canonical_to_date (g_end_date)

Line 232: BETWEEN fnd_date.canonical_to_date (g_start_date)

228: AND paf.effective_end_date
229: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
230: ('END_DATE',
231: ppa_sua.legislative_parameters))
232: BETWEEN fnd_date.canonical_to_date (g_start_date)
233: AND fnd_date.canonical_to_date (g_end_date)
234: AND pay_mx_utility.get_legi_param_val ('GRE',
235: ppa_sua.legislative_parameters) =
236: g_gre_id

Line 233: AND fnd_date.canonical_to_date (g_end_date)

229: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
230: ('END_DATE',
231: ppa_sua.legislative_parameters))
232: BETWEEN fnd_date.canonical_to_date (g_start_date)
233: AND fnd_date.canonical_to_date (g_end_date)
234: AND pay_mx_utility.get_legi_param_val ('GRE',
235: ppa_sua.legislative_parameters) =
236: g_gre_id
237: AND paf.person_id BETWEEN p_start_person_id

Line 268: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val

264: AND pai.action_information_category = 'MX SS TRANSACTIONS'
265: AND pai.action_information4 = '12'
266: AND pai.action_information23 IS NOT NULL -- Absence end date
267: AND pai.action_information20 IN ('1', '3')--Type of risk(Bug 5688450)
268: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
269: ('END_DATE',
270: ppa_sua.legislative_parameters))
271: BETWEEN paf.effective_start_date
272: AND paf.effective_end_date

Line 273: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val

269: ('END_DATE',
270: ppa_sua.legislative_parameters))
271: BETWEEN paf.effective_start_date
272: AND paf.effective_end_date
273: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
274: ('END_DATE',
275: ppa_sua.legislative_parameters))
276: BETWEEN fnd_date.canonical_to_date (g_start_date)
277: AND fnd_date.canonical_to_date (g_end_date)

Line 276: BETWEEN fnd_date.canonical_to_date (g_start_date)

272: AND paf.effective_end_date
273: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
274: ('END_DATE',
275: ppa_sua.legislative_parameters))
276: BETWEEN fnd_date.canonical_to_date (g_start_date)
277: AND fnd_date.canonical_to_date (g_end_date)
278: AND pay_mx_utility.get_legi_param_val ('GRE',
279: ppa_sua.legislative_parameters) =
280: g_gre_id

Line 277: AND fnd_date.canonical_to_date (g_end_date)

273: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
274: ('END_DATE',
275: ppa_sua.legislative_parameters))
276: BETWEEN fnd_date.canonical_to_date (g_start_date)
277: AND fnd_date.canonical_to_date (g_end_date)
278: AND pay_mx_utility.get_legi_param_val ('GRE',
279: ppa_sua.legislative_parameters) =
280: g_gre_id
281: AND ppr.payroll_action_id = p_payroll_action_id

Line 453: AND fnd_date.canonical_to_date(

449: WHERE paa.payroll_action_id = ppa.payroll_action_id
450: AND fnd_number.canonical_to_number(
451: pay_mx_utility.get_legi_param_val('GRE',
452: ppa.legislative_parameters)) = g_gre_id
453: AND fnd_date.canonical_to_date(
454: pay_mx_utility.get_legi_param_val('END_DATE',
455: ppa.legislative_parameters)) <=
456: fnd_date.canonical_to_date(g_end_date)
457: AND paa.assignment_action_id = lck.locking_action_id

Line 456: fnd_date.canonical_to_date(g_end_date)

452: ppa.legislative_parameters)) = g_gre_id
453: AND fnd_date.canonical_to_date(
454: pay_mx_utility.get_legi_param_val('END_DATE',
455: ppa.legislative_parameters)) <=
456: fnd_date.canonical_to_date(g_end_date)
457: AND paa.assignment_action_id = lck.locking_action_id
458: AND lck.locked_action_id = paa_arch.assignment_action_id
459: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
460: AND pai.action_context_id = paa_arch.assignment_action_id

Line 474: ORDER BY fnd_date.canonical_to_date(

470: AND ppa_arch.report_type = 'SS_ARCHIVE'
471: AND ppa_arch.report_qualifier = 'SS_ARCHIVE'
472: AND ppa_arch.report_category = 'RT'
473: AND ppa_arch.action_status = 'C'
474: ORDER BY fnd_date.canonical_to_date(
475: pay_mx_utility.get_legi_param_val('END_DATE',
476: ppa.legislative_parameters)) DESC;
477: /*SELECT pai.action_information_id
478: FROM pay_action_information pai,

Line 490: ORDER BY fnd_date.canonical_to_date (

486: AND pai.action_information_category = 'MX SS PERSON INFORMATION'
487: AND nvl(pai.action_information21, 'N') = 'N' -- Do not report flag
488: AND pai.action_context_id = paa_arch.assignment_action_id
489: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
490: ORDER BY fnd_date.canonical_to_date (
491: pay_mx_utility.get_legi_param_val('END_DATE',
492: ppa_arch.legislative_parameters)) DESC;*/
493:
494: