APPS.QP_QP_FORM_MODIFIERS dependencies on QP_LIST_LINES

Line 2542: FROM QP_LIST_LINES L, QP_RLTD_MODIFIERS RM

2538: , RM.RLTD_MODIFIER_GRP_TYPE
2539: , L.CONTINUOUS_PRICE_BREAK_FLAG
2540: , L.SERVICE_DURATION
2541: , L.SERVICE_PERIOD
2542: FROM QP_LIST_LINES L, QP_RLTD_MODIFIERS RM
2543: WHERE L.LIST_LINE_ID = RM.TO_RLTD_MODIFIER_ID
2544: AND RM.FROM_RLTD_MODIFIER_ID = p_list_line_id
2545: AND L.LIST_HEADER_ID = p_list_header_id;
2546:

Line 2784: FROM QP_LIST_LINES

2780:
2781: --Storing continuous_price_break_flag value for later use,to convert non continuous price break lines into continuous line.
2782:
2783: SELECT continuous_price_break_flag INTO l_continuous_price_break_flag
2784: FROM QP_LIST_LINES
2785: WHERE list_line_id=p_old_list_line_id;
2786:
2787: FOR l_implicit_rec IN l_LIST_LINE_csr(p_old_list_line_id) LOOP
2788:

Line 2791: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id

2787: FOR l_implicit_rec IN l_LIST_LINE_csr(p_old_list_line_id) LOOP
2788:
2789: oe_debug_pub.add('Inside related modifier cursor for line : '||p_new_list_line_id, 3);
2790:
2791: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2792: FROM dual;
2793:
2794: oe_debug_pub.add('From Modifier : '||p_new_list_line_id, 3);
2795: oe_debug_pub.add('To Modifier : '||l_new_list_line_id, 3);