APPS.PAY_IN_TAX_DECLARATION dependencies on FND_DATE

Line 72: , fnd_date.canonical_to_date(org.org_information2) locking_period_start

68: CURSOR csr_locking_period_details(c_person_id IN NUMBER)
69: IS
70: SELECT nvl(org.org_information1, 'N') locking_period
71: , nvl(org.org_information3, 0) window_period
72: , fnd_date.canonical_to_date(org.org_information2) locking_period_start
73: , TRUNC(SYSDATE - start_date) hire_duration
74: FROM hr_organization_information org
75: , per_people_f person
76: , per_assignments_f assign

Line 7451: g_insurace_values(g_insurace_index).input4_value := to_char(fnd_date.canonical_to_date(rec.policy_start_date),'MM/DD/YYYY');

7447: g_insurace_values(g_insurace_index).entry_id := rec.entry_id;
7448: g_insurace_values(g_insurace_index).input1_value := rec.premium_paid;
7449: g_insurace_values(g_insurace_index).input2_value := rec.sum_assured;
7450: g_insurace_values(g_insurace_index).input3_value := rec.policy_number;
7451: g_insurace_values(g_insurace_index).input4_value := to_char(fnd_date.canonical_to_date(rec.policy_start_date),'MM/DD/YYYY');
7452: g_insurace_index := g_insurace_index + 1;
7453: --
7454: END LOOP;
7455: --