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 543: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE;

539: r_range csr_get_next_range%ROWTYPE;
540: l_dummy VARCHAR2 (1);
541: l_cnt PLS_INTEGER := 0;
542: l_not_maintained_ranges BOOLEAN := TRUE;
543: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE;
544: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE;
545: l_dynamic_sql VARCHAR2 (32000);
546: l_range_start NUMBER;
547: l_range_stop NUMBER;

Line 544: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE;

540: l_dummy VARCHAR2 (1);
541: l_cnt PLS_INTEGER := 0;
542: l_not_maintained_ranges BOOLEAN := TRUE;
543: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE;
544: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE;
545: l_dynamic_sql VARCHAR2 (32000);
546: l_range_start NUMBER;
547: l_range_stop NUMBER;
548:

Line 626: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE

622: AND hrp.time_recipient_id = has.time_recipient_id;
623:
624:
625:
626: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE
627: := -1;
628: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE
629: := -1;
630: l_where_blk VARCHAR2 (2000);

Line 628: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE

624:
625:
626: l_first_resource_id hxc_time_building_blocks.resource_id%TYPE
627: := -1;
628: l_last_resource_id hxc_time_building_blocks.resource_id%TYPE
629: := -1;
630: l_where_blk VARCHAR2 (2000);
631: l_where_att VARCHAR2 (2000);
632: l_dynamic_sql VARCHAR2 (32000);

Line 701: INDEX(sum HXC_TIME_BUILDING_BLOCKS_PK) */

697: request_id,
698: ret_user_id,
699: process)
700: SELECT /*+ INDEX(tbb LATEST_DETAILS_N2)
701: INDEX(sum HXC_TIME_BUILDING_BLOCKS_PK) */
702: DISTINCT tbb.timecard_id,
703: sum.resource_id,
704: sum.start_time,
705: TRUNC(sum.stop_time),

Line 711: hxc_time_building_blocks sum

707: fnd_global.conc_request_id,
708: fnd_global.user_id,
709: RETRIEVALPROCESS
710: FROM LATEST_DETAILS tbb,
711: hxc_time_building_blocks sum
712: WHERE sum.resource_id = tbb.resource_id
713: AND sum.time_building_block_id = tbb.timecard_id
714: AND tbb.last_update_date > :p_since_date';
715:

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

2250: GROUP BY txd.time_building_block_id;
2251:
2252: l_max_ovn csr_get_max_ovn_debug%ROWTYPE;
2253:
2254: TYPE tab_max_ovn_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
2255: INDEX BY BINARY_INTEGER;
2256:
2257: TYPE tab_max_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
2258: INDEX BY BINARY_INTEGER;

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

2253:
2254: TYPE tab_max_ovn_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
2255: INDEX BY BINARY_INTEGER;
2256:
2257: TYPE tab_max_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
2258: INDEX BY BINARY_INTEGER;
2259:
2260: t_max_ovn_bb_id tab_max_ovn_bb_id;
2261: t_max_ovn tab_max_ovn;

Line 4400: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

4396: l_ind PLS_INTEGER;
4397: l_number_format varchar2(2);
4398: l_att26 number;
4399: -- timecard scope building block local variables
4400: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4401: := -1;
4402: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4403: := -1;
4404: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

Line 4402: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

4398: l_att26 number;
4399: -- timecard scope building block local variables
4400: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4401: := -1;
4402: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4403: := -1;
4404: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4405: := -1;
4406: -- timecard scope attribute local variables

Line 4404: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE

4400: l_old_timecard_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4401: := -1;
4402: l_old_day_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4403: := -1;
4404: l_old_detail_bb_id hxc_time_building_blocks.time_building_block_id%TYPE
4405: := -1;
4406: -- timecard scope attribute local variables
4407: l_old_timecard_ta_id hxc_time_attributes.time_attribute_id%TYPE
4408: := -1;

Line 4469: FROM hxc_time_building_blocks

4465:
4466: CURSOR csr_how_big_is_htbb
4467: IS
4468: SELECT COUNT (*)
4469: FROM hxc_time_building_blocks
4470: WHERE SCOPE = 'TIMECARD';
4471:
4472: CURSOR get_session_number_format
4473: is

