[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
(select a.FLEX_VALUE_SET_ID from
FND_DESCR_FLEX_COLUMN_USAGES a,
fnd_flex_value_sets b
where a.descriptive_flexfield_name = 'OTC Information Types'
and a.application_id = 809
and a.DESCRIPTIVE_FLEX_CONTEXT_CODE = p_context
and a.flex_value_set_id = b.flex_value_set_id
and b.validation_type in ('F','I')
AND a.APPLICATION_COLUMN_NAME = p_column);
l_query := ' select hta.'||p_column||fnd_global.local_chr('10');
l_query := 'select '||l_column||'
from hxc_time_building_blocks
where time_building_block_id = :p_det_bb_id
and object_version_number = :p_det_bb_ovn';
select tbb1.TIME_BUILDING_BLOCK_ID
,tbb1.TYPE
,tbb1.MEASURE
,tbb1.UNIT_OF_MEASURE
,tbb1.START_TIME
,tbb1.STOP_TIME
,tbb1.PARENT_BUILDING_BLOCK_ID
,'N' PARENT_IS_NEW
,tbb1.SCOPE
,tbb1.OBJECT_VERSION_NUMBER
,tbb1.APPROVAL_STATUS
,tbb1.RESOURCE_ID
,tbb1.RESOURCE_TYPE
,tbb1.APPROVAL_STYLE_ID
,tbb1.DATE_FROM
,tbb1.DATE_TO
,tbb1.COMMENT_TEXT
,tbb1.PARENT_BUILDING_BLOCK_OVN
,'N' NEW
,'N' CHANGED
,'N' PROCESS
,tbb1.application_set_id
,tbb1.translation_display_key
from hxc_time_building_blocks tbb1
where tbb1.TIME_BUILDING_BLOCK_ID = p_bb_id
and tbb1.OBJECT_VERSION_NUMBER = p_bb_ovn
and decode(p_get_type,'NEW',hr_general.end_of_time,tbb1.date_to) = tbb1.date_to;
select a.time_attribute_id
,au.time_building_block_id
,bbit.bld_blk_info_type
,a.attribute_category
,a.attribute1
,a.attribute2
,a.attribute3
,a.attribute4
,a.attribute5
,a.attribute6
,a.attribute7
,a.attribute8
,a.attribute9
,a.attribute10
,a.attribute11
,a.attribute12
,a.attribute13
,a.attribute14
,a.attribute15
,a.attribute16
,a.attribute17
,a.attribute18
,a.attribute19
,a.attribute20
,a.attribute21
,a.attribute22
,a.attribute23
,a.attribute24
,a.attribute25
,a.attribute26
,a.attribute27
,a.attribute28
,a.attribute29
,a.attribute30
,a.bld_blk_info_type_id
,a.object_version_number
,'N' NEW
,'N' CHANGED
,'N' PROCESS
from hxc_time_attributes a,
hxc_time_attribute_usages au,
hxc_bld_blk_info_types bbit
where au.time_building_block_id = p_building_block_id
and au.time_building_block_ovn = p_ovn
and au.time_attribute_id = a.time_attribute_id
and (not (a.attribute_category = 'SECURITY'))
and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id;
SELECT alias_value_name
FROM hxc_alias_values_tl
WHERE alias_value_id = p_alias_value_id;
select tab.creation_date
from (select distinct htbb.creation_date creation_date
from hxc_time_building_blocks htbb, hxc_ap_detail_links hadl
where htbb.time_building_block_id = hadl.time_building_block_id
and hadl.application_period_id = p_app_bb_id
order by creation_date desc) tab
where rownum <= 2;
select tab.creation_date
from (select distinct detail.creation_date creation_date
from hxc_time_building_blocks detail,hxc_time_building_blocks day
where day.parent_building_block_id =p_app_bb_id
and detail.parent_building_block_id = day.time_building_block_id
and detail.parent_building_block_ovn = day.object_version_number
and detail.scope='DETAIL'
order by 1 desc) tab
where rownum <= 2;
select NVL(max(object_version_number),-1)
from hxc_time_building_blocks htbb
where htbb.creation_date <= (p_last_creation_date+0.000011574)
and date_to <> hr_general.end_of_time
and htbb.time_building_block_id = p_det_bb_id
and htbb.approval_status = hxc_timecard.c_submitted_status;
l_select hxc_layout_comp_qualifiers.qualifier_attribute27%type;
select QUALIFIER_ATTRIBUTE28||'|'||QUALIFIER_ATTRIBUTE28||'|'||QUALIFIER_ATTRIBUTE7
from HXC_LAYOUT_COMP_QUALIFIERS where LAYOUT_COMPONENT_ID = p_layout_comp_id ;
SELECT
Distinct A.Qualifier_Attribute26,
A.Qualifier_Attribute27
FROM
Hxc_Layout_Comp_Qualifiers A,
Hxc_Layout_Components B,
Hxc_Layouts C
WHERE
C.Layout_Id = (Select Layout_Id From Hxc_Layout_Components Where Layout_Component_Id = P_Layout_Comp_Id) And
A.Layout_Component_Id = B.Layout_Component_Id And
A.Qualifier_Attribute28=p_alias_name;
fetch get_alias_location into l_bld_blk_info_type,l_select;
l_query:= 'select ta.'|| l_select;