APPS.PAY_GB_PAYE_SYNC dependencies on FND_DATE

Line 315: l_effective_date := fnd_date.canonical_to_date(p_eff_date);

311: -- hr_utility.trace_on(null,'paye');
312:
313: -- Store the BG id, Tax Ref and Effective date in local variable
314: l_tax_ref := p_tax_ref;
315: l_effective_date := fnd_date.canonical_to_date(p_eff_date);
316: l_business_group_id := p_business_group_id;
317:
318: l_effective_date := to_char(l_effective_date,'DD-MON-YYYY');
319:

Line 320: l_cpe_start_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');

316: l_business_group_id := p_business_group_id;
317:
318: l_effective_date := to_char(l_effective_date,'DD-MON-YYYY');
319:
320: l_cpe_start_date := fnd_date.canonical_to_date('0001/01/01 00:00:00');
321:
322:
323: /* Check whether Effective date is between 06-Apr-2009 and sysdate (Current Date) */
324:

Line 791: l_prev_person_cpe date := fnd_date.canonical_to_date('4712/12/31 00:00:00');

787: l_prev_person_id number := -1;
788: l_person_index number := 0;
789:
790: l_curr_person_cpe date;
791: l_prev_person_cpe date := fnd_date.canonical_to_date('4712/12/31 00:00:00');
792:
793:
794: l_arg1 varchar2(30) := null;
795: l_arg2 date;

Line 1068: fnd_date.canonical_to_date(argument3) --Effective Date

1064: * in the file. If diff raise exception, else proceed.
1065: */
1066: begin
1067: select argument1, --Tax Reference
1068: fnd_date.canonical_to_date(argument3) --Effective Date
1069: into l_arg1, l_arg2
1070: from fnd_concurrent_requests
1071: where request_id=download_cp_req_id;
1072: