eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 102: TYPE tab_ta_fk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE

98: t_detail_approval_status DBMS_SQL.varchar2_table;
99: t_detail_approval_style_id DBMS_SQL.number_table;
100:
101: -- time attribute types
102: TYPE tab_ta_fk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
103: INDEX BY BINARY_INTEGER;
104:
105: TYPE tab_ta_field_name IS TABLE OF hxc_mapping_components.field_name%TYPE
106: INDEX BY BINARY_INTEGER;

Line 528: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE;

524: r_range csr_get_next_range%ROWTYPE;
525: l_dummy VARCHAR2 (1);
526: l_cnt PLS_INTEGER := 0;
527: l_not_maintained_ranges BOOLEAN := TRUE;
528: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE;
529: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE;
530: l_dynamic_sql VARCHAR2 (32000);
531: l_range_start NUMBER;
532: l_range_stop NUMBER;

Line 529: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE;

525: l_dummy VARCHAR2 (1);
526: l_cnt PLS_INTEGER := 0;
527: l_not_maintained_ranges BOOLEAN := TRUE;
528: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE;
529: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE;
530: l_dynamic_sql VARCHAR2 (32000);
531: l_range_start NUMBER;
532: l_range_stop NUMBER;
533:

Line 598: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE

594: SELECT TYPE
595: FROM hxc_debug_text
596: WHERE process = p_range;
597:
598: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE
599: := -1;
600: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE
601: := -1;
602: l_where_blk VARCHAR2 (2000);

Line 600: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE

596: WHERE process = p_range;
597:
598: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE
599: := -1;
600: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE
601: := -1;
602: l_where_blk VARCHAR2 (2000);
603: l_where_att VARCHAR2 (2000);
604: l_dynamic_sql VARCHAR2 (32000);

Line 1655: TYPE tab_max_ovn_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE

1651: GROUP BY txd.time_building_block_id;
1652:
1653: l_max_ovn csr_get_max_ovn_debug%ROWTYPE;
1654:
1655: TYPE tab_max_ovn_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
1656: INDEX BY BINARY_INTEGER;
1657:
1658: TYPE tab_max_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
1659: INDEX BY BINARY_INTEGER;

Line 1658: TYPE tab_max_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE

1654:
1655: TYPE tab_max_ovn_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
1656: INDEX BY BINARY_INTEGER;
1657:
1658: TYPE tab_max_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
1659: INDEX BY BINARY_INTEGER;
1660:
1661: t_max_ovn_bb_id tab_max_ovn_bb_id;
1662: t_max_ovn tab_max_ovn;

Line 3770: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

3766: l_ind PLS_INTEGER;
3767: l_number_format varchar2(2);
3768: l_att26 number;
3769: -- timecard scope building block local variables
3770: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3771: := -1;
3772: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3773: := -1;
3774: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 3772: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

3768: l_att26 number;
3769: -- timecard scope building block local variables
3770: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3771: := -1;
3772: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3773: := -1;
3774: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3775: := -1;
3776: -- timecard scope attribute local variables

Line 3774: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

3770: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3771: := -1;
3772: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3773: := -1;
3774: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
3775: := -1;
3776: -- timecard scope attribute local variables
3777: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
3778: := -1;

Line 3831: FROM hxc_time_building_blocks

3827:
3828: CURSOR csr_how_big_is_htbb
3829: IS
3830: SELECT COUNT (*)
3831: FROM hxc_time_building_blocks
3832: WHERE SCOPE = 'TIMECARD';
3833:
3834: CURSOR get_session_number_format
3835: is

Line 5441: hxc_time_building_blocks tbb,

5437: DECODE (tbb.TYPE, 'MEASURE', tbb.unit_of_measure, 'HOURS'),
5438: tbb.date_from, tbb.date_to, tbb.approval_status,
5439: tbb.approval_style_id
5440: FROM hxc_tmp_bld_blks tmp,
5441: hxc_time_building_blocks tbb,
5442: hxc_time_building_blocks DAY
5443: WHERE tbb.time_building_block_id = tmp.time_building_block_id
5444: AND tbb.object_version_number = tmp.time_building_block_ovn
5445: AND DAY.time_building_block_id = tbb.parent_building_block_id

Line 5442: hxc_time_building_blocks DAY

