APPS.QP_LIMIT_TRANSACTIONS_PVT dependencies on QP_NPREQ_LINES_TMP

Line 52: FROM qp_limit_transactions t, qp_npreq_lines_tmp b

48: CURSOR limit_trans_cur(a_pricing_event_code VARCHAR2)
49: IS
50: SELECT t.limit_balance_id, t.list_header_id, t.list_line_id,
51: t.price_request_code, t.pricing_phase_id, t.amount
52: FROM qp_limit_transactions t, qp_npreq_lines_tmp b
53: WHERE t.pricing_phase_id IN (SELECT evt.pricing_phase_id
54: FROM qp_event_phases evt, qp_pricing_phases qpp
55: -- WHERE pricing_event_code = a_pricing_event_code)
56: --fix for bug 4765137

Line 81: from qp_npreq_lines_tmp line, qp_limit_transactions trx

77: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete*** ');
78: QP_PREQ_GRP.engine_debug('***Begin Procedure Delete***: price_event: '|| p_pricing_event_code);
79:
80: for cl in (select line.line_index, line.price_request_code, trx.list_header_id, trx.pricing_phase_id
81: from qp_npreq_lines_tmp line, qp_limit_transactions trx
82: where trx.price_request_code = line.price_request_code)
83: LOOP
84: QP_PREQ_GRP.engine_debug('Limit transactions for current lines '||cl.line_index||' price_reqCode '||cl.price_request_code||' listhdrid '||cl.list_header_id);
85: for cl1 in (select ldet.created_from_list_header_id, ldet.pricing_status_code