[Home] [Help]
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
16: WHERE substr(c.value_string,1,30) = p_prc_context_code and
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
233: b.attribute_code = p_segment_mapping_column and
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
270: b.database_object_name = oa.database_object_name and
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
295: b.database_object_name = oa.database_object_name and
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
1096: b.attribute_code = p_segment_mapping_column and