APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 6462: l_organization_name hr_all_organization_units_vl.name%type := null;

6458: (
6459: p_organization_id in number
6460: ) return varchar2 is
6461:
6462: l_organization_name hr_all_organization_units_vl.name%type := null;
6463:
6464: cursor c_organization_name is
6465: select org.name
6466: from hr_all_organization_units_vl org

Line 6466: from hr_all_organization_units_vl org

6462: l_organization_name hr_all_organization_units_vl.name%type := null;
6463:
6464: cursor c_organization_name is
6465: select org.name
6466: from hr_all_organization_units_vl org
6467: where org.organization_id = p_organization_id;
6468:
6469: begin
6470: open c_organization_name;