APPS.HXC_EXT_TIMECARD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

SELECT	tbb_time.start_time
,	tbb_time.stop_time
,	tbb_time.comment_text comments
,       DECODE( tbb_time.date_to, hr_general.end_of_time, 'N', 'Y' ) deleted
,	tbb_time.time_building_block_id
,	tbb_time.object_version_number
,       tbb_summary.approval_status
FROM
	hxc_time_building_blocks tbb_time
,	hxc_timecard_summary tbb_summary
WHERE
	tbb_time.resource_id	= p_person_id AND
	tbb_time.scope 		= 'TIMECARD'  AND
	tbb_time.object_version_number = ( select MAX( tbb.object_version_number )
					   from   hxc_time_building_Blocks tbb
					   where  tbb.time_building_block_id = tbb_time.time_building_block_id )
AND
	p_start_date <= tbb_time.stop_time  AND
	p_end_date   >= tbb_time.start_time
AND
	tbb_summary.timecard_id     = tbb_time.time_building_block_id AND
	tbb_summary.timecard_ovn    = tbb_time.object_version_number  AND
	tbb_summary.approval_status = p_status
ORDER BY
	tbb_time.start_time;

Line: 41

SELECT
	tbb_time.start_time
,	tbb_time.stop_time
,	tbb_time.comment_text comments
,       DECODE( tbb_time.date_to, hr_general.end_of_time, 'N', 'Y' ) deleted
,	tbb_time.time_building_block_id
,	tbb_time.object_version_number
,       tbb_summary.approval_status
FROM
	hxc_time_building_blocks tbb_time
,	hxc_timecard_summary tbb_summary
WHERE
	tbb_time.resource_id	= p_person_id AND
	tbb_time.scope 		= 'TIMECARD'  AND
	tbb_time.object_version_number = ( select MAX( tbb.object_version_number )
					   from   hxc_time_building_Blocks tbb
					   where  tbb.time_building_block_id = tbb_time.time_building_block_id )
AND
	tbb_summary.timecard_id  = tbb_time.time_building_block_id AND
	tbb_summary.timecard_ovn = tbb_time.object_version_number
ORDER BY
	tbb_time.start_time;

Line: 65

SELECT	/*+ ORDERED /
        tbb_day.time_building_block_id tbb_day_id
,       tbb_day.start_time day_start_time
,	tbb_day.comment_text comments
,       tbb_detail.time_building_block_id
,       tbb_detail.object_version_number
,	tbb_detail.measure
,	tbb_detail.start_time
,	tbb_detail.stop_time
,       ta.attribute_category
,       ta.attribute1
,       ta.attribute2
,       ta.attribute3
,       ta.attribute4
,       ta.attribute5
,       ta.attribute6
,       ta.attribute7
FROM
	hxc_time_building_blocks tbb_day
,	hxc_time_building_blocks tbb_detail
,	hxc_time_attribute_usages tau
,	hxc_time_attributes ta
WHERE
	tbb_day.parent_building_block_id  = p_tbb_id AND
	tbb_day.parent_building_block_ovn = p_tbb_ovn AND
	tbb_day.object_version_number = ( select MAX ( tbb.object_version_number )
                                          from   hxc_time_building_blocks tbb
                                          where  tbb.time_building_block_id = tbb_day.time_building_block_id )
AND
	tbb_detail.parent_building_block_id = tbb_day.time_building_block_id AND
	tbb_detail.object_version_number    = ( select MAX ( tbb1.object_version_number )
                                                from   hxc_time_building_blocks tbb1
                                                where  tbb1.time_building_block_id
                                                     = tbb_detail.time_building_block_id )
AND
	tau.time_building_block_id  = tbb_detail.time_building_block_id AND
	tau.time_building_block_ovn = tbb_detail.object_version_number
AND
	ta.time_attribute_id  = tau.time_attribute_id AND
	ta.attribute_category <> 'SECURITY'
ORDER BY
	tbb_day.start_time
,       tbb_detail.time_building_block_id;

Line: 157

hxc_ext_timecard.OTL_TC_DELTED     := p_summary_rec.deleted;

Line: 218

SELECT  line_num
FROM    po_lines_all
WHERE   po_line_id = TO_NUMBER(p_line_id);

Line: 224

SELECT  meaning
FROM    fnd_lookups
WHERE   lookup_type = 'PRICE DIFFERENTIALS'
AND     lookup_code = p_price_type;

Line: 230

SELECT task_name
FROM   pa_online_tasks_v
WHERE  task_id = TO_NUMBER( p_task_id );

Line: 235

SELECT project_name
FROM   pa_online_projects_v
WHERE  project_id = TO_NUMBER( p_project_id );

Line: 240

SELECT element_name
from   pay_element_types_f
where  element_type_id = TO_NUMBER(p_element_type_id);

Line: 589

	,p_tc_deleted => l_tc_summary.deleted
	,p_include    => l_include );