APPS.IRC_UTILITIES_PKG dependencies on HR_ALL_POSITIONS_F

Line 2068: FROM HR_ALL_POSITIONS_F

2064: END IF;
2065: IF(p_position_id IS NOT NULL) THEN
2066: SELECT name
2067: INTO l_position_name
2068: FROM HR_ALL_POSITIONS_F
2069: WHERE position_id = p_position_id
2070: AND TRUNC(sysdate) between effective_start_date and effective_end_date;
2071:
2072: OPEN csr_select_column_names('PER_POSITIONS');

Line 2079: || ' from hr_all_positions_f where position_id = '

2075:
2076: IF csr_select_column_names%found THEN
2077: query_stmt := 'select '
2078: || l_column_name
2079: || ' from hr_all_positions_f where position_id = '
2080: || p_position_id
2081: || ' AND TRUNC(sysdate) between effective_start_date and effective_end_date';
2082: EXECUTE immediate query_stmt INTO return_val;
2083: END IF;