APPS.PAY_DK_ARCHIVE_EIN dependencies on FND_DATE

Line 356: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);

352: ,g_sender_id) ;
353:
354: hr_utility.set_location('RANGE_CODE:After Calling all parameters',2);
355:
356: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
357: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
358: SELECT count(*)
359: INTO l_count
360: FROM pay_action_information

Line 357: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);

353:
354: hr_utility.set_location('RANGE_CODE:After Calling all parameters',2);
355:
356: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
357: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
358: SELECT count(*)
359: INTO l_count
360: FROM pay_action_information
361: WHERE action_information_category = 'EMEA REPORT DETAILS'

Line 785: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);

781: fetch csr_pay_periods into pp;
782: l_canonical_start_date := pp.start_date;
783: l_canonical_end_date := pp.end_date;
784: */
785: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
786: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
787:
788: l_prepay_action_id := 0;
789: l_prev_person_id := 0;

Line 786: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);

782: l_canonical_start_date := pp.start_date;
783: l_canonical_end_date := pp.end_date;
784: */
785: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
786: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
787:
788: l_prepay_action_id := 0;
789: l_prev_person_id := 0;
790: l_prev_assg_id := 0;

Line 1956: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);

1952: ,g_end_date
1953: ,g_test_submission
1954: ,g_company_terminating
1955: ,g_sender_id) ;
1956: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
1957: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
1958:
1959: --13463885
1960: OPEN csr_use_hol_card(g_legal_employer_id);

Line 1957: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);

1953: ,g_test_submission
1954: ,g_company_terminating
1955: ,g_sender_id) ;
1956: l_canonical_start_date := fnd_date.canonical_to_date(g_start_date);
1957: l_canonical_end_date := fnd_date.canonical_to_date(g_end_date);
1958:
1959: --13463885
1960: OPEN csr_use_hol_card(g_legal_employer_id);
1961: FETCH csr_use_hol_card INTO l_use_holiday_card;