DBA Data[Home] [Help]

APPS.QP_MODIFIERS_UTIL dependencies on QP_RLTD_MODIFIERS

Line 2252: qp_rltd_modifiers qrm where

2248: SELECT *
2249: FROM QP_LIST_LINES qll
2250: WHERE qll.list_line_id IN
2251: (select to_rltd_modifier_id from
2252: qp_rltd_modifiers qrm where
2253: from_rltd_modifier_id = l_list_line_id);
2254:
2255: BEGIN
2256:

Line 2921: DELETE FROM QP_RLTD_MODIFIERS

2917:
2918: DELETE FROM QP_QUALIFIERS
2919: WHERE LIST_LINE_ID = p_list_line_id;
2920:
2921: DELETE FROM QP_RLTD_MODIFIERS
2922: WHERE TO_RLTD_MODIFIER_ID = p_list_line_id;
2923:
2924: DELETE FROM QP_LIST_LINES
2925: WHERE LIST_LINE_ID = p_list_line_id ;

Line 3286: FROM QP_RLTD_MODIFIERS

3282: , l_MODIFIERS_rec.rltd_modifier_grp_type
3283: , l_MODIFIERS_rec.from_rltd_modifier_id
3284: , l_MODIFIERS_rec.to_rltd_modifier_id
3285: , l_MODIFIERS_rec.rltd_modifier_id
3286: FROM QP_RLTD_MODIFIERS
3287: WHERE ( TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID )
3288: AND EXISTS
3289: ( SELECT TO_RLTD_MODIFIER_ID
3290: FROM QP_RLTD_MODIFIERS

Line 3290: FROM QP_RLTD_MODIFIERS

3286: FROM QP_RLTD_MODIFIERS
3287: WHERE ( TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID )
3288: AND EXISTS
3289: ( SELECT TO_RLTD_MODIFIER_ID
3290: FROM QP_RLTD_MODIFIERS
3291: WHERE TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID );
3292:
3293: Exception
3294: when no_data_found then