Line 6176: hxc_time_building_blocks tbb,

6172: DECODE (tbb.TYPE, 'MEASURE', tbb.unit_of_measure, 'HOURS'),
6173: tbb.date_from, tbb.date_to, tbb.approval_status,
6174: tbb.approval_style_id
6175: FROM hxc_tmp_bld_blks tmp,
6176: hxc_time_building_blocks tbb,
6177: hxc_time_building_blocks DAY
6178: WHERE tbb.time_building_block_id = tmp.time_building_block_id
6179: AND tbb.object_version_number = tmp.time_building_block_ovn
6180: AND DAY.time_building_block_id = tbb.parent_building_block_id

Line 6177: hxc_time_building_blocks DAY

6173: tbb.date_from, tbb.date_to, tbb.approval_status,
6174: tbb.approval_style_id
6175: FROM hxc_tmp_bld_blks tmp,
6176: hxc_time_building_blocks tbb,
6177: hxc_time_building_blocks DAY
6178: WHERE tbb.time_building_block_id = tmp.time_building_block_id
6179: AND tbb.object_version_number = tmp.time_building_block_ovn
6180: AND DAY.time_building_block_id = tbb.parent_building_block_id
6181: AND DAY.object_version_number = tbb.parent_building_block_ovn

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

6206: l_index PLS_INTEGER;
6207: l_dummy VARCHAR2 (1);
6208:
6209: -- bulk collect collections
6210: TYPE t_old_bld_blk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
6211: INDEX BY BINARY_INTEGER;
6212:
6213: TYPE t_old_bld_blk_bb_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
6214: INDEX BY BINARY_INTEGER;

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

6209: -- bulk collect collections
6210: TYPE t_old_bld_blk_bb_id IS TABLE OF hxc_time_building_blocks.time_building_block_id%TYPE
6211: INDEX BY BINARY_INTEGER;
6212:
6213: TYPE t_old_bld_blk_bb_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
6214: INDEX BY BINARY_INTEGER;
6215:
6216: TYPE t_old_bld_blk_parent_id IS TABLE OF hxc_time_building_blocks.parent_building_block_id%TYPE
6217: INDEX BY BINARY_INTEGER;

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

6212:
6213: TYPE t_old_bld_blk_bb_ovn IS TABLE OF hxc_time_building_blocks.object_version_number%TYPE
6214: INDEX BY BINARY_INTEGER;
6215:
6216: TYPE t_old_bld_blk_parent_id IS TABLE OF hxc_time_building_blocks.parent_building_block_id%TYPE
6217: INDEX BY BINARY_INTEGER;
6218:
6219: TYPE t_old_bld_blk_resource_type IS TABLE OF hxc_time_building_blocks.resource_type%TYPE
6220: INDEX BY BINARY_INTEGER;

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

6215:
6216: TYPE t_old_bld_blk_parent_id IS TABLE OF hxc_time_building_blocks.parent_building_block_id%TYPE
6217: INDEX BY BINARY_INTEGER;
6218:
6219: TYPE t_old_bld_blk_resource_type IS TABLE OF hxc_time_building_blocks.resource_type%TYPE
6220: INDEX BY BINARY_INTEGER;
6221:
6222: TYPE t_old_bld_blk_resource_id IS TABLE OF hxc_time_building_blocks.resource_id%TYPE
6223: INDEX BY BINARY_INTEGER;

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

6218:
6219: TYPE t_old_bld_blk_resource_type IS TABLE OF hxc_time_building_blocks.resource_type%TYPE
6220: INDEX BY BINARY_INTEGER;
6221:
6222: TYPE t_old_bld_blk_resource_id IS TABLE OF hxc_time_building_blocks.resource_id%TYPE
6223: INDEX BY BINARY_INTEGER;
6224:
6225: TYPE t_old_bld_blk_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE
6226: INDEX BY BINARY_INTEGER;

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

