APPS.QP_MODIFIERS_UTIL dependencies on QP_RLTD_MODIFIERS

Line 2323: qp_rltd_modifiers qrm where

2319: SELECT *
2320: FROM QP_LIST_LINES qll
2321: WHERE qll.list_line_id IN
2322: (select to_rltd_modifier_id from
2323: qp_rltd_modifiers qrm where
2324: from_rltd_modifier_id = l_list_line_id);
2325:
2326: BEGIN
2327:

Line 2998: DELETE FROM QP_RLTD_MODIFIERS

2994:
2995: DELETE FROM QP_QUALIFIERS
2996: WHERE LIST_LINE_ID = p_list_line_id;
2997:
2998: DELETE FROM QP_RLTD_MODIFIERS
2999: WHERE TO_RLTD_MODIFIER_ID = p_list_line_id;
3000:
3001: DELETE FROM QP_LIST_LINES
3002: WHERE LIST_LINE_ID = p_list_line_id ;

Line 3369: FROM QP_RLTD_MODIFIERS

3365: , l_MODIFIERS_rec.rltd_modifier_grp_type
3366: , l_MODIFIERS_rec.from_rltd_modifier_id
3367: , l_MODIFIERS_rec.to_rltd_modifier_id
3368: , l_MODIFIERS_rec.rltd_modifier_id
3369: FROM QP_RLTD_MODIFIERS
3370: WHERE ( TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID )
3371: AND EXISTS
3372: ( SELECT TO_RLTD_MODIFIER_ID
3373: FROM QP_RLTD_MODIFIERS

Line 3373: FROM QP_RLTD_MODIFIERS

3369: FROM QP_RLTD_MODIFIERS
3370: WHERE ( TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID )
3371: AND EXISTS
3372: ( SELECT TO_RLTD_MODIFIER_ID
3373: FROM QP_RLTD_MODIFIERS
3374: WHERE TO_RLTD_MODIFIER_ID = l_implicit_rec.LIST_LINE_ID );
3375:
3376: Exception
3377: when no_data_found then