APPS.GME_MATERIAL_DETAIL_PVT dependencies on GEM_LOOKUP_VALUES

Line 2142: FROM gem_lookup_values

2138: IS
2139: CURSOR cur_byprod_type (v_byprod_type VARCHAR2)
2140: IS
2141: SELECT 1
2142: FROM gem_lookup_values
2143: WHERE lookup_type = 'GMD_BY_PRODUCT_TYPE'
2144: AND lookup_code = v_byprod_type;
2145:
2146: l_api_name CONSTANT VARCHAR2 (30) := 'validate_byproduct_type';

Line 2474: FROM gem_lookup_values

2470: ,x_return_status OUT NOCOPY VARCHAR2)
2471: IS
2472: CURSOR cur_rel_type (v_rel_type VARCHAR2) IS
2473: SELECT 1
2474: FROM gem_lookup_values
2475: WHERE lookup_type = 'GMD_MATERIAL_RELEASE_TYPE'
2476: AND lookup_code = v_rel_type;
2477:
2478: l_exists NUMBER;

Line 2652: FROM gem_lookup_values

2648: IS
2649: CURSOR cur_round_dir (v_round_dir VARCHAR2)
2650: IS
2651: SELECT 1
2652: FROM gem_lookup_values
2653: WHERE lookup_type = 'GMD_ROUNDING_DIRECTION'
2654: AND lookup_code = v_round_dir;
2655:
2656: l_exists NUMBER;

Line 2707: FROM gem_lookup_values

2703:
2704: CURSOR cur_scale_type (v_scale_type VARCHAR2)
2705: IS
2706: SELECT 1
2707: FROM gem_lookup_values
2708: WHERE lookup_type = 'SCALE_TYPE'
2709: AND lookup_code = v_scale_type;
2710:
2711: l_exists NUMBER;

Line 2858: FROM gem_lookup_values

2854:
2855: CURSOR cur_phantom_type (v_phantom_type VARCHAR2)
2856: IS
2857: SELECT 1
2858: FROM gem_lookup_values
2859: WHERE lookup_type = 'PHANTOM_TYPE'
2860: AND lookup_code = v_phantom_type;
2861:
2862: l_exists NUMBER;