5438: tbb.date_from, tbb.date_to, tbb.approval_status,
5439: tbb.approval_style_id
5440: FROM hxc_tmp_bld_blks tmp,
5441: hxc_time_building_blocks tbb,
5442: hxc_time_building_blocks DAY
5443: WHERE tbb.time_building_block_id = tmp.time_building_block_id
5444: AND tbb.object_version_number = tmp.time_building_block_ovn
5445: AND DAY.time_building_block_id = tbb.parent_building_block_id
5446: AND DAY.object_version_number = tbb.parent_building_block_ovn

Line 5475: TYPE t_old_bld_blk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE

5471: l_index PLS_INTEGER;
5472: l_dummy VARCHAR2 (1);
5473:
5474: -- bulk collect collections
5475: TYPE t_old_bld_blk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
5476: INDEX BY BINARY_INTEGER;
5477:
5478: TYPE t_old_bld_blk_bb_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
5479: INDEX BY BINARY_INTEGER;

Line 5478: TYPE t_old_bld_blk_bb_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE

5474: -- bulk collect collections
5475: TYPE t_old_bld_blk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
5476: INDEX BY BINARY_INTEGER;
5477:
5478: TYPE t_old_bld_blk_bb_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
5479: INDEX BY BINARY_INTEGER;
5480:
5481: TYPE t_old_bld_blk_parent_id IS TABLE OF hxc_time_building_blocks.parent_building_block_id%TYPE
5482: INDEX BY BINARY_INTEGER;

Line 5481: TYPE t_old_bld_blk_parent_id IS TABLE OF hxc_time_building_blocks.parent_building_block_id%TYPE

5477:
5478: TYPE t_old_bld_blk_bb_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
5479: INDEX BY BINARY_INTEGER;
5480:
5481: TYPE t_old_bld_blk_parent_id IS TABLE OF hxc_time_building_blocks.parent_building_block_id%TYPE
5482: INDEX BY BINARY_INTEGER;
5483:
5484: TYPE t_old_bld_blk_resource_type IS TABLE OF hxc_time_building_blocks.resource_type%TYPE
5485: INDEX BY BINARY_INTEGER;

Line 5484: TYPE t_old_bld_blk_resource_type IS TABLE OF hxc_time_building_blocks.resource_type%TYPE

5480:
5481: TYPE t_old_bld_blk_parent_id IS TABLE OF hxc_time_building_blocks.parent_building_block_id%TYPE
5482: INDEX BY BINARY_INTEGER;
5483:
5484: TYPE t_old_bld_blk_resource_type IS TABLE OF hxc_time_building_blocks.resource_type%TYPE
5485: INDEX BY BINARY_INTEGER;
5486:
5487: TYPE t_old_bld_blk_resource_id IS TABLE OF hxc_time_building_blocks.resource_id%TYPE
5488: INDEX BY BINARY_INTEGER;

Line 5487: TYPE t_old_bld_blk_resource_id IS TABLE OF hxc_time_building_blocks.resource_id%TYPE

5483:
5484: TYPE t_old_bld_blk_resource_type IS TABLE OF hxc_time_building_blocks.resource_type%TYPE
5485: INDEX BY BINARY_INTEGER;
5486:
5487: TYPE t_old_bld_blk_resource_id IS TABLE OF hxc_time_building_blocks.resource_id%TYPE
5488: INDEX BY BINARY_INTEGER;
5489:
5490: TYPE t_old_bld_blk_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE
5491: INDEX BY BINARY_INTEGER;

Line 5490: TYPE t_old_bld_blk_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE

5486:
5487: TYPE t_old_bld_blk_resource_id IS TABLE OF hxc_time_building_blocks.resource_id%TYPE
5488: INDEX BY BINARY_INTEGER;
5489:
5490: TYPE t_old_bld_blk_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE
5491: INDEX BY BINARY_INTEGER;
5492:
5493: TYPE t_old_bld_blk_start_time IS TABLE OF hxc_time_building_blocks.start_time%TYPE
5494: INDEX BY BINARY_INTEGER;

Line 5493: TYPE t_old_bld_blk_start_time IS TABLE OF hxc_time_building_blocks.start_time%TYPE

5489:
5490: TYPE t_old_bld_blk_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE
5491: INDEX BY BINARY_INTEGER;
5492:
5493: TYPE t_old_bld_blk_start_time IS TABLE OF hxc_time_building_blocks.start_time%TYPE
5494: INDEX BY BINARY_INTEGER;
5495:
5496: TYPE t_old_bld_blk_stop_time IS TABLE OF hxc_time_building_blocks.stop_time%TYPE
5497: INDEX BY BINARY_INTEGER;

Line 5496: TYPE t_old_bld_blk_stop_time IS TABLE OF hxc_time_building_blocks.stop_time%TYPE

