1071: IF l_property_flag = 'N' THEN
1072: -- get hierarchy name
1073: SELECT name
1074: INTO l_hierarchy_name
1075: FROM per_organization_structures
1076: WHERE organization_structure_id = p_org_hierarchy_id;
1077:
1078: -- get the hierarchy property text
1079: SELECT meaning
1106: IF l_property_flag = 'N' THEN
1107: -- get hierarchy name
1108: SELECT name
1109: INTO l_hierarchy_name
1110: FROM per_organization_structures
1111: WHERE organization_structure_id = p_org_hierarchy_id;
1112:
1113: -- get the hierarchy property text
1114: SELECT meaning