APPS.GME_MATERIAL_DETAIL_PVT dependencies on GEM_LOOKUP_VALUES

Line 2286: FROM gem_lookup_values

2282: IS
2283: CURSOR cur_byprod_type (v_byprod_type VARCHAR2)
2284: IS
2285: SELECT 1
2286: FROM gem_lookup_values
2287: WHERE lookup_type = 'GMD_BY_PRODUCT_TYPE'
2288: AND lookup_code = v_byprod_type;
2289:
2290: l_api_name CONSTANT VARCHAR2 (30) := 'validate_byproduct_type';

Line 2618: FROM gem_lookup_values

2614: ,x_return_status OUT NOCOPY VARCHAR2)
2615: IS
2616: CURSOR cur_rel_type (v_rel_type VARCHAR2) IS
2617: SELECT 1
2618: FROM gem_lookup_values
2619: WHERE lookup_type = 'GMD_MATERIAL_RELEASE_TYPE'
2620: AND lookup_code = v_rel_type;
2621:
2622: l_exists NUMBER;

Line 2796: FROM gem_lookup_values

2792: IS
2793: CURSOR cur_round_dir (v_round_dir VARCHAR2)
2794: IS
2795: SELECT 1
2796: FROM gem_lookup_values
2797: WHERE lookup_type = 'GMD_ROUNDING_DIRECTION'
2798: AND lookup_code = v_round_dir;
2799:
2800: l_exists NUMBER;

Line 2851: FROM gem_lookup_values

2847:
2848: CURSOR cur_scale_type (v_scale_type VARCHAR2)
2849: IS
2850: SELECT 1
2851: FROM gem_lookup_values
2852: WHERE lookup_type = 'SCALE_TYPE'
2853: AND lookup_code = v_scale_type;
2854:
2855: l_exists NUMBER;

Line 3002: FROM gem_lookup_values

2998:
2999: CURSOR cur_phantom_type (v_phantom_type VARCHAR2)
3000: IS
3001: SELECT 1
3002: FROM gem_lookup_values
3003: WHERE lookup_type = 'PHANTOM_TYPE'
3004: AND lookup_code = v_phantom_type;
3005:
3006: l_exists NUMBER;