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

Line 241: -- For R11.5, the FND date format is 'YYYY/MM/DD HH24:MI:SS'.

237: -- 1) Convert format
238: -- 2) Remove time component
239: IF p_date_from is NOT NULL
240: THEN
241: -- For R11.5, the FND date format is 'YYYY/MM/DD HH24:MI:SS'.
242: l_date_from := to_date(p_date_from, fnd_date.canonical_dt_mask);
243: l_date_from := trunc(l_date_from);
244: ELSE
245: l_date_from := trunc(sysdate);

Line 242: l_date_from := to_date(p_date_from, fnd_date.canonical_dt_mask);

238: -- 2) Remove time component
239: IF p_date_from is NOT NULL
240: THEN
241: -- For R11.5, the FND date format is 'YYYY/MM/DD HH24:MI:SS'.
242: l_date_from := to_date(p_date_from, fnd_date.canonical_dt_mask);
243: l_date_from := trunc(l_date_from);
244: ELSE
245: l_date_from := trunc(sysdate);
246: END IF;

Line 250: l_date_to := to_date(p_date_to, fnd_date.canonical_dt_mask);

246: END IF;
247: --
248: IF p_date_to is NOT NULL
249: THEN
250: l_date_to := to_date(p_date_to, fnd_date.canonical_dt_mask);
251: l_date_to := trunc(l_date_to);
252: ELSE
253: -- Default date_to to end of time so that we can allow future date
254: -- execution. For example, date_from is a future date with respective to

Line 269: l_date_from_char := to_char(l_date_from, fnd_date.canonical_mask);

265: END IF;
266: --
267: -- Now, convert the date to varchar2 format for use in dynamic sql statement.
268: -- In R11.5, use the FND standard date format, which is 'YYYY/MM/DD'
269: l_date_from_char := to_char(l_date_from, fnd_date.canonical_mask);
270: l_date_to_char := to_char(l_date_to, fnd_date.canonical_mask);
271: --
272: -------------------------------------------------------------------------------
273: -- NOTE: If users enter Organization Hierarchy and Version, then the

Line 270: l_date_to_char := to_char(l_date_to, fnd_date.canonical_mask);

266: --
267: -- Now, convert the date to varchar2 format for use in dynamic sql statement.
268: -- In R11.5, use the FND standard date format, which is 'YYYY/MM/DD'
269: l_date_from_char := to_char(l_date_from, fnd_date.canonical_mask);
270: l_date_to_char := to_char(l_date_to, fnd_date.canonical_mask);
271: --
272: -------------------------------------------------------------------------------
273: -- NOTE: If users enter Organization Hierarchy and Version, then the
274: -- p_single_org_id is ignored. Organization Hierarchy and Single Org

Line 357: ''', ''' || fnd_date.canonical_mask || ''')' ||

353: -- between the p_date_from and p_date_to dates
354: l_new_hires_matching :=
355: ' AND (ppf.effective_start_date >= to_date(''' ||
356: l_date_from_char ||
357: ''', ''' || fnd_date.canonical_mask || ''')' ||
358: ' and ppf.effective_start_date <= to_date(''' ||
359: l_date_to_char ||
360: ''', ''' || fnd_date.canonical_mask || ''')' ||
361: ' and ppf.effective_end_date >= to_date(''' ||

Line 360: ''', ''' || fnd_date.canonical_mask || ''')' ||

356: l_date_from_char ||
357: ''', ''' || fnd_date.canonical_mask || ''')' ||
358: ' and ppf.effective_start_date <= to_date(''' ||
359: l_date_to_char ||
360: ''', ''' || fnd_date.canonical_mask || ''')' ||
361: ' and ppf.effective_end_date >= to_date(''' ||
362: l_date_to_char ||
363: ''', ''' || fnd_date.canonical_mask || '''))' ||
364: ' AND (paf.effective_start_date >= to_date(''' ||

Line 363: ''', ''' || fnd_date.canonical_mask || '''))' ||

359: l_date_to_char ||
360: ''', ''' || fnd_date.canonical_mask || ''')' ||
361: ' and ppf.effective_end_date >= to_date(''' ||
362: l_date_to_char ||
363: ''', ''' || fnd_date.canonical_mask || '''))' ||
364: ' AND (paf.effective_start_date >= to_date(''' ||
365: l_date_from_char ||
366: ''', ''' || fnd_date.canonical_mask || ''')' ||
367: ' AND paf.effective_start_date <= to_date(''' ||

Line 366: ''', ''' || fnd_date.canonical_mask || ''')' ||

362: l_date_to_char ||
363: ''', ''' || fnd_date.canonical_mask || '''))' ||
364: ' AND (paf.effective_start_date >= to_date(''' ||
365: l_date_from_char ||
366: ''', ''' || fnd_date.canonical_mask || ''')' ||
367: ' AND paf.effective_start_date <= to_date(''' ||
368: l_date_to_char ||
369: ''', ''' || fnd_date.canonical_mask || ''')' ||
370: ' and paf.effective_end_date >= to_date(''' ||