6221:
6222: TYPE t_old_bld_blk_resource_id IS TABLE OF hxc_time_building_blocks.resource_id%TYPE
6223: INDEX BY BINARY_INTEGER;
6224:
6225: TYPE t_old_bld_blk_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE
6226: INDEX BY BINARY_INTEGER;
6227:
6228: TYPE t_old_bld_blk_start_time IS TABLE OF hxc_time_building_blocks.start_time%TYPE
6229: INDEX BY BINARY_INTEGER;

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

6224:
6225: TYPE t_old_bld_blk_comment_text IS TABLE OF hxc_time_building_blocks.comment_text%TYPE
6226: INDEX BY BINARY_INTEGER;
6227:
6228: TYPE t_old_bld_blk_start_time IS TABLE OF hxc_time_building_blocks.start_time%TYPE
6229: INDEX BY BINARY_INTEGER;
6230:
6231: TYPE t_old_bld_blk_stop_time IS TABLE OF hxc_time_building_blocks.stop_time%TYPE
6232: INDEX BY BINARY_INTEGER;

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

6227:
6228: TYPE t_old_bld_blk_start_time IS TABLE OF hxc_time_building_blocks.start_time%TYPE
6229: INDEX BY BINARY_INTEGER;
6230:
6231: TYPE t_old_bld_blk_stop_time IS TABLE OF hxc_time_building_blocks.stop_time%TYPE
6232: INDEX BY BINARY_INTEGER;
6233:
6234: TYPE t_old_bld_blk_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE
6235: INDEX BY BINARY_INTEGER;

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

6230:
6231: TYPE t_old_bld_blk_stop_time IS TABLE OF hxc_time_building_blocks.stop_time%TYPE
6232: INDEX BY BINARY_INTEGER;
6233:
6234: TYPE t_old_bld_blk_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE
6235: INDEX BY BINARY_INTEGER;
6236:
6237: TYPE t_old_bld_blk_scope IS TABLE OF hxc_time_building_blocks.SCOPE%TYPE
6238: INDEX BY BINARY_INTEGER;

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

6233:
6234: TYPE t_old_bld_blk_measure IS TABLE OF hxc_time_building_blocks.measure%TYPE
6235: INDEX BY BINARY_INTEGER;
6236:
6237: TYPE t_old_bld_blk_scope IS TABLE OF hxc_time_building_blocks.SCOPE%TYPE
6238: INDEX BY BINARY_INTEGER;
6239:
6240: TYPE t_old_bld_blk_type IS TABLE OF hxc_time_building_blocks.TYPE%TYPE
6241: INDEX BY BINARY_INTEGER;

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

6236:
6237: TYPE t_old_bld_blk_scope IS TABLE OF hxc_time_building_blocks.SCOPE%TYPE
6238: INDEX BY BINARY_INTEGER;
6239:
6240: TYPE t_old_bld_blk_type IS TABLE OF hxc_time_building_blocks.TYPE%TYPE
6241: INDEX BY BINARY_INTEGER;
6242:
6243: TYPE t_old_bld_blk_uom IS TABLE OF hxc_time_building_blocks.unit_of_measure%TYPE
6244: INDEX BY BINARY_INTEGER;

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

6239:
6240: TYPE t_old_bld_blk_type IS TABLE OF hxc_time_building_blocks.TYPE%TYPE
6241: INDEX BY BINARY_INTEGER;
6242:
6243: TYPE t_old_bld_blk_uom IS TABLE OF hxc_time_building_blocks.unit_of_measure%TYPE
6244: INDEX BY BINARY_INTEGER;
6245:
6246: TYPE t_old_bld_blk_date_from IS TABLE OF hxc_time_building_blocks.date_from%TYPE
6247: INDEX BY BINARY_INTEGER;

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

6242:
6243: TYPE t_old_bld_blk_uom IS TABLE OF hxc_time_building_blocks.unit_of_measure%TYPE
6244: INDEX BY BINARY_INTEGER;
6245:
6246: TYPE t_old_bld_blk_date_from IS TABLE OF hxc_time_building_blocks.date_from%TYPE
6247: INDEX BY BINARY_INTEGER;
6248:
6249: TYPE t_old_bld_blk_date_to IS TABLE OF hxc_time_building_blocks.date_to%TYPE
6250: INDEX BY BINARY_INTEGER;

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

