APPS.BEN_PLAN_DESIGN_PROGRAM_MODULE dependencies on HR_ALL_ORGANIZATION_UNITS_VL

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

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

Line 6465: from hr_all_organization_units_vl org

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