5492:
5493: TYPE t_old_bld_blk_start_time IS TABLE OF hxc_time_building_blocks.start_time%TYPE
5494: INDEX BY BINARY_INTEGER;
5495:
5496: TYPE t_old_bld_blk_stop_time IS TABLE OF hxc_time_building_blocks.stop_time%TYPE
5497: INDEX BY BINARY_INTEGER;
5498:
5499: TYPE t_old_bld_blk_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE
5500: INDEX BY BINARY_INTEGER;

Line 5499: TYPE t_old_bld_blk_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE

5495:
5496: TYPE t_old_bld_blk_stop_time IS TABLE OF hxc_time_building_blocks.stop_time%TYPE
5497: INDEX BY BINARY_INTEGER;
5498:
5499: TYPE t_old_bld_blk_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE
5500: INDEX BY BINARY_INTEGER;
5501:
5502: TYPE t_old_bld_blk_scope IS TABLE OF hxc_time_building_blocks.SCOPE%TYPE
5503: INDEX BY BINARY_INTEGER;

Line 5502: TYPE t_old_bld_blk_scope IS TABLE OF hxc_time_building_blocks.SCOPE%TYPE

5498:
5499: TYPE t_old_bld_blk_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE
5500: INDEX BY BINARY_INTEGER;
5501:
5502: TYPE t_old_bld_blk_scope IS TABLE OF hxc_time_building_blocks.SCOPE%TYPE
5503: INDEX BY BINARY_INTEGER;
5504:
5505: TYPE t_old_bld_blk_type IS TABLE OF hxc_time_building_blocks.TYPE%TYPE
5506: INDEX BY BINARY_INTEGER;

Line 5505: TYPE t_old_bld_blk_type IS TABLE OF hxc_time_building_blocks.TYPE%TYPE

5501:
5502: TYPE t_old_bld_blk_scope IS TABLE OF hxc_time_building_blocks.SCOPE%TYPE
5503: INDEX BY BINARY_INTEGER;
5504:
5505: TYPE t_old_bld_blk_type IS TABLE OF hxc_time_building_blocks.TYPE%TYPE
5506: INDEX BY BINARY_INTEGER;
5507:
5508: TYPE t_old_bld_blk_uom IS TABLE OF hxc_time_building_blocks.unit_of_measure%TYPE
5509: INDEX BY BINARY_INTEGER;

Line 5508: TYPE t_old_bld_blk_uom IS TABLE OF hxc_time_building_blocks.unit_of_measure%TYPE

5504:
5505: TYPE t_old_bld_blk_type IS TABLE OF hxc_time_building_blocks.TYPE%TYPE
5506: INDEX BY BINARY_INTEGER;
5507:
5508: TYPE t_old_bld_blk_uom IS TABLE OF hxc_time_building_blocks.unit_of_measure%TYPE
5509: INDEX BY BINARY_INTEGER;
5510:
5511: TYPE t_old_bld_blk_date_from IS TABLE OF hxc_time_building_blocks.date_from%TYPE
5512: INDEX BY BINARY_INTEGER;

Line 5511: TYPE t_old_bld_blk_date_from IS TABLE OF hxc_time_building_blocks.date_from%TYPE

5507:
5508: TYPE t_old_bld_blk_uom IS TABLE OF hxc_time_building_blocks.unit_of_measure%TYPE
5509: INDEX BY BINARY_INTEGER;
5510:
5511: TYPE t_old_bld_blk_date_from IS TABLE OF hxc_time_building_blocks.date_from%TYPE
5512: INDEX BY BINARY_INTEGER;
5513:
5514: TYPE t_old_bld_blk_date_to IS TABLE OF hxc_time_building_blocks.date_to%TYPE
5515: INDEX BY BINARY_INTEGER;

Line 5514: TYPE t_old_bld_blk_date_to IS TABLE OF hxc_time_building_blocks.date_to%TYPE

5510:
5511: TYPE t_old_bld_blk_date_from IS TABLE OF hxc_time_building_blocks.date_from%TYPE
5512: INDEX BY BINARY_INTEGER;
5513:
5514: TYPE t_old_bld_blk_date_to IS TABLE OF hxc_time_building_blocks.date_to%TYPE
5515: INDEX BY BINARY_INTEGER;
5516:
5517: TYPE t_old_bld_blk_app_status IS TABLE OF hxc_time_building_blocks.approval_status%TYPE
5518: INDEX BY BINARY_INTEGER;

Line 5517: TYPE t_old_bld_blk_app_status IS TABLE OF hxc_time_building_blocks.approval_status%TYPE