6245:
6246: TYPE t_old_bld_blk_date_from IS TABLE OF hxc_time_building_blocks.date_from%TYPE
6247: INDEX BY BINARY_INTEGER;
6248:
6249: TYPE t_old_bld_blk_date_to IS TABLE OF hxc_time_building_blocks.date_to%TYPE
6250: INDEX BY BINARY_INTEGER;
6251:
6252: TYPE t_old_bld_blk_app_status IS TABLE OF hxc_time_building_blocks.approval_status%TYPE
6253: INDEX BY BINARY_INTEGER;

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

6248:
6249: TYPE t_old_bld_blk_date_to IS TABLE OF hxc_time_building_blocks.date_to%TYPE
6250: INDEX BY BINARY_INTEGER;
6251:
6252: TYPE t_old_bld_blk_app_status IS TABLE OF hxc_time_building_blocks.approval_status%TYPE
6253: INDEX BY BINARY_INTEGER;
6254:
6255: TYPE t_old_bld_blk_app_style_id IS TABLE OF hxc_time_building_blocks.approval_style_id%TYPE
6256: INDEX BY BINARY_INTEGER;

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

6251:
6252: TYPE t_old_bld_blk_app_status IS TABLE OF hxc_time_building_blocks.approval_status%TYPE
6253: INDEX BY BINARY_INTEGER;
6254:
6255: TYPE t_old_bld_blk_app_style_id IS TABLE OF hxc_time_building_blocks.approval_style_id%TYPE
6256: INDEX BY BINARY_INTEGER;
6257:
6258: TYPE t_old_bld_blk_bb_info_type_id IS TABLE OF hxc_time_attributes.bld_blk_info_type_id%TYPE
6259: INDEX BY BINARY_INTEGER;

Line 7031: hxc_time_building_blocks timecard_block

7027: , DECODE ( timecard_block.date_to, hr_general.end_of_time, ''N'', ''Y'' ) ';
7028: l_from VARCHAR2 (200)
7029: := '
7030: FROM
7031: hxc_time_building_blocks timecard_block
7032: , hxc_time_building_blocks day_block
7033: , Hxc_time_building_blocks detail_block
7034: , Hxc_time_attribute_usages detail_usage
7035: , Hxc_time_attributes detail_att';

Line 7032: , hxc_time_building_blocks day_block

7028: l_from VARCHAR2 (200)
7029: := '
7030: FROM
7031: hxc_time_building_blocks timecard_block
7032: , hxc_time_building_blocks day_block
7033: , Hxc_time_building_blocks detail_block
7034: , Hxc_time_attribute_usages detail_usage
7035: , Hxc_time_attributes detail_att';
7036: l_inline_view_range VARCHAR2 (800)

Line 7033: , Hxc_time_building_blocks detail_block

7029: := '
7030: FROM
7031: hxc_time_building_blocks timecard_block
7032: , hxc_time_building_blocks day_block
7033: , Hxc_time_building_blocks detail_block
7034: , Hxc_time_attribute_usages detail_usage
7035: , Hxc_time_attributes detail_att';
7036: l_inline_view_range VARCHAR2 (800)
7037: := '

Line 7191: , Hxc_time_building_blocks detail_block

7187:
7188: l_noloop_from VARCHAR2 (250)
7189: := '
7190: ) tbb
7191: , Hxc_time_building_blocks detail_block
7192: , Hxc_time_attribute_usages detail_usage
7193: , Hxc_time_attributes detail_att
7194: , hxc_time_building_blocks day_block
7195: , hxc_time_building_blocks timecard_block

Line 7194: , hxc_time_building_blocks day_block

7190: ) tbb
7191: , Hxc_time_building_blocks detail_block
7192: , Hxc_time_attribute_usages detail_usage
7193: , Hxc_time_attributes detail_att
7194: , hxc_time_building_blocks day_block
7195: , hxc_time_building_blocks timecard_block
7196: , hxc_max_ovn detail_max_ovn';
7197: l_incremental_from VARCHAR2 (400)
7198: := '

