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 804: hxc_time_attribute_usages hau,

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

Line 944: -- hxc_time_attribute_usages hau,

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

Line 1284: hxc_time_attribute_usages hau,

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

Line 1421: -- hxc_time_attribute_usages hau,

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