390: -- Added by Skgautam for bug 4177206
391: --Cursor to query user profile option name for given profile option name
392: CURSOR l_profile_name_csr(p_profile_code IN VARCHAR2) IS
393: SELECT USER_PROFILE_OPTION_NAME
394: FROM FND_PROFILE_OPTIONS_VL
395: WHERE PROFILE_OPTION_NAME = p_profile_code;
396:
397: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;
398:
763: -- Added by Skgautam for bug 4177206
764: --Cursor to query user profile option name for given profile option name
765: CURSOR l_profile_name_csr(p_profile_code IN VARCHAR2) IS
766: SELECT USER_PROFILE_OPTION_NAME
767: FROM FND_PROFILE_OPTIONS_VL
768: WHERE PROFILE_OPTION_NAME = p_profile_code;
769:
770: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;
771:
1044: --04-Jan-2004 PAGARG Bug# 3941338
1045: --Cursor to query user profile option name for given profile option name
1046: CURSOR l_profile_name_csr(p_profile_code IN VARCHAR2) IS
1047: SELECT USER_PROFILE_OPTION_NAME
1048: FROM FND_PROFILE_OPTIONS_VL
1049: WHERE PROFILE_OPTION_NAME = p_profile_code;
1050: l_profile_name FND_PROFILE_OPTIONS_TL.USER_PROFILE_OPTION_NAME%TYPE;
1051:
1052: BEGIN