[Home] [Help]
156: || ' AND htbb_tc.scope = ''TIMECARD'''
157: || ' AND htbb_tc.resource_id = htbb.resource_id'
158: || ' AND TRUNC(htbb_tc.start_time) >= TRUNC(htbb.start_time)'
159: || ' AND TRUNC(htbb_tc.stop_time) <= TRUNC(htbb.stop_time)'
160: || ' AND htbb_tc.date_to = hr_general.end_of_time'
161: || ' AND NVL(htbb_tc.comment_text, '' '') '
162: || p_operator
163: || ' '''
164: || l_like_string
204: || ' hxc_time_building_blocks htbb_detail'
205: || ' WHERE aplinks.application_period_id = ' || p_block_id
206: || ' AND aplinks.time_building_block_id = htbb_detail.time_building_block_id '
207: || ' AND aplinks.time_building_block_ovn = htbb_detail.object_version_number '
208: || ' AND htbb_detail.date_to = hr_general.end_of_time'
209: || ' AND NVL(htbb_detail.comment_text, '' '') '
210: || p_operator
211: || ' '''
212: || l_like_string
327: || ' hxc_time_attributes hta'
328: || ' WHERE aplinks.application_period_id = ' || p_block_id
329: || ' AND aplinks.time_building_block_id = htbb_detail.time_building_block_id '
330: || ' AND aplinks.time_building_block_ovn = htbb_detail.object_version_number '
331: || ' AND htbb_detail.date_to = hr_general.end_of_time'
332: || ' AND htau.time_building_block_id = htbb_detail.time_building_block_id'
333: || ' AND htau.time_building_block_ovn = htbb_detail.object_version_number'
334: || ' AND htau.time_attribute_id = hta.time_attribute_id'
335: || ' AND hta.attribute_category = ' || '''' || l_context || ''''
342: || ' hxc_time_attributes hta'
343: || ' WHERE aplinks.application_period_id = ' || p_block_id
344: || ' AND aplinks.time_building_block_id = htbb_detail.time_building_block_id '
345: || ' AND aplinks.time_building_block_ovn = htbb_detail.object_version_number '
346: || ' AND htbb_detail.date_to = hr_general.end_of_time'
347: || ' AND htau.time_building_block_id = htbb_detail.time_building_block_id'
348: || ' AND htau.time_building_block_ovn = htbb_detail.object_version_number'
349: || ' AND htau.time_attribute_id = hta.time_attribute_id'
350: || ' AND hta.attribute_category = ' || '''' || l_context || ''''
420:
421: l_sql_select := 'SELECT time_building_block_id';
422: l_sql_from := 'FROM hxc_time_building_blocks htbb';
423: l_sql_where := 'WHERE htbb.time_building_block_id IN (' || p_block_ids || ')'
424: || ' AND htbb.date_to = hr_general.end_of_time';
425:
426: if g_debug then
427: hr_utility.set_location(g_package||l_proc, 30);
428: end if;
502: || l_search_operator || ''',''' || l_search_value || ''') = ''Y''';
503:
504: ELSIF l_search_by = 'STATUS_CODE'
505: THEN
506: l_one_where := 'hr_general.decode_lookup(''HXC_APPROVAL_STATUS'', htbb.approval_status)'
507: || l_search_operator
508: || ' '''
509: || l_like_string
510: || l_search_value
554: ||' and pha.vendor_id=pv.VENDOR_ID
555: and pla.po_header_id= pha.po_header_id
556: and htau.TIME_ATTRIBUTE_ID = hta.time_attribute_id
557: and htau.time_building_block_id = detail.time_building_block_id
558: and detail.date_to = hr_general.end_of_time
559: and hadl.time_building_block_id = detail.time_building_block_id
560: and hadl.time_building_block_ovn = detail.object_version_number
561: and hta.bld_blk_info_type_id ='|| l_bld_blk_info_type_id||')';
562:
731: apsum.application_period_id
732: ,apsum.application_period_ovn
733: ,apsum.start_time
734: ,apsum.stop_time
735: ,hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status)
736: ,ppf.full_name
737: ,htbb.comment_text
738: ,favtl.application_name
739: ,apsum.resource_id
1032: apsum.application_period_id
1033: ,apsum.application_period_ovn
1034: ,apsum.start_time
1035: ,apsum.stop_time
1036: ,hr_general.decode_lookup('HXC_APPROVAL_STATUS', apsum.approval_status)
1037: ,ppf.full_name
1038: ,htbb.comment_text
1039: ,favtl.application_name
1040: ,apsum.resource_id