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.PER_MX_SSAFFL_ARCHIVE dependencies on FND_DATE

Line 170: select fnd_date.canonical_to_date(legislation_info1)

166: IS
167:
168: cursor c_get_def_imp_date
169: is
170: select fnd_date.canonical_to_date(legislation_info1)
171: from pay_mx_legislation_info_f
172: where legislation_info_type='MX Social Security Reporting' ;
173:
174: ld_def_date date ;

Line 182: return fnd_date.date_to_canonical(ld_def_date) ;

178: open c_get_def_imp_date ;
179: fetch c_get_def_imp_date into ld_def_date ;
180: close c_get_def_imp_date;
181:
182: return fnd_date.date_to_canonical(ld_def_date) ;
183:
184: end get_default_imp_date;
185:
186:

Line 209: select fnd_date.canonical_to_date(ltrim(rtrim(substr(ppa.legislative_parameters,

205: IS
206:
207: cursor c_get_start_date(cp_tax_unit_id in number)
208: is
209: select fnd_date.canonical_to_date(ltrim(rtrim(substr(ppa.legislative_parameters,
210: instr(ppa.legislative_parameters,
211: 'END_DATE=')
212: + length('END_DATE='),
213: (instr(ppa.legislative_parameters,

Line 229: select fnd_date.canonical_to_date(org_information6)

225:
226:
227: cursor c_get_imp_date(cp_organization_id in number)
228: is
229: select fnd_date.canonical_to_date(org_information6)
230: from hr_organization_information
231: where org_information_context= 'MX_TAX_REGISTRATION'
232: and organization_id = cp_organization_id ;
233:

Line 246: ld_report_imp_date := fnd_date.canonical_to_date(get_default_imp_date) ;

242: open c_get_imp_date(to_number(p_legal_emp_id)) ;
243: fetch c_get_imp_date into ld_report_imp_date ;
244: if c_get_imp_date%notfound then
245: -- defaulting to Report Implementation Date from mx pay legislation info table
246: ld_report_imp_date := fnd_date.canonical_to_date(get_default_imp_date) ;
247: end if;
248: close c_get_imp_date;
249:
250: if p_gre_id is not null then

Line 264: lv_start_date := fnd_date.date_to_canonical(ld_start_date) ;

260: ld_start_date := ld_report_imp_date ;
261: end if;
262: close c_get_start_date;
263:
264: lv_start_date := fnd_date.date_to_canonical(ld_start_date) ;
265:
266: return lv_start_date ;
267:
268: end get_start_date;

Line 320: fnd_date.canonical_to_date(ltrim(rtrim(substr(legislative_parameters,

316: - (instr(legislative_parameters,
317: 'LEGAL_EMPLOYER=')
318: + length('LEGAL_EMPLOYER=')))))) , -- legal_employer
319:
320: fnd_date.canonical_to_date(ltrim(rtrim(substr(legislative_parameters,
321: instr(legislative_parameters,
322: 'END_DATE=')
323: + length('END_DATE='),
324: (instr(legislative_parameters,

Line 330: fnd_date.canonical_to_date(ltrim(rtrim(substr(legislative_parameters,

326: - (instr(legislative_parameters,
327: 'END_DATE=')
328: + length('END_DATE=')))))), -- end_date
329:
330: fnd_date.canonical_to_date(ltrim(rtrim(substr(legislative_parameters,
331: instr(legislative_parameters,
332: 'START_DATE=')
333: + length('START_DATE='),
334: (instr(legislative_parameters,

Line 344: select fnd_date.canonical_to_date(org_information6)

340: where payroll_action_id = cp_payroll_action_id;
341:
342: cursor c_get_imp_date(cp_organization_id in number)
343: is
344: select fnd_date.canonical_to_date(org_information6)
345: from hr_organization_information
346: where org_information_context= 'MX_TAX_REGISTRATION'
347: and organization_id = cp_organization_id ;
348:

Line 401: ld_report_imp_date := fnd_date.canonical_to_date(get_default_imp_date) ;

397: fetch c_get_imp_date into ld_report_imp_date ;
398: if c_get_imp_date%notfound then
399: dbg('WARNING : Report Implementaton date is not entered for legal employer ' );
400: dbg('so defaulting to Report Implementation Date from pay mx legislation info table');
401: ld_report_imp_date := fnd_date.canonical_to_date(get_default_imp_date) ;
402: end if;
403: close c_get_imp_date;
404: dbg('report impl date is '||to_char(ld_report_imp_date) );
405: g_report_imp_date := ld_report_imp_date;

Line 423: dbg('start date : ' || fnd_date.date_to_canonical(p_start_date)) ;

419: p_gre_id := ln_gre_id;
420: p_event_group_id := ln_event_group_id ;
421:
422: dbg('Parameters.....');
423: dbg('start date : ' || fnd_date.date_to_canonical(p_start_date)) ;
424: dbg('end date : ' || fnd_date.date_to_canonical(p_end_date)) ;
425: dbg('bus group id : ' || to_char(p_business_group_id)) ;
426: dbg('trans gre id : ' || to_char(p_tran_gre_id)) ;
427: dbg('gre id : ' || to_char(p_gre_id)) ;

Line 424: dbg('end date : ' || fnd_date.date_to_canonical(p_end_date)) ;

420: p_event_group_id := ln_event_group_id ;
421:
422: dbg('Parameters.....');
423: dbg('start date : ' || fnd_date.date_to_canonical(p_start_date)) ;
424: dbg('end date : ' || fnd_date.date_to_canonical(p_end_date)) ;
425: dbg('bus group id : ' || to_char(p_business_group_id)) ;
426: dbg('trans gre id : ' || to_char(p_tran_gre_id)) ;
427: dbg('gre id : ' || to_char(p_gre_id)) ;
428: dbg('event group id : ' || to_char(p_event_group_id) );

Line 535: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')

531: from pay_process_events ppe,
532: pay_event_updates peu,
533: pay_datetracked_events pde
534: where ppe.creation_date between
535: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')
536: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')
537: and ppe.event_update_id = peu.event_update_id
538: and peu.dated_table_id = pde.dated_table_id
539: and pde.event_group_id = ''' ||ln_event_group_id || '''

Line 536: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')

532: pay_event_updates peu,
533: pay_datetracked_events pde
534: where ppe.creation_date between
535: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')
536: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')
537: and ppe.event_update_id = peu.event_update_id
538: and peu.dated_table_id = pde.dated_table_id
539: and pde.event_group_id = ''' ||ln_event_group_id || '''
540: and ppe.business_group_id = ''' ||ln_business_group_id || '''

Line 710: dbg('start date is : ' || fnd_date.date_to_canonical(ld_start_date)) ;

706: dbg('tansmitter gre id : ' || to_char(ln_tran_gre_id));
707: dbg('gre id : ' || to_char(ln_gre_id));
708: dbg('event group id : ' || to_char(ln_event_group_id));
709: dbg('business_group_id : ' || to_char(ln_business_group_id));
710: dbg('start date is : ' || fnd_date.date_to_canonical(ld_start_date)) ;
711: dbg('end date is : ' || fnd_date.date_to_canonical(ld_end_date)) ;
712:
713: open c_get_asg( p_start_assignment_id
714: ,p_end_assignment_id

Line 711: dbg('end date is : ' || fnd_date.date_to_canonical(ld_end_date)) ;

707: dbg('gre id : ' || to_char(ln_gre_id));
708: dbg('event group id : ' || to_char(ln_event_group_id));
709: dbg('business_group_id : ' || to_char(ln_business_group_id));
710: dbg('start date is : ' || fnd_date.date_to_canonical(ld_start_date)) ;
711: dbg('end date is : ' || fnd_date.date_to_canonical(ld_end_date)) ;
712:
713: open c_get_asg( p_start_assignment_id
714: ,p_end_assignment_id
715: ,ln_tran_gre_id

Line 945: and fnd_date.canonical_to_date(aei_information1) = cp_effective_date

941: select aei_information3
942: from per_assignment_extra_info pae
943: where pae.assignment_id = cp_assignment_id
944: and information_type = 'MX_SS_EMP_TRANS_REASON'
945: and fnd_date.canonical_to_date(aei_information1) = cp_effective_date
946: and aei_information2 = cp_gre_id ;
947:
948: cursor c_get_pos_leaving_reason(cp_assignment_id in number
949: ,cp_effective_date in date )