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 733: -- julin (3411436): updating qp_rltd_modifiers

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

Line 848: select QP_RLTD_MODIFIERS_S.nextval

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

Line 1738: FROM qp_rltd_modifiers

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