APPS.OE_ORDER_ADJ_PVT dependencies on QP_EVENT_PHASES

Line 8846: from qp_event_phases

8842: assoc.price_adjustment_id = p_price_adjustment_id;
8843:
8844: Cursor ph_ids IS
8845: Select pricing_phase_id
8846: from qp_event_phases
8847: where pricing_event_code like 'BOOK';
8848:
8849: l_prg_line_id NUMBER;
8850: l_found_prg_line BOOLEAN;

Line 10778: from qp_event_Phases e, qp_pricing_phases p

10774: Procedure Populate_Pricing_Phases(p_pricing_event in Varchar2) Is
10775:
10776: Cursor get_phases(l_event_code1 in Varchar2) Is
10777: Select e.Pricing_Phase_Id,nvl(p.user_freeze_override_flag,p.freeze_override_flag) freeze_override_flag
10778: from qp_event_Phases e, qp_pricing_phases p
10779: where e.pricing_phase_id = p.pricing_phase_id and
10780: trunc(sysdate) between Trunc(nvl(start_date_active,sysdate)) and
10781: trunc(nvl(End_Date_Active,sysdate))
10782: and e.pricing_event_code IN

Line 10795: FROM qp_event_phases

10791: ,5 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
10792: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
10793: ,6 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
10794: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
10795: FROM qp_event_phases
10796: WHERE rownum < 7);
10797: Begin
10798:
10799: G_Pricing_Phase_Id_Tbl.delete;

Line 10944: select 'x' from qp_event_phases ep

10940: --For bug#2675212
10941: i pls_integer;
10942: l_call_process_adjustments varchar2(1) := 'N';
10943: cursor check_lines is
10944: select 'x' from qp_event_phases ep
10945: where ep.pricing_event_code = p_control_rec.pricing_event
10946: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
10947: trunc(nvl(end_date_active, sysdate));
10948: /*cursor check_lines2 is

Line 10949: select 'x' from qp_event_phases ep

10945: where ep.pricing_event_code = p_control_rec.pricing_event
10946: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
10947: trunc(nvl(end_date_active, sysdate));
10948: /*cursor check_lines2 is
10949: select 'x' from qp_event_phases ep
10950: where ep.pricing_event_code IN ('BATCH','BOOK','SHIP')
10951: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
10952: trunc(nvl(end_date_active, sysdate));*/
10953:

Line 10955: select 'x' from qp_event_phases ep

10951: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
10952: trunc(nvl(end_date_active, sysdate));*/
10953:
10954: cursor check_lines2 is
10955: select 'x' from qp_event_phases ep
10956: where instr(p_control_rec.pricing_event||',',
10957: ep.pricing_event_code||',') > 0
10958: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
10959: trunc(nvl(end_date_active, sysdate));

Line 13313: FROM qp_pricing_phases a , qp_event_phases b

13309: AND qppr.product_attribute='PRICING_ATTRIBUTE3' -- bug#7488440
13310: AND qppr.product_attr_value='ALL' -- bug#7488440
13311: AND qppr.pricing_phase_id
13312: IN ( SELECT distinct a.pricing_phase_id
13313: FROM qp_pricing_phases a , qp_event_phases b
13314: WHERE
13315: a.pricing_phase_id = b.pricing_phase_id
13316: -- AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y') -- bug#7488440
13317: AND b.pricing_event_code in (SELECT decode(rownum

Line 13334: FROM qp_event_phases

13330: instr(p_event_code1,',',1,rownum-1))
13331: ,6 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
13332: instr(p_event_code1,',',1,rownum)-1 -
13333: instr(p_event_code1,',',1,rownum-1)))
13334: FROM qp_event_phases
13335: WHERE rownum < 7))
13336: AND ROWNUM = 1;
13337:
13338: x_get_manual_adv VARCHAR2(1);