APPS.OE_ORDER_ADJ_PVT dependencies on QP_EVENT_PHASES

Line 8938: from qp_event_phases

8934: assoc.price_adjustment_id = p_price_adjustment_id;
8935:
8936: Cursor ph_ids IS
8937: Select pricing_phase_id
8938: from qp_event_phases
8939: where pricing_event_code like 'BOOK';
8940:
8941: l_prg_line_id NUMBER;
8942: l_found_prg_line BOOLEAN;

Line 10886: from qp_event_Phases e, qp_pricing_phases p

10882: Procedure Populate_Pricing_Phases(p_pricing_event in Varchar2) Is
10883:
10884: Cursor get_phases(l_event_code1 in Varchar2) Is
10885: Select e.Pricing_Phase_Id,nvl(p.user_freeze_override_flag,p.freeze_override_flag) freeze_override_flag
10886: from qp_event_Phases e, qp_pricing_phases p
10887: where e.pricing_phase_id = p.pricing_phase_id and
10888: trunc(sysdate) between Trunc(nvl(start_date_active,sysdate)) and
10889: trunc(nvl(End_Date_Active,sysdate))
10890: and e.pricing_event_code IN

Line 10903: FROM qp_event_phases

10899: ,5 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
10900: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1))
10901: ,6 ,substr(p_pricing_event , instr(l_event_code1,',',1,rownum-1) + 1,
10902: instr(l_event_code1,',',1,rownum)-1 - instr(l_event_code1,',',1,rownum-1)))
10903: FROM qp_event_phases
10904: WHERE rownum < 7);
10905: Begin
10906:
10907: G_Pricing_Phase_Id_Tbl.delete;

Line 11052: select 'x' from qp_event_phases ep

11048: --For bug#2675212
11049: i pls_integer;
11050: l_call_process_adjustments varchar2(1) := 'N';
11051: cursor check_lines is
11052: select 'x' from qp_event_phases ep
11053: where ep.pricing_event_code = p_control_rec.pricing_event
11054: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
11055: trunc(nvl(end_date_active, sysdate));
11056: /*cursor check_lines2 is

Line 11057: select 'x' from qp_event_phases ep

11053: where ep.pricing_event_code = p_control_rec.pricing_event
11054: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
11055: trunc(nvl(end_date_active, sysdate));
11056: /*cursor check_lines2 is
11057: select 'x' from qp_event_phases ep
11058: where ep.pricing_event_code IN ('BATCH','BOOK','SHIP')
11059: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
11060: trunc(nvl(end_date_active, sysdate));*/
11061:

Line 11063: select 'x' from qp_event_phases ep

11059: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
11060: trunc(nvl(end_date_active, sysdate));*/
11061:
11062: cursor check_lines2 is
11063: select 'x' from qp_event_phases ep
11064: where instr(p_control_rec.pricing_event||',',
11065: ep.pricing_event_code||',') > 0
11066: and trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and
11067: trunc(nvl(end_date_active, sysdate));

Line 13487: FROM qp_pricing_phases a , qp_event_phases b

13483: AND qppr.product_attribute='PRICING_ATTRIBUTE3' -- bug#7488440
13484: AND qppr.product_attr_value='ALL' -- bug#7488440
13485: AND qppr.pricing_phase_id
13486: IN ( SELECT distinct a.pricing_phase_id
13487: FROM qp_pricing_phases a , qp_event_phases b
13488: WHERE
13489: a.pricing_phase_id = b.pricing_phase_id
13490: -- AND (a.oid_exists = 'Y' OR a.line_group_exists = 'Y' OR a.rltd_exists = 'Y') -- bug#7488440
13491: AND b.pricing_event_code in (SELECT decode(rownum

Line 13508: FROM qp_event_phases

13504: instr(p_event_code1,',',1,rownum-1))
13505: ,6 ,substr(p_event_code , instr(p_event_code1,',',1,rownum-1) + 1,
13506: instr(p_event_code1,',',1,rownum)-1 -
13507: instr(p_event_code1,',',1,rownum-1)))
13508: FROM qp_event_phases
13509: WHERE rownum < 7))
13510: AND ROWNUM = 1;
13511:
13512: x_get_manual_adv VARCHAR2(1);