APPS.HXC_RPT_LOAD_TC_SNAPSHOT dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 392: INDEX(hau HXC_TIME_ATTRIBUTE_USAGES_FK2)

388: AS
389:
390: CURSOR get_layout_ids
391: IS SELECT /*+ LEADING(gt)
392: INDEX(hau HXC_TIME_ATTRIBUTE_USAGES_FK2)
393: INDEX(ha HXC_TIME_ATTRIBUTES_PK) */
394: gt.tc_bb_id,
395: ha.attribute1
396: FROM hxc_rpt_tc_resource_temp gt,

Line 397: hxc_time_attribute_usages hau,

393: INDEX(ha HXC_TIME_ATTRIBUTES_PK) */
394: gt.tc_bb_id,
395: ha.attribute1
396: FROM hxc_rpt_tc_resource_temp gt,
397: hxc_time_attribute_usages hau,
398: hxc_time_attributes ha
399: WHERE gt.tc_bb_id = hau.time_building_block_id
400: AND hau.time_building_block_ovn = 1
401: AND hau.time_attribute_id = ha.time_attribute_id

Line 410: -- Join HXC_RPT_TC_RESOURCE_TEMP, HXC_TIME_ATTRIBUTE_USAGES, and

406:
407: BEGIN
408:
409: -- Public Procedure update_layout_ids
410: -- Join HXC_RPT_TC_RESOURCE_TEMP, HXC_TIME_ATTRIBUTE_USAGES, and
411: -- HXC_TIME_ATTRIBUTES to pick out Attribute1 from
412: -- LAYOUT Attribute_categroy. -- This is the layout_id.
413: -- Update HXC_RPT_TC_RESOURCE_TEMP with the corresponding layout_id
414: -- for each of the timecard records.

Line 806: hxc_time_attribute_usages hau,

802: dynamic_cursor_where VARCHAR2(2000);
803: l_dynamic_cursor_where VARCHAR2(2000) := '
804: FROM hxc_rpt_tc_resource_temp gt,
805: hxc_rpt_tc_details_all det,
806: hxc_time_attribute_usages hau,
807: hxc_time_attributes ha
808: WHERE gt.tc_bb_id = det.tc_bb_id
809: AND gt.layout_id = curr_layout_id
810: AND gt.request_id = det.request_id

Line 946: -- hxc_time_attribute_usages hau,

942: -- MAX(DECODE(ATTRIBUTE_CATEGORY,'APPROVAL',ha.Attribute10))
943: -- ,MAX(DECODE(ATTRIBUTE_CATEGORY,'Dummy Cost Context',ha.Attribute1))
944: -- FROM hxc_rpt_tc_resource_temp gt,
945: -- hxc_rpt_tc_details_all det,
946: -- hxc_time_attribute_usages hau,
947: -- hxc_time_attributes ha
948: -- WHERE gt.tc_bb_id = det.tc_bb_id
949: -- AND gt.layout_id = 7
950: -- AND gt.request_id = det.request_id

Line 1286: hxc_time_attribute_usages hau,

1282: l_dynamic_where VARCHAR2(2000) :=
1283: ' '' ''
1284: FROM hxc_rpt_tc_details_all det,
1285: hxc_rpt_tc_resource_temp gt,
1286: hxc_time_attribute_usages hau,
1287: hxc_time_attributes ha
1288: WHERE gt.tc_bb_id = det.tc_bb_id
1289: AND gt.layout_id = curr_layout_id
1290: AND gt.alias_definition_id = curr_alias_id

Line 1423: -- hxc_time_attribute_usages hau,

1419: -- MAX(DECODE(bld_blk_info_type_id,201,ha.ATTRIBUTE1)),
1420: -- ' '
1421: -- FROM hxc_rpt_tc_details_all det,
1422: -- hxc_rpt_tc_resource_temp gt,
1423: -- hxc_time_attribute_usages hau,
1424: -- hxc_time_attributes ha
1425: -- WHERE gt.tc_bb_id = det.tc_bb_id
1426: -- AND gt.layout_id = 7
1427: -- AND gt.request_id = det.request_id