5513:
5514: TYPE t_old_bld_blk_date_to IS TABLE OF hxc_time_building_blocks.date_to%TYPE
5515: INDEX BY BINARY_INTEGER;
5516:
5517: TYPE t_old_bld_blk_app_status IS TABLE OF hxc_time_building_blocks.approval_status%TYPE
5518: INDEX BY BINARY_INTEGER;
5519:
5520: TYPE t_old_bld_blk_app_style_id IS TABLE OF hxc_time_building_blocks.approval_style_id%TYPE
5521: INDEX BY BINARY_INTEGER;

Line 5520: TYPE t_old_bld_blk_app_style_id IS TABLE OF hxc_time_building_blocks.approval_style_id%TYPE

5516:
5517: TYPE t_old_bld_blk_app_status IS TABLE OF hxc_time_building_blocks.approval_status%TYPE
5518: INDEX BY BINARY_INTEGER;
5519:
5520: TYPE t_old_bld_blk_app_style_id IS TABLE OF hxc_time_building_blocks.approval_style_id%TYPE
5521: INDEX BY BINARY_INTEGER;
5522:
5523: TYPE t_old_bld_blk_bb_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE
5524: INDEX BY BINARY_INTEGER;

Line 6296: hxc_time_building_blocks timecard_block

6292: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';
6293: l_from VARCHAR2 (200)
6294: := '
6295: FROM
6296: hxc_time_building_blocks timecard_block
6297: , hxc_time_building_blocks day_block
6298: , Hxc_time_building_blocks detail_block
6299: , Hxc_time_attribute_usages detail_usage
6300: , Hxc_time_attributes detail_att';

Line 6297: , hxc_time_building_blocks day_block

6293: l_from VARCHAR2 (200)
6294: := '
6295: FROM
6296: hxc_time_building_blocks timecard_block
6297: , hxc_time_building_blocks day_block
6298: , Hxc_time_building_blocks detail_block
6299: , Hxc_time_attribute_usages detail_usage
6300: , Hxc_time_attributes detail_att';
6301: l_inline_view_range VARCHAR2 (800)

Line 6298: , Hxc_time_building_blocks detail_block

6294: := '
6295: FROM
6296: hxc_time_building_blocks timecard_block
6297: , hxc_time_building_blocks day_block
6298: , Hxc_time_building_blocks detail_block
6299: , Hxc_time_attribute_usages detail_usage
6300: , Hxc_time_attributes detail_att';
6301: l_inline_view_range VARCHAR2 (800)
6302: := '

Line 6351: , Hxc_time_building_blocks detail_block

6347: ';
6348: l_noloop_from VARCHAR2 (250)
6349: := '
6350: ) tbb
6351: , Hxc_time_building_blocks detail_block
6352: , Hxc_time_attribute_usages detail_usage
6353: , Hxc_time_attributes detail_att
6354: , hxc_time_building_blocks day_block
6355: , hxc_time_building_blocks timecard_block

Line 6354: , hxc_time_building_blocks day_block

6350: ) tbb
6351: , Hxc_time_building_blocks detail_block
6352: , Hxc_time_attribute_usages detail_usage
6353: , Hxc_time_attributes detail_att
6354: , hxc_time_building_blocks day_block
6355: , hxc_time_building_blocks timecard_block
6356: , hxc_max_ovn detail_max_ovn';
6357: l_incremental_from VARCHAR2 (400)
6358: := '

Line 6355: , hxc_time_building_blocks timecard_block

6351: , Hxc_time_building_blocks detail_block
6352: , Hxc_time_attribute_usages detail_usage
6353: , Hxc_time_attributes detail_att
6354: , hxc_time_building_blocks day_block
6355: , hxc_time_building_blocks timecard_block
6356: , hxc_max_ovn detail_max_ovn';
6357: l_incremental_from VARCHAR2 (400)
6358: := '
6359: FROM

Line 6361: , Hxc_time_building_blocks detail_block

6357: l_incremental_from VARCHAR2 (400)
6358: := '
6359: FROM
6360: hxc_retrieval_range_blks tbb
6361: , Hxc_time_building_blocks detail_block
6362: , Hxc_time_attribute_usages detail_usage
6363: , Hxc_time_attributes detail_att
6364: , hxc_time_building_blocks day_block
6365: , hxc_time_building_blocks timecard_block

Line 6364: , hxc_time_building_blocks day_block

