APPS.FII_CCC_SEC_UPL_PKG dependencies on HRI_DBI_CL_PER_N_V

Line 45: FROM hri_dbi_cl_per_n_v

41: BEGIN
42:
43: BEGIN
44: SELECT distinct id INTO l_grantee_key
45: FROM hri_dbi_cl_per_n_v
46: WHERE value = x_grantee_name;
47: EXCEPTION
48: WHEN no_data_found THEN
49: l_err_msg := fnd_message.get_string('FII', 'FII_CCC_SEC_INVALID_GRANT_TO');

Line 199: FROM hri_dbi_cl_per_n_v

195: END IF;
196:
197: BEGIN
198: SELECT distinct value INTO l_grant_to_name
199: FROM hri_dbi_cl_per_n_v
200: WHERE id = l_grantee_key;
201: EXCEPTION
202: WHEN no_data_found THEN
203: l_grant_to_name := 'N/A';