APPS.IRC_UTILITIES_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2113: FROM HR_ALL_ORGANIZATION_UNITS

2109: END IF;
2110: IF(p_organization_id IS NOT NULL) THEN
2111: SELECT name
2112: INTO l_organization_name
2113: FROM HR_ALL_ORGANIZATION_UNITS
2114: WHERE organization_id = p_organization_id;
2115:
2116: OPEN csr_select_column_names('PER_ORGANIZATION_UNITS');
2117: FETCH csr_select_column_names

Line 2123: || ' from HR_ALL_ORGANIZATION_UNITS where organization_id = '

2119:
2120: IF csr_select_column_names%found THEN
2121: query_stmt := 'select '
2122: || l_column_name
2123: || ' from HR_ALL_ORGANIZATION_UNITS where organization_id = '
2124: ||p_organization_id;
2125: EXECUTE immediate query_stmt INTO return_val;
2126: END IF;
2127: CLOSE csr_select_column_names;

Line 2135: FROM HR_ALL_ORGANIZATION_UNITS

2131: END IF;
2132: IF(p_business_group_id IS NOT NULL) THEN
2133: SELECT name
2134: INTO l_business_group_name
2135: FROM HR_ALL_ORGANIZATION_UNITS
2136: WHERE organization_id = p_business_group_id;
2137:
2138: OPEN csr_select_column_names('PER_ORGANIZATION_UNITS');
2139: FETCH csr_select_column_names

Line 2145: || ' from HR_ALL_ORGANIZATION_UNITS where organization_id = '

2141:
2142: IF csr_select_column_names%found THEN
2143: query_stmt := 'select '
2144: || l_column_name
2145: || ' from HR_ALL_ORGANIZATION_UNITS where organization_id = '
2146: ||p_organization_id;
2147: EXECUTE immediate query_stmt INTO return_val;
2148: END IF;
2149: CLOSE csr_select_column_names;