APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on HR_ORGANIZATION_UNITS
Line 6029: from hr_organization_units org
6025: -- pabodla : mapping data
6026: --
6027: cursor c_get_mapping_name2(p_id in number,p_date in date) is
6028: select org.name 6029: from hr_organization_units org 6030: where business_group_id = p_business_group_id
6031: and organization_id = p_id
6032: and p_date between Date_from
6033: and nvl(Date_to, p_date) ;