Line 369: ''', ''' || fnd_date.canonical_mask || ''')' ||

365: l_date_from_char ||
366: ''', ''' || fnd_date.canonical_mask || ''')' ||
367: ' AND paf.effective_start_date <= to_date(''' ||
368: l_date_to_char ||
369: ''', ''' || fnd_date.canonical_mask || ''')' ||
370: ' and paf.effective_end_date >= to_date(''' ||
371: l_date_to_char ||
372: ''', ''' || fnd_date.canonical_mask || '''))' ||
373: ' AND ((ppos.date_start >= to_date(''' ||

Line 372: ''', ''' || fnd_date.canonical_mask || '''))' ||

368: l_date_to_char ||
369: ''', ''' || fnd_date.canonical_mask || ''')' ||
370: ' and paf.effective_end_date >= to_date(''' ||
371: l_date_to_char ||
372: ''', ''' || fnd_date.canonical_mask || '''))' ||
373: ' AND ((ppos.date_start >= to_date(''' ||
374: l_date_from_char || ''', ''' ||
375: fnd_date.canonical_mask || ''')' ||
376: ' AND ppos.date_start <= to_date(''' ||

Line 375: fnd_date.canonical_mask || ''')' ||

371: l_date_to_char ||
372: ''', ''' || fnd_date.canonical_mask || '''))' ||
373: ' AND ((ppos.date_start >= to_date(''' ||
374: l_date_from_char || ''', ''' ||
375: fnd_date.canonical_mask || ''')' ||
376: ' AND ppos.date_start <= to_date(''' ||
377: l_date_to_char || ''', ''' ||
378: fnd_date.canonical_mask || '''))' ||
379: --

Line 378: fnd_date.canonical_mask || '''))' ||

374: l_date_from_char || ''', ''' ||
375: fnd_date.canonical_mask || ''')' ||
376: ' AND ppos.date_start <= to_date(''' ||
377: l_date_to_char || ''', ''' ||
378: fnd_date.canonical_mask || '''))' ||
379: --
380: -- ---------------------------------------------------------------------------
381: -- The following is commented out. If we need to change the termination_date
382: -- comparison, we can re-evaluate the comparsion.

Line 385: fnd_date.canonical_mask || '''))' ||

381: -- The following is commented out. If we need to change the termination_date
382: -- comparison, we can re-evaluate the comparsion.
383: ' AND nvl(ppos.actual_termination_date, to_date(''' ||
384: l_date_to_char || ''', ''' ||
385: fnd_date.canonical_mask || '''))' ||
386: ' <= to_date(''' || l_date_to_char ||
387: ''', ''' || fnd_date.canonical_mask || '''))' ||
388: -- ---------------------------------------------------------------------------
389: --

Line 387: ''', ''' || fnd_date.canonical_mask || '''))' ||

383: ' AND nvl(ppos.actual_termination_date, to_date(''' ||
384: l_date_to_char || ''', ''' ||
385: fnd_date.canonical_mask || '''))' ||
386: ' <= to_date(''' || l_date_to_char ||
387: ''', ''' || fnd_date.canonical_mask || '''))' ||
388: -- ---------------------------------------------------------------------------
389: --
390: -- ' AND ppos.actual_termination_date IS NULL)' ||
391: ' AND ppos.person_id = ppf.person_id ' ||

Line 458: ''', ''' || fnd_date.canonical_mask || ''')' ||

454: l_all_ee_matching :=
455: ' AND ppf.person_type_id in (' || l_per_type_id_list || ')' ||
456: ' AND (ppf.effective_start_date <= to_date(''' ||
457: l_date_to_char ||
458: ''', ''' || fnd_date.canonical_mask || ''')' ||
459: ' and ppf.effective_end_date >= to_date(''' ||
460: l_date_to_char ||
461: ''', ''' || fnd_date.canonical_mask || '''))' ||
462: ' AND (paf.effective_start_date <= to_date(''' ||

Line 461: ''', ''' || fnd_date.canonical_mask || '''))' ||

457: l_date_to_char ||
458: ''', ''' || fnd_date.canonical_mask || ''')' ||
459: ' and ppf.effective_end_date >= to_date(''' ||
460: l_date_to_char ||
461: ''', ''' || fnd_date.canonical_mask || '''))' ||
462: ' AND (paf.effective_start_date <= to_date(''' ||
463: l_date_to_char ||
464: ''', ''' || fnd_date.canonical_mask || ''')' ||
465: ' and paf.effective_end_date >= to_date(''' ||

Line 464: ''', ''' || fnd_date.canonical_mask || ''')' ||

460: l_date_to_char ||
461: ''', ''' || fnd_date.canonical_mask || '''))' ||
462: ' AND (paf.effective_start_date <= to_date(''' ||
463: l_date_to_char ||
464: ''', ''' || fnd_date.canonical_mask || ''')' ||
465: ' and paf.effective_end_date >= to_date(''' ||
466: l_date_to_char ||
467: ''', ''' || fnd_date.canonical_mask || '''))' ||
468: ' AND (ppos.date_start <= to_date(''' ||

