APPS.QP_QP_FORM_MODIFIERS dependencies on QP_LIST_LINES

Line 2505: FROM QP_LIST_LINES L, QP_RLTD_MODIFIERS RM

2501: , L.SUBSTITUTION_VALUE
2502: , RM.RLTD_MODIFIER_GRP_NO
2503: , RM.RLTD_MODIFIER_GRP_TYPE
2504: , L.CONTINUOUS_PRICE_BREAK_FLAG
2505: FROM QP_LIST_LINES L, QP_RLTD_MODIFIERS RM
2506: WHERE L.LIST_LINE_ID = RM.TO_RLTD_MODIFIER_ID
2507: AND RM.FROM_RLTD_MODIFIER_ID = p_list_line_id
2508: AND L.LIST_HEADER_ID = p_list_header_id;
2509:

Line 2747: FROM QP_LIST_LINES

2743:
2744: --Storing continuous_price_break_flag value for later use,to convert non continuous price break lines into continuous line.
2745:
2746: SELECT continuous_price_break_flag INTO l_continuous_price_break_flag
2747: FROM QP_LIST_LINES
2748: WHERE list_line_id=p_old_list_line_id;
2749:
2750: FOR l_implicit_rec IN l_LIST_LINE_csr(p_old_list_line_id) LOOP
2751:

Line 2754: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id

2750: FOR l_implicit_rec IN l_LIST_LINE_csr(p_old_list_line_id) LOOP
2751:
2752: oe_debug_pub.add('Inside related modifier cursor for line : '||p_new_list_line_id, 3);
2753:
2754: SELECT qp_List_lines_s.nextval INTO l_new_list_line_id
2755: FROM dual;
2756:
2757: oe_debug_pub.add('From Modifier : '||p_new_list_line_id, 3);
2758: oe_debug_pub.add('To Modifier : '||l_new_list_line_id, 3);