Line 7195: , hxc_time_building_blocks timecard_block

7191: , Hxc_time_building_blocks detail_block
7192: , Hxc_time_attribute_usages detail_usage
7193: , Hxc_time_attributes detail_att
7194: , hxc_time_building_blocks day_block
7195: , hxc_time_building_blocks timecard_block
7196: , hxc_max_ovn detail_max_ovn';
7197: l_incremental_from VARCHAR2 (400)
7198: := '
7199: FROM

Line 7201: , Hxc_time_building_blocks detail_block

7197: l_incremental_from VARCHAR2 (400)
7198: := '
7199: FROM
7200: hxc_retrieval_range_blks tbb
7201: , Hxc_time_building_blocks detail_block
7202: , Hxc_time_attribute_usages detail_usage
7203: , Hxc_time_attributes detail_att
7204: , hxc_time_building_blocks day_block
7205: , hxc_time_building_blocks timecard_block

Line 7204: , hxc_time_building_blocks day_block

7200: hxc_retrieval_range_blks tbb
7201: , Hxc_time_building_blocks detail_block
7202: , Hxc_time_attribute_usages detail_usage
7203: , Hxc_time_attributes detail_att
7204: , hxc_time_building_blocks day_block
7205: , hxc_time_building_blocks timecard_block
7206: , hxc_latest_details hld
7207: , hxc_max_ovn detail_max_ovn';
7208: l_time VARCHAR2 (400)

Line 7205: , hxc_time_building_blocks timecard_block

7201: , Hxc_time_building_blocks detail_block
7202: , Hxc_time_attribute_usages detail_usage
7203: , Hxc_time_attributes detail_att
7204: , hxc_time_building_blocks day_block
7205: , hxc_time_building_blocks timecard_block
7206: , hxc_latest_details hld
7207: , hxc_max_ovn detail_max_ovn';
7208: l_time VARCHAR2 (400)
7209: := '

Line 7215: FROM hxc_time_building_blocks tovn

7211: timecard_block.scope = ''TIMECARD'' AND
7212: timecard_block.approval_status <> ''ERROR'' AND
7213: timecard_block.object_version_number = (
7214: SELECT /*+ no_unnest */ MAX ( tovn.object_version_number )
7215: FROM hxc_time_building_blocks tovn
7216: WHERE tovn.time_building_block_id = timecard_block.time_building_block_id ) ';
7217: -- Bug 9394444
7218: l_incremental_from_pa VARCHAR2 (400)
7219: := '

Line 7222: , Hxc_time_building_blocks detail_block

7218: l_incremental_from_pa VARCHAR2 (400)
7219: := '
7220: FROM
7221: hxc_retrieval_range_blks tbb
7222: , Hxc_time_building_blocks detail_block
7223: , Hxc_time_attribute_usages detail_usage
7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block
7226: , hxc_time_building_blocks timecard_block

Line 7225: , hxc_time_building_blocks day_block

7221: hxc_retrieval_range_blks tbb
7222: , Hxc_time_building_blocks detail_block
7223: , Hxc_time_attribute_usages detail_usage
7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block
7226: , hxc_time_building_blocks timecard_block
7227: , hxc_pa_latest_details hld
7228: , hxc_max_ovn detail_max_ovn';
7229:

Line 7226: , hxc_time_building_blocks timecard_block

7222: , Hxc_time_building_blocks detail_block
7223: , Hxc_time_attribute_usages detail_usage
7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block
7226: , hxc_time_building_blocks timecard_block
7227: , hxc_pa_latest_details hld
7228: , hxc_max_ovn detail_max_ovn';
7229:
7230: l_incremental_from_pay VARCHAR2 (400)

Line 7234: , Hxc_time_building_blocks detail_block

7230: l_incremental_from_pay VARCHAR2 (400)
7231: := '
7232: FROM
7233: hxc_retrieval_range_blks tbb
7234: , Hxc_time_building_blocks detail_block
7235: , Hxc_time_attribute_usages detail_usage
7236: , Hxc_time_attributes detail_att
7237: , hxc_time_building_blocks day_block
7238: , hxc_time_building_blocks timecard_block

