APPS.IRC_UTILITIES_PKG dependencies on PER_PAY_BASES

Line 2173: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'PER_PAY_BASES'

2169: CURSOR csr_select_column_names
2170: IS
2171: SELECT APPLICATION_COLUMN_NAME
2172: FROM FND_DESCR_FLEX_COLUMN_USAGES
2173: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'PER_PAY_BASES'
2174: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements'
2175: AND END_USER_COLUMN_NAME = fnd_profile.value('IRC_OFFER_SAL_FLEX_SEGMENT');
2176: Begin
2177: IF(p_salary_basis_id IS NOT NULL) THEN

Line 2180: FROM per_pay_bases

2176: Begin
2177: IF(p_salary_basis_id IS NOT NULL) THEN
2178: SELECT name
2179: INTO l_salary_basis_name
2180: FROM per_pay_bases
2181: WHERE PAY_BASIS_ID = p_salary_basis_id;
2182:
2183: OPEN csr_select_column_names;
2184: FETCH csr_select_column_names

Line 2190: || ' from per_pay_bases where PAY_BASIS_ID = '

2186:
2187: IF csr_select_column_names%found THEN
2188: query_stmt := 'select '
2189: || l_column_name
2190: || ' from per_pay_bases where PAY_BASIS_ID = '
2191: ||p_salary_basis_id;
2192: EXECUTE immediate query_stmt INTO return_val;
2193: END IF;
2194: CLOSE csr_select_column_names;