DBA Data[Home] [Help]

APPS.IGS_PS_AWD_HNR_BASE_PKG dependencies on FND_PROFILE

Line 103: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND p_rowid IS NULL THEN

99: award_cd = new_references.award_cd AND
100: (p_rowid IS NULL OR rowid <> p_rowid);
101: rec_chk_unk_unt_lvl cur_chk_unk_unt_lvl%ROWTYPE;
102: BEGIN
103: IF NVL(FND_PROFILE.VALUE('CAREER_MODEL_ENABLED'),'N') = 'Y' AND p_rowid IS NULL THEN
104: OPEN cur_chk_prof;
105: FETCH cur_chk_prof INTO rec_chk_prof;
106: IF cur_chk_prof%FOUND THEN
107: CLOSE cur_chk_prof;