Line 7237: , hxc_time_building_blocks day_block

7233: hxc_retrieval_range_blks tbb
7234: , Hxc_time_building_blocks detail_block
7235: , Hxc_time_attribute_usages detail_usage
7236: , Hxc_time_attributes detail_att
7237: , hxc_time_building_blocks day_block
7238: , hxc_time_building_blocks timecard_block
7239: , hxc_pay_latest_details hld
7240: , hxc_max_ovn detail_max_ovn';
7241:

Line 7238: , hxc_time_building_blocks timecard_block

7234: , Hxc_time_building_blocks detail_block
7235: , Hxc_time_attribute_usages detail_usage
7236: , Hxc_time_attributes detail_att
7237: , hxc_time_building_blocks day_block
7238: , hxc_time_building_blocks timecard_block
7239: , hxc_pay_latest_details hld
7240: , hxc_max_ovn detail_max_ovn';
7241:
7242:

Line 7251: FROM hxc_time_building_blocks tovn

7247: timecard_block.scope = ''TIMECARD'' AND
7248: timecard_block.approval_status <> ''ERROR'' AND
7249: timecard_block.object_version_number = (
7250: SELECT /*+ no_unnest */ MAX ( tovn.object_version_number )
7251: FROM hxc_time_building_blocks tovn
7252: WHERE tovn.time_building_block_id = timecard_block.time_building_block_id )
7253: AND
7254: timecard_block.start_time
7255: BETWEEN :p_start_date AND :p_end_date AND

Line 7265: FROM hxc_time_building_blocks tovn

7261: timecard_block.scope = ''TIMECARD'' AND
7262: timecard_block.approval_status <> ''ERROR'' AND
7263: timecard_block.object_version_number = (
7264: SELECT /*+ no_unnest */ MAX ( tovn.object_version_number )
7265: FROM hxc_time_building_blocks tovn
7266: WHERE tovn.time_building_block_id = timecard_block.time_building_block_id )
7267: AND
7268: :p_start_date <= timecard_block.stop_time AND
7269: :p_end_date >= timecard_block.start_time ';

Line 7279: FROM hxc_time_building_blocks dyovn

7275: day_block.scope = ''DAY'' AND
7276: day_block.approval_status <> ''ERROR'' AND
7277: day_block.object_version_number = (
7278: SELECT /*+ no_unnest */ MAX ( dyovn.object_version_number )
7279: FROM hxc_time_building_blocks dyovn
7280: WHERE dyovn.time_building_block_id = day_block.time_building_block_id ) ';
7281: l_detail VARCHAR2 (350)
7282: := '
7283: AND

Line 7307: , hxc_time_building_blocks detail_block

7303: := '
7304: FROM
7305: hxc_time_attributes detail_att
7306: , hxc_time_attribute_usages detail_usage
7307: , hxc_time_building_blocks detail_block
7308: , hxc_time_building_blocks day_block
7309: , hxc_time_attributes timecard_att
7310: , hxc_transaction_details txd
7311: , hxc_transactions tx

Line 7308: , hxc_time_building_blocks day_block

7304: FROM
7305: hxc_time_attributes detail_att
7306: , hxc_time_attribute_usages detail_usage
7307: , hxc_time_building_blocks detail_block
7308: , hxc_time_building_blocks day_block
7309: , hxc_time_attributes timecard_att
7310: , hxc_transaction_details txd
7311: , hxc_transactions tx
7312: WHERE

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

7381:
7382: --Elp changes sonarasi 14-Mar-2003
7383: --A string of application set ids like (1,2,3,5) etc are obtained for the corresponding time
7384: --recipient id of the application. As per ELP changes, the Application Set Id for the detail,
7385: --day and timecard scopes are added in hxc_time_building_blocks table. Here we retrieve only
7386: --blocks that the Retrieval Application is interested in. So we just add to the where clause
7387: --to compare if the detail building block's application set id is within the list of
7388: --application set ids generated for the corresponding time recipient.
7389: l_app_set :=