DBA Data[Home] [Help]

APPS.IBE_DSP_SECTION_GRP dependencies on FND_LOOKUP_VALUES

Line 859: IS SELECT lookup_code FROM fnd_lookup_values

855: l_return_status VARCHAR2(1);
856: l_tmp_str VARCHAR2(30);
857:
858: CURSOR c3(l_c_status_code IN VARCHAR2)
859: IS SELECT lookup_code FROM fnd_lookup_values
860: WHERE lookup_type = 'IBE_SECTION_STATUS' AND
861: lookup_code = l_c_status_code AND
862: language = USERENV('LANG');
863:

Line 1047: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values

1043:
1044: -- section type code
1045: -- note that p_section_type_code won't be NULL due to previous checks
1046: BEGIN
1047: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values
1048: WHERE lookup_type = 'IBE_SECTION_TYPE' AND
1049: lookup_code = p_section_type_code AND
1050: language = USERENV('LANG');
1051: EXCEPTION

Line 1176: IS SELECT lookup_code FROM fnd_lookup_values

1172: l_tmp_str VARCHAR2(30);
1173: l_return_status VARCHAR2(1);
1174:
1175: CURSOR c3(l_c_status_code IN VARCHAR2)
1176: IS SELECT lookup_code FROM fnd_lookup_values
1177: WHERE lookup_type = 'IBE_SECTION_STATUS' AND
1178: lookup_code = l_c_status_code AND
1179: language = USERENV('LANG');
1180:

Line 1362: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values

1358: -- section type code
1359: -- note that p_section_type_code won't be NULL due to previous checks
1360: IF (p_section_type_code <> FND_API.G_MISS_CHAR) THEN
1361: BEGIN
1362: SELECT lookup_code INTO l_tmp_str FROM fnd_lookup_values
1363: WHERE lookup_type = 'IBE_SECTION_TYPE' AND
1364: lookup_code = p_section_type_code AND
1365: language = USERENV('LANG');
1366: EXCEPTION