APPS.OTA_FR_PLAN_DFORM dependencies on FND_DATE

Line 120: ,fnd_date.date_to_canonical(class.course_start_date) class_from

116: Cursor csr_event_list (c_member_id number,
117: c_member_level varchar2)IS
118: select distinct class.event_id class_id
119: ,class_tl.title class_title
120: ,fnd_date.date_to_canonical(class.course_start_date) class_from
121: ,fnd_date.date_to_canonical(class.course_end_date) class_to
122: from ota_events class,
123: ota_events_tl class_tl,
124: ota_activity_versions course

Line 121: ,fnd_date.date_to_canonical(class.course_end_date) class_to

117: c_member_level varchar2)IS
118: select distinct class.event_id class_id
119: ,class_tl.title class_title
120: ,fnd_date.date_to_canonical(class.course_start_date) class_from
121: ,fnd_date.date_to_canonical(class.course_end_date) class_to
122: from ota_events class,
123: ota_events_tl class_tl,
124: ota_activity_versions course
125: where class.event_id is not null

Line 180: l_tp_select :='Select tp.training_plan_id, tp.name,org_unit.name, fnd_date.date_to_canonical(period.start_date),fnd_date.date_to_canonical(period.end_date)';

176: --
177: -- Building up the main cursor to fetch training plans and corresponding training plan values
178: l_organization_from := '';
179: --
180: l_tp_select :='Select tp.training_plan_id, tp.name,org_unit.name, fnd_date.date_to_canonical(period.start_date),fnd_date.date_to_canonical(period.end_date)';
181: l_tp_from := ' from ota_training_plans tp ,per_time_periods period, hr_organization_units org_unit';
182: l_tp_where := ' where tp.business_group_id = :p_business_group_id'
183: ||' and tp.time_period_id = period.time_period_id'
184: ||' and period.time_period_id = :p_time_period_id'