APPS.PAY_FR_TERMINATION_PKG dependencies on FND_DATE

Line 98: fnd_date.canonical_to_date(org_information1) date_from,

94:
95: /* get table of historical monthly hours from org eit */
96: Cursor monthly_hours(c_org_id number) is
97: select to_number(org_information3) monthly_hours,
98: fnd_date.canonical_to_date(org_information1) date_from,
99: fnd_date.canonical_to_date(org_information2) date_to
100: from
101: hr_organization_information
102: where

Line 99: fnd_date.canonical_to_date(org_information2) date_to

95: /* get table of historical monthly hours from org eit */
96: Cursor monthly_hours(c_org_id number) is
97: select to_number(org_information3) monthly_hours,
98: fnd_date.canonical_to_date(org_information1) date_from,
99: fnd_date.canonical_to_date(org_information2) date_to
100: from
101: hr_organization_information
102: where
103: org_information_context = 'FR_HISTORICAL_MONTHLY_REF_HRS'

Line 105: order by fnd_date.canonical_to_date(org_information1);

101: hr_organization_information
102: where
103: org_information_context = 'FR_HISTORICAL_MONTHLY_REF_HRS'
104: and organization_id = c_org_id
105: order by fnd_date.canonical_to_date(org_information1);
106:
107:
108: Function Find_Hours(p_date_start date) return number is
109: l_hours_index number :=0;

Line 332: Select fnd_date.canonical_to_date(pds_information10)

328: /* For the last assignment effective end date, make it equal to the last day worked */
329:
330: hr_utility.trace('last period of service_id = ' || l_assignments(l_assignments.last).period_of_service_id);
331: l_period_of_service_id := l_assignments(l_assignments.last).period_of_service_id;
332: Select fnd_date.canonical_to_date(pds_information10)
333: into
334: l_last_day_worked
335: from per_periods_of_service
336: where period_of_service_id = l_period_of_service_id;