APPS.QP_LIMIT_BALANCE_CHECK_PVT dependencies on QP_NPREQ_RLTD_LINES_TMP

Line 2431: FROM qp_npreq_rltd_lines_tmp b

2427: g_limit_balance_line(j).list_line_id
2428: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2429: AND a.line_detail_index IN
2430: (SELECT b.related_line_detail_index
2431: FROM qp_npreq_rltd_lines_tmp b
2432: WHERE b.line_index = a.line_index
2433: AND b.relationship_type_code = 'PRICE_BREAK'
2434: AND b.line_detail_index =
2435: g_limit_balance_line(j).line_detail_index);

Line 2809: FROM qp_npreq_rltd_lines_tmp b

2805: g_limit_balance_line(j).list_line_id
2806: AND a.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2807: AND a.line_detail_index IN
2808: (SELECT b.related_line_detail_index
2809: FROM qp_npreq_rltd_lines_tmp b
2810: WHERE b.line_index = a.line_index
2811: AND b.relationship_type_code = 'PRICE_BREAK'
2812: AND b.line_detail_index =
2813: g_limit_balance_line(j).line_detail_index);

Line 2820: UPDATE qp_npreq_rltd_lines_tmp a

2816: QP_PREQ_GRP.engine_debug('label 4');
2817: END IF;
2818: --bug#12916970
2819: QP_PREQ_GRP.engine_debug('operand_calculation_code-DK-'||g_limit_balance_line(j).operand_calculation_code);
2820: UPDATE qp_npreq_rltd_lines_tmp a
2821: SET a.operand = g_limit_balance_line(j).operand_value
2822: WHERE a.line_index = g_limit_balance_line(j).line_index
2823: AND a.list_line_id =
2824: g_limit_balance_line(j).list_line_id