APPS.QP_ATM_UPGRADE dependencies on OE_DEF_ATTR_CONDNS

Line 11: FROM oe_def_attr_condns b,

7: /*CURSOR attribute_sourcing_cur (p_prc_context_code in varchar2,
8: p_segment_mapping_column in varchar2,
9: p_application_short_name in varchar2) is
10: SELECT d.*
11: FROM oe_def_attr_condns b,
12: ak_object_attributes a,
13: oe_def_condn_elems c,
14: oe_def_condn_elems c1,
15: oe_def_attr_def_rules d

Line 36: UPDATE oe_def_attr_condns

32: PROCEDURE p_upd_bad_upg_seed_data IS
33: --Private function to update bad seed data created from 10.7 to 11i upgrade.
34: BEGIN
35:
36: UPDATE oe_def_attr_condns
37: SET enabled_flag = 'N'
38: WHERE
39: Condition_id IN (
40: SELECT C.condition_id

Line 42: oe_def_attr_condns C,

38: WHERE
39: Condition_id IN (
40: SELECT C.condition_id
41: FROM
42: oe_def_attr_condns C,
43: oe_def_conditions_vl CT
44: WHERE
45: C.condition_id = CT.condition_id AND
46: C. database_object_name IN (

Line 54: oe_def_attr_condns CS

50: CT.display_name like 'ONT%' AND
51: C.condition_id > 1000 AND
52: C.system_flag= 'Y' AND
53: 1< (SELECT count(*) FROM oe_def_conditions_vl CTS,
54: oe_def_attr_condns CS
55: WHERE
56: CTS.display_name = CT.display_name
57: AND CTS.condition_id = CS.condition_id
58: AND CS.attribute_code = C.attribute_code )

Line 228: FROM oe_def_attr_condns b,

224: dummy varchar2(1);
225: begin
226: SELECT 'x'
227: INTO dummy
228: FROM oe_def_attr_condns b,
229: ak_object_attributes oa,
230: oe_def_condn_elems c1,
231: oe_def_condn_elems c2
232: WHERE c1.value_string = p_prc_context_code and

Line 265: FROM oe_def_attr_condns b,

261: l_count := 0;
262: begin
263: SELECT 'x'
264: INTO dummy
265: FROM oe_def_attr_condns b,
266: ak_object_attributes oa,
267: oe_def_condn_elems c1
268: WHERE c1.value_string = p_prc_context_code and
269: b.attribute_code = p_segment_mapping_column and

Line 290: FROM oe_def_attr_condns b,

286: --
287: begin
288: SELECT 'x'
289: INTO dummy
290: FROM oe_def_attr_condns b,
291: ak_object_attributes oa,
292: oe_def_condn_elems c1
293: WHERE c1.value_string = p_prc_context_code and
294: b.attribute_code = p_segment_mapping_column and

Line 1091: FROM oe_def_attr_condns b,

1087: --
1088: CURSOR pte_seg_cur (p_prc_context_code in varchar2,
1089: p_segment_mapping_column in varchar2) is
1090: SELECT substr(c1.value_string,1,30) application_short_name
1091: FROM oe_def_attr_condns b,
1092: ak_object_attributes a,
1093: oe_def_condn_elems c,
1094: oe_def_condn_elems c1
1095: WHERE substr(c.value_string,1,30) = p_prc_context_code and