APPS.IRC_UTILITIES_PKG dependencies on PER_GRADES

Line 2047: FROM per_grades

2043: --
2044: IF(p_grade_id IS NOT NULL) THEN
2045: SELECT name
2046: INTO l_grade_name
2047: FROM per_grades
2048: WHERE grade_id = p_grade_id;
2049:
2050: OPEN csr_select_column_names('PER_GRADES');
2051: FETCH csr_select_column_names

Line 2050: OPEN csr_select_column_names('PER_GRADES');

2046: INTO l_grade_name
2047: FROM per_grades
2048: WHERE grade_id = p_grade_id;
2049:
2050: OPEN csr_select_column_names('PER_GRADES');
2051: FETCH csr_select_column_names
2052: INTO l_column_name;
2053:
2054: IF csr_select_column_names%found THEN

Line 2057: || ' from per_grades where grade_id = :grade_id';

2053:
2054: IF csr_select_column_names%found THEN
2055: query_stmt := 'select '
2056: || l_column_name
2057: || ' from per_grades where grade_id = :grade_id';
2058: EXECUTE immediate query_stmt INTO return_val USING p_grade_id;
2059: END IF;
2060: CLOSE csr_select_column_names;
2061: IF (return_val IS NOT NULL) THEN