APPS.QP_MODIFIERS_PVT dependencies on QP_RLTD_MODIFIERS

Line 20: FROM QP_RLTD_MODIFIERS

16: ) IS
17:
18: cursor c_parent_list_line_id(p_child_list_line_id in number) is
19: SELECT from_rltd_modifier_id
20: FROM QP_RLTD_MODIFIERS
21: WHERE to_rltd_modifier_id = p_child_list_line_id;
22:
23: cursor c_parent_list_line_type_code(p_parent_list_line_id in number) is
24: SELECT list_line_type_code

Line 730: -- julin (3411436): updating qp_rltd_modifiers

726: IF l_MODIFIERS_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
727:
728: QP_Modifiers_Util.Update_Row (l_MODIFIERS_rec);
729:
730: -- julin (3411436): updating qp_rltd_modifiers
731: IF l_MODIFIERS_rec.from_rltd_modifier_id IS NOT NULL
732: AND l_MODIFIERS_rec.list_line_id IS NOT NULL
733: AND l_MODIFIERS_rec.rltd_modifier_grp_no IS NOT NULL
734: AND l_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL

Line 845: select QP_RLTD_MODIFIERS_S.nextval

841: AND l_MODIFIERS_rec.rltd_modifier_grp_no IS NOT NULL
842: AND l_MODIFIERS_rec.rltd_modifier_grp_type IS NOT NULL
843: THEN
844:
845: select QP_RLTD_MODIFIERS_S.nextval
846: into l_rltd_modifiers_s from dual;
847:
848:
849: oe_debug_pub.add('just before insert');

Line 1735: FROM qp_rltd_modifiers

1731:
1732: Begin
1733:
1734: SELECT null INTO x_rltd_modifier_grp_type
1735: FROM qp_rltd_modifiers
1736: WHERE to_rltd_modifier_id = l_PRICING_ATTR_rec.list_line_id
1737: AND rltd_modifier_grp_type = 'PRICE BREAK'
1738: AND ROWNUM = 1;
1739: