DBA Data[Home] [Help]

APPS.HRI_OLTP_EMB_EQTY_ANAL dependencies on FND_PROFILE

Line 247: RETURN NVL(fnd_profile.value('HRI_DBI_CHO_NMD_USR') ,-1);

243: /* Returns a person_id from a DBI CHO profile option */
244: FUNCTION get_level_1_sup_id RETURN NUMBER
245: IS
246: BEGIN
247: RETURN NVL(fnd_profile.value('HRI_DBI_CHO_NMD_USR') ,-1);
248: END get_level_1_sup_id;
249:
250:
251: /*

Line 460: AND (NVL(fnd_profile.value('HRI_DBI_CHO_NMD_USR'),-1) <> -1)

456:
457:
458: /* add another report row for the CEO/Company data */
459: IF ( p_ceo_row = 'Y'
460: AND (NVL(fnd_profile.value('HRI_DBI_CHO_NMD_USR'),-1) <> -1)
461: )
462: THEN
463: /* combine the fact SQL to create the report UI */
464: get_outer_columns(p_parameter_rec => l_parameter_rec