DBA Data[Home] [Help]

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) ;