APPS.PAY_US_EMP_BALADJ_CLEANUP dependencies on FND_DATE

Line 657: lv_date := fnd_date.date_to_canonical(

653: if lv_payroll_id is null then
654: lv_payroll_id := '%';
655: end if;
656:
657: lv_date := fnd_date.date_to_canonical(
658: greatest(ld_start_date,
659: fnd_date.canonical_to_date('2004/01/01 00:00:00')));
660:
661:

Line 659: fnd_date.canonical_to_date('2004/01/01 00:00:00')));

655: end if;
656:
657: lv_date := fnd_date.date_to_canonical(
658: greatest(ld_start_date,
659: fnd_date.canonical_to_date('2004/01/01 00:00:00')));
660:
661:
662: insert into pay_action_information
663: (ACTION_INFORMATION_ID,

Line 686: between fnd_date.canonical_to_date(''' ||

682: and paf.assignment_id = paa.assignment_id
683: and ppa.effective_date between paf.effective_start_date
684: and paf.effective_end_date
685: and ppa.effective_date
686: between fnd_date.canonical_to_date(''' ||
687: fnd_date.date_to_canonical(ld_start_date-10) || ''')
688: and fnd_date.canonical_to_date(''' ||
689: fnd_date.date_to_canonical(ld_end_date+30) || ''')
690: and ppa.action_type in (''R'',''Q'')

Line 687: fnd_date.date_to_canonical(ld_start_date-10) || ''')

683: and ppa.effective_date between paf.effective_start_date
684: and paf.effective_end_date
685: and ppa.effective_date
686: between fnd_date.canonical_to_date(''' ||
687: fnd_date.date_to_canonical(ld_start_date-10) || ''')
688: and fnd_date.canonical_to_date(''' ||
689: fnd_date.date_to_canonical(ld_end_date+30) || ''')
690: and ppa.action_type in (''R'',''Q'')
691: and ppa.last_update_date >= fnd_date.canonical_to_date(''' ||

Line 688: and fnd_date.canonical_to_date(''' ||

684: and paf.effective_end_date
685: and ppa.effective_date
686: between fnd_date.canonical_to_date(''' ||
687: fnd_date.date_to_canonical(ld_start_date-10) || ''')
688: and fnd_date.canonical_to_date(''' ||
689: fnd_date.date_to_canonical(ld_end_date+30) || ''')
690: and ppa.action_type in (''R'',''Q'')
691: and ppa.last_update_date >= fnd_date.canonical_to_date(''' ||
692: lv_date || ''')

Line 689: fnd_date.date_to_canonical(ld_end_date+30) || ''')

685: and ppa.effective_date
686: between fnd_date.canonical_to_date(''' ||
687: fnd_date.date_to_canonical(ld_start_date-10) || ''')
688: and fnd_date.canonical_to_date(''' ||
689: fnd_date.date_to_canonical(ld_end_date+30) || ''')
690: and ppa.action_type in (''R'',''Q'')
691: and ppa.last_update_date >= fnd_date.canonical_to_date(''' ||
692: lv_date || ''')
693: and ppa.consolidation_set_id like ''' || lv_cons_set_id || '''

Line 691: and ppa.last_update_date >= fnd_date.canonical_to_date(''' ||

687: fnd_date.date_to_canonical(ld_start_date-10) || ''')
688: and fnd_date.canonical_to_date(''' ||
689: fnd_date.date_to_canonical(ld_end_date+30) || ''')
690: and ppa.action_type in (''R'',''Q'')
691: and ppa.last_update_date >= fnd_date.canonical_to_date(''' ||
692: lv_date || ''')
693: and ppa.consolidation_set_id like ''' || lv_cons_set_id || '''
694: and ppa.payroll_id like ''' || lv_payroll_id || '''
695: and ppa.payroll_action_id = paa.payroll_action_id

Line 749: fnd_date.canonical_to_date('2004/07/01 00:00:00'))

745: and cp_end_date + 30
746: and ppa.action_type in ('R','Q')
747: and ppa.last_update_date >=
748: greatest(cp_start_date,
749: fnd_date.canonical_to_date('2004/07/01 00:00:00'))
750: and ppa.consolidation_set_id like cp_cons_set_id
751: and ppa.payroll_id like cp_payroll_id
752: and ppa.payroll_action_id = paa.payroll_action_id
753: and paa.source_action_id is not null

Line 799: fnd_date.canonical_to_date('2004/07/01 00:00:00'))

795: and cp_end_date + 30
796: and ppa.action_type in ('R','Q')
797: and ppa.last_update_date >=
798: greatest(cp_start_date,
799: fnd_date.canonical_to_date('2004/07/01 00:00:00'))
800: and ppa.consolidation_set_id like cp_cons_set_id
801: and ppa.payroll_id like cp_payroll_id
802: and ppa.payroll_action_id = paa.payroll_action_id
803: and paa.source_action_id is not null