APPS.PQH_UTILITY dependencies on PER_ORGANIZATION_STRUCTURES

Line 2076: l_oh_name per_organization_structures.name%type;

2072: p_organization_structure_id in number,
2073: p_starting_organization_id in number,
2074: p_organization_id in number) return varchar2 is
2075: l_scope varchar2(1000);
2076: l_oh_name per_organization_structures.name%type;
2077: begin
2078: if p_business_group_id is null then
2079: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','GLOBAL');
2080: else

Line 2083: select name into l_oh_name from per_organization_structures where organization_structure_id = p_organization_structure_id;

2079: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','GLOBAL');
2080: else
2081: l_scope := hr_general.decode_lookup('PQH_RULE_SET_SCOPE','BG')||':'||hr_general.decode_organization(p_business_group_id);
2082: if p_organization_structure_id is not null then
2083: select name into l_oh_name from per_organization_structures where organization_structure_id = p_organization_structure_id;
2084: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','OH')||':'||l_oh_name;
2085: if p_starting_organization_id is not null then
2086: l_scope := l_scope||' / '||hr_general.decode_lookup('PQH_RULE_SET_SCOPE','STORG')||':'||hr_general.decode_organization(p_starting_organization_id);
2087: end if;

Line 2129: v_org_hier_name per_organization_structures.name%TYPE := NULL;

2125: END;
2126: ---
2127: FUNCTION get_org_hierarchy_name(p_organization_structure_id IN NUMBER) RETURN VARCHAR2
2128: IS
2129: v_org_hier_name per_organization_structures.name%TYPE := NULL;
2130: CURSOR c_hier_cur
2131: IS SELECT name FROM per_organization_structures
2132: WHERE organization_structure_id = p_organization_structure_id;
2133: BEGIN

Line 2131: IS SELECT name FROM per_organization_structures

2127: FUNCTION get_org_hierarchy_name(p_organization_structure_id IN NUMBER) RETURN VARCHAR2
2128: IS
2129: v_org_hier_name per_organization_structures.name%TYPE := NULL;
2130: CURSOR c_hier_cur
2131: IS SELECT name FROM per_organization_structures
2132: WHERE organization_structure_id = p_organization_structure_id;
2133: BEGIN
2134: IF p_organization_structure_id IS NOT NULL THEN
2135: OPEN c_hier_cur;