6360: hxc_retrieval_range_blks tbb
6361: , Hxc_time_building_blocks detail_block
6362: , Hxc_time_attribute_usages detail_usage
6363: , Hxc_time_attributes detail_att
6364: , hxc_time_building_blocks day_block
6365: , hxc_time_building_blocks timecard_block
6366: , hxc_latest_details hld
6367: , hxc_max_ovn detail_max_ovn';
6368: l_time VARCHAR2 (400)

Line 6365: , hxc_time_building_blocks timecard_block

6361: , Hxc_time_building_blocks detail_block
6362: , Hxc_time_attribute_usages detail_usage
6363: , Hxc_time_attributes detail_att
6364: , hxc_time_building_blocks day_block
6365: , hxc_time_building_blocks timecard_block
6366: , hxc_latest_details hld
6367: , hxc_max_ovn detail_max_ovn';
6368: l_time VARCHAR2 (400)
6369: := '

Line 6375: FROM hxc_time_building_blocks tovn

6371: timecard_block.scope = ''TIMECARD'' AND
6372: timecard_block.approval_status <> ''ERROR'' AND
6373: timecard_block.object_version_number = (
6374: SELECT /*+ no_unnest */ MAX ( tovn.object_version_number )
6375: FROM hxc_time_building_blocks tovn
6376: WHERE tovn.time_building_block_id = timecard_block.time_building_block_id ) ';
6377: l_time_ex VARCHAR2 (560)
6378: := '
6379: WHERE

Line 6384: FROM hxc_time_building_blocks tovn

6380: timecard_block.scope = ''TIMECARD'' AND
6381: timecard_block.approval_status <> ''ERROR'' AND
6382: timecard_block.object_version_number = (
6383: SELECT /*+ no_unnest */ MAX ( tovn.object_version_number )
6384: FROM hxc_time_building_blocks tovn
6385: WHERE tovn.time_building_block_id = timecard_block.time_building_block_id )
6386: AND
6387: timecard_block.start_time
6388: BETWEEN :p_start_date AND :p_end_date AND

Line 6398: FROM hxc_time_building_blocks tovn

6394: timecard_block.scope = ''TIMECARD'' AND
6395: timecard_block.approval_status <> ''ERROR'' AND
6396: timecard_block.object_version_number = (
6397: SELECT /*+ no_unnest */ MAX ( tovn.object_version_number )
6398: FROM hxc_time_building_blocks tovn
6399: WHERE tovn.time_building_block_id = timecard_block.time_building_block_id )
6400: AND
6401: :p_start_date <= timecard_block.stop_time AND
6402: :p_end_date >= timecard_block.start_time ';

Line 6412: FROM hxc_time_building_blocks dyovn

6408: day_block.scope = ''DAY'' AND
6409: day_block.approval_status <> ''ERROR'' AND
6410: day_block.object_version_number = (
6411: SELECT /*+ no_unnest */ MAX ( dyovn.object_version_number )
6412: FROM hxc_time_building_blocks dyovn
6413: WHERE dyovn.time_building_block_id = day_block.time_building_block_id ) ';
6414: l_detail VARCHAR2 (350)
6415: := '
6416: AND

Line 6440: , hxc_time_building_blocks detail_block

6436: := '
6437: FROM
6438: hxc_time_attributes detail_att
6439: , hxc_time_attribute_usages detail_usage
6440: , hxc_time_building_blocks detail_block
6441: , hxc_time_building_blocks day_block
6442: , hxc_time_attributes timecard_att
6443: , hxc_transaction_details txd
6444: , hxc_transactions tx

Line 6441: , hxc_time_building_blocks day_block

6437: FROM
6438: hxc_time_attributes detail_att
6439: , hxc_time_attribute_usages detail_usage
6440: , hxc_time_building_blocks detail_block
6441: , hxc_time_building_blocks day_block
6442: , hxc_time_attributes timecard_att
6443: , hxc_transaction_details txd
6444: , hxc_transactions tx
6445: WHERE

Line 6502: --day and timecard scopes are added in hxc_time_building_blocks table. Here we retrieve only

6498: BEGIN -- build query
6499: --Elp changes sonarasi 14-Mar-2003
6500: --A string of application set ids like (1,2,3,5) etc are obtained for the corresponding time
6501: --recipient id of the application. As per ELP changes, the Application Set Id for the detail,
6502: --day and timecard scopes are added in hxc_time_building_blocks table. Here we retrieve only
6503: --blocks that the Retrieval Application is interested in. So we just add to the where clause
6504: --to compare if the detail building block's application set id is within the list of
6505: --application set ids generated for the corresponding time recipient.
6506: l_app_set :=