APPS.OTA_FR_PLAN_DFORM dependencies on HR_ORGANIZATION_UNITS

Line 31: l_org_name hr_organization_units.name%TYPE;

27: l_sql varchar2(1500);
28: --
29: l_plan_id number;
30: l_plan_name ota_training_plans.name%TYPE;
31: l_org_name hr_organization_units.name%TYPE;
32: l_period_from varchar2(25);
33: l_period_to varchar2(25);
34: l_budget_level varchar2(20);
35: --

Line 181: l_tp_from := ' from ota_training_plans tp ,per_time_periods period, hr_organization_units org_unit';

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'
185: ||' and period.period_set_name = :p_calendar'