DBA Data[Home] [Help]

APPS.OKL_AUTO_INSURANCE_PVT dependencies on FND_PROFILE_OPTIONS_VL

Line 394: FROM FND_PROFILE_OPTIONS_VL

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:

Line 767: FROM FND_PROFILE_OPTIONS_VL

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:

Line 1048: FROM FND_PROFILE_OPTIONS_VL

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