DBA Data[Home] [Help]

APPS.QP_LIMIT_TRANSACTIONS_PVT dependencies on QP_EVENT_PHASES

Line 45: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1

41: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,qp_npreq_ldets_tmp_N1,PRICING_STATUS_CODE,2
42: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,qp_npreq_ldets_tmp_N1,PRICING_PHASE_ID,3
43: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
44: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
45: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
46: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
47: */
48: CURSOR limit_trans_cur(a_pricing_event_code VARCHAR2)
49: IS

Line 46: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2

42: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,qp_npreq_ldets_tmp_N1,PRICING_PHASE_ID,3
43: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_HEADER_ID,4
44: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,qp_npreq_ldets_tmp_N1,CREATED_FROM_LIST_LINE_ID,5
45: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
46: INDX,qp_limit_transactions_pvt.delete.limit_trans_cur,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,2
47: */
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,

Line 54: FROM qp_event_phases evt, qp_pricing_phases qpp

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
57: WHERE evt.PRICING_PHASE_ID = qpp.PRICING_PHASE_ID
58: AND instr(a_pricing_event_code, evt.pricing_event_code || ',') > 0

Line 90: from qp_event_phases evt

86: from qp_npreq_ldets_tmp ldet
87: where ldet.created_from_list_header_id = cl.list_header_id
88: and ldet.line_index = cl.line_index
89: and ldet.pricing_phase_id in (select pricing_phase_id
90: from qp_event_phases evt
91: where instr(p_pricing_event_code, evt.pricing_event_code || ',') > 0))
92: LOOP
93: QP_PREQ_GRP.engine_debug('adjustments for above transactions '||cl1.created_from_list_header_id||' status '||cl1.pricing_status_code);
94: END LOOP;