Line 467: ''', ''' || fnd_date.canonical_mask || '''))' ||

463: l_date_to_char ||
464: ''', ''' || fnd_date.canonical_mask || ''')' ||
465: ' and paf.effective_end_date >= to_date(''' ||
466: l_date_to_char ||
467: ''', ''' || fnd_date.canonical_mask || '''))' ||
468: ' AND (ppos.date_start <= to_date(''' ||
469: l_date_to_char || ''', ''' || fnd_date.canonical_mask || ''')' ||
470: ' AND nvl(ppos.actual_termination_date, to_date(''' ||
471: l_date_to_char || ''', ''' || fnd_date.canonical_mask || '''))' ||

Line 469: l_date_to_char || ''', ''' || fnd_date.canonical_mask || ''')' ||

465: ' and paf.effective_end_date >= to_date(''' ||
466: l_date_to_char ||
467: ''', ''' || fnd_date.canonical_mask || '''))' ||
468: ' AND (ppos.date_start <= to_date(''' ||
469: l_date_to_char || ''', ''' || fnd_date.canonical_mask || ''')' ||
470: ' AND nvl(ppos.actual_termination_date, to_date(''' ||
471: l_date_to_char || ''', ''' || fnd_date.canonical_mask || '''))' ||
472: ' >= to_date(''' || l_date_to_char ||
473: ''', ''' || fnd_date.canonical_mask || '''))' ||

Line 471: l_date_to_char || ''', ''' || fnd_date.canonical_mask || '''))' ||

467: ''', ''' || fnd_date.canonical_mask || '''))' ||
468: ' AND (ppos.date_start <= to_date(''' ||
469: l_date_to_char || ''', ''' || fnd_date.canonical_mask || ''')' ||
470: ' AND nvl(ppos.actual_termination_date, to_date(''' ||
471: l_date_to_char || ''', ''' || fnd_date.canonical_mask || '''))' ||
472: ' >= to_date(''' || l_date_to_char ||
473: ''', ''' || fnd_date.canonical_mask || '''))' ||
474: ' AND ppos.person_id = ppf.person_id ' ||
475: ' and paf.period_of_service_id = ppos.period_of_service_id ' ||

Line 473: ''', ''' || fnd_date.canonical_mask || '''))' ||

469: l_date_to_char || ''', ''' || fnd_date.canonical_mask || ''')' ||
470: ' AND nvl(ppos.actual_termination_date, to_date(''' ||
471: l_date_to_char || ''', ''' || fnd_date.canonical_mask || '''))' ||
472: ' >= to_date(''' || l_date_to_char ||
473: ''', ''' || fnd_date.canonical_mask || '''))' ||
474: ' AND ppos.person_id = ppf.person_id ' ||
475: ' and paf.period_of_service_id = ppos.period_of_service_id ' ||
476: ' AND ppos.business_group_id + 0 = ' || to_char(p_business_group_id);
477: --

Line 598: l_date_from_char || ''', ''' || fnd_date.canonical_mask

594: AND paf.person_id = ppos.person_id
595: AND ppf.business_group_id + 0 = ' ||
596: to_char(p_business_group_id) ||
597: ' AND ppf.effective_end_date BETWEEN to_date(''' ||
598: l_date_from_char || ''', ''' || fnd_date.canonical_mask
599: || ''')'||
600: ' AND to_date(''' ||
601: l_date_to_char || ''', ''' || fnd_date.canonical_mask
602: || ''')' ||

Line 601: l_date_to_char || ''', ''' || fnd_date.canonical_mask

597: ' AND ppf.effective_end_date BETWEEN to_date(''' ||
598: l_date_from_char || ''', ''' || fnd_date.canonical_mask
599: || ''')'||
600: ' AND to_date(''' ||
601: l_date_to_char || ''', ''' || fnd_date.canonical_mask
602: || ''')' ||
603: ' AND paf.primary_flag = ''Y''';
604:
605: --

Line 633: l_date_from_char || ''', ''' || fnd_date.canonical_mask

629: ' where b.person_id=ppf.person_id '||
630: ' and business_group_id + 0 = ' || to_char(p_business_group_id) ||
631: ' and ppos.person_id= paf.person_id '||
632: ' and b.actual_termination_date BETWEEN to_date(''' ||
633: l_date_from_char || ''', ''' || fnd_date.canonical_mask
634: || ''')'||
635: ' AND to_date(''' ||
636: l_date_to_char || ''', ''' || fnd_date.canonical_mask
637: || ''')' ||

Line 636: l_date_to_char || ''', ''' || fnd_date.canonical_mask

632: ' and b.actual_termination_date BETWEEN to_date(''' ||
633: l_date_from_char || ''', ''' || fnd_date.canonical_mask
634: || ''')'||
635: ' AND to_date(''' ||
636: l_date_to_char || ''', ''' || fnd_date.canonical_mask
637: || ''')' ||
638: ' ) AND ppf.person_id not in( '||
639: ' select a.person_id from per_all_people_f a,'||
640: ' per_periods_of_service b'||