APPS.OE_ORDER_PRICE_PVT dependencies on QP_PRICING_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 3582: qp_pricing_phases b

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)
3586: = decode(p_hdr_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))

Line 3656: qp_pricing_phases b

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)
3660: = decode(one_line.price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))

Line 3737: qp_pricing_phases b

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)
3741: = decode(l_price_flag, 'Y', nvl(b.user_freeze_override_flag,b.freeze_override_flag), 'P', 'Y'))

Line 6276: FROM qp_pricing_phases p,

6272: BEGIN
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