APPS.OE_ORDER_PRICE_PVT dependencies on QP_EVENT_PHASES

Line 156: from qp_event_Phases e, qp_pricing_phases p

152:
153: Cursor get_phases(l_event_code1 in Varchar2) Is
154: Select e.Pricing_Phase_Id,
155: nvl(p.user_freeze_override_flag,p.freeze_override_flag) pof
156: from qp_event_Phases e, qp_pricing_phases p
157: where e.pricing_phase_id = p.pricing_phase_id and
158: trunc(sysdate) between Trunc(nvl(start_date_active,sysdate)) and
159: trunc(nvl(End_Date_Active,sysdate))
160: and e.pricing_event_code IN

Line 173: FROM qp_event_phases

169: ,5 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
170: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
171: ,6 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
172: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
173: FROM qp_event_phases
174: WHERE rownum < 7);
175: --
176: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
177: --

Line 3581: from qp_event_phases a,

3577: AND LINE_ID IS NULL
3578: AND LIST_LINE_TYPE_CODE NOT IN ('TAX')
3579: AND NVL(UPDATED_FLAG, 'N')='N'
3580: AND PRICING_PHASE_ID IN (select b.pricing_phase_id
3581: from qp_event_phases a,
3582: qp_pricing_phases b
3583: where instr(p_pricing_events, a.pricing_event_code||',') > 0
3584: and b.pricing_phase_id = a.pricing_phase_id
3585: and nvl(b.user_freeze_override_flag,freeze_override_flag)

Line 3655: from qp_event_phases a,

3651: LINE_ID = one_line.line_id
3652: AND LIST_LINE_TYPE_CODE NOT IN ('TAX','IUE') --bug 2858712
3653: AND NVL(UPDATED_FLAG, 'N')='N'
3654: AND PRICING_PHASE_ID IN (select b.pricing_phase_id
3655: from qp_event_phases a,
3656: qp_pricing_phases b
3657: where instr(p_pricing_events, a.pricing_event_code||',') > 0
3658: and b.pricing_phase_id = a.pricing_phase_id
3659: and nvl(b.user_freeze_override_flag,freeze_override_flag)

Line 3736: from qp_event_phases a,

3732: WHERE HEADER_ID=oe_order_pub.g_hdr.header_id
3733: AND LINE_ID=p_line_id
3734: AND NVL(UPDATED_FLAG, 'N')='N'
3735: AND PRICING_PHASE_ID IN (select b.pricing_phase_id
3736: from qp_event_phases a,
3737: qp_pricing_phases b
3738: where instr(p_pricing_events, a.pricing_event_code||',') > 0
3739: and b.pricing_phase_id = a.pricing_phase_id
3740: and nvl(b.user_freeze_override_flag,b.freeze_override_flag)

Line 3968: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases

3964: ,OE_PRICE_ADJUSTMENTS ADJ
3965: ,QP_LDETS_V LDETS
3966: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
3967: AND LDETS.LINE_INDEX = QPLINES.LINE_INDEX
3968: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
3969: -- where pricing_event_code = p_pricing_events)
3970: --changes to enable multiple events passed as a string
3971: where instr(l_pricing_events, pricing_event_code||',') > 0)
3972: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,

Line 3986: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases

3982: OE_PRICE_ADJUSTMENTS ADJ
3983: ,QP_LDETS_V LDETS
3984: Where LDETS.LIST_LINE_ID = ADJ.LIST_LINE_ID
3985: AND LDETS.LINE_INDEX = p_hdr_line_index
3986: AND ADJ.PRICING_PHASE_ID in (select pricing_phase_id from qp_event_phases
3987: -- where pricing_event_code = p_pricing_events)
3988: --changes to enable multiple events passed as a string
3989: where instr(l_pricing_events, pricing_event_code||',') > 0)
3990: AND LDETS.PROCESS_CODE in (QP_PREQ_GRP.G_STATUS_UNCHANGED,

Line 6277: qp_event_phases e

6273: l_event_in_phase1 := 'N';
6274:
6275: SELECT 'Y' INTO l_event_in_phase1
6276: FROM qp_pricing_phases p,
6277: qp_event_phases e
6278: WHERE p.pricing_phase_id=e.pricing_phase_id
6279: AND p.pricing_phase_id = 1
6280: AND e.pricing_event_code= p_pricing_events
6281: AND trunc(sysdate) BETWEEN trunc(nvl(e.end_date_active,sysdate))