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

Line 273: gd_start_date := fnd_date.canonical_to_date(ld_rpt_start_dt);

269: CLOSE c_ass_set_name;
270: END IF;
271: -- Set the global variable for cp parameters value
272: gv_ass_set_id := lv_assignment_set;
273: gd_start_date := fnd_date.canonical_to_date(ld_rpt_start_dt);
274: gd_end_date := fnd_date.canonical_to_date(ld_rpt_end_dt);
275: gv_rpting_year := lv_rpting_year;
276: hr_utility_trace ('gd_start_date = '|| gd_start_date);
277: hr_utility_trace ('gd_end_date = '|| gd_end_date);

Line 274: gd_end_date := fnd_date.canonical_to_date(ld_rpt_end_dt);

270: END IF;
271: -- Set the global variable for cp parameters value
272: gv_ass_set_id := lv_assignment_set;
273: gd_start_date := fnd_date.canonical_to_date(ld_rpt_start_dt);
274: gd_end_date := fnd_date.canonical_to_date(ld_rpt_end_dt);
275: gv_rpting_year := lv_rpting_year;
276: hr_utility_trace ('gd_start_date = '|| gd_start_date);
277: hr_utility_trace ('gd_end_date = '|| gd_end_date);
278: p_end_date := TRUNC(ld_end_date,'Y');

Line 340: fnd_date.canonical_to_date('''||

336: AND ppa_arch.report_category = ''ARCHIVE''
337: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
338: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
339: AND TRUNC(ppa_arch.effective_date,''Y'') =
340: fnd_date.canonical_to_date('''||
341: fnd_date.date_to_canonical(gd_effective_date)||''')
342: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
343: AND paa_arch.action_status = ''C''
344: AND :p_payroll_action_id = '||p_payroll_action_id||'

Line 341: fnd_date.date_to_canonical(gd_effective_date)||''')

337: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
338: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
339: AND TRUNC(ppa_arch.effective_date,''Y'') =
340: fnd_date.canonical_to_date('''||
341: fnd_date.date_to_canonical(gd_effective_date)||''')
342: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
343: AND paa_arch.action_status = ''C''
344: AND :p_payroll_action_id = '||p_payroll_action_id||'
345: ORDER BY serial_number';