APPS.HXC_MAPPING_UTILITIES dependencies on HXC_TIME_ATTRIBUTES

Line 730: , hxc_time_attributes ta

726: , 'X' dummy2
727: , 'X' process
728: FROM
729: hxc_time_building_blocks bb
730: , hxc_time_attributes ta
731: , hxc_time_attribute_usages tau
732: , hxc_bld_blk_info_types bbit
733: WHERE
734: bb.time_building_block_id = p_bb_id AND

Line 814: hxc_time_attributes ta

810: , 'X'
811: , 'X'
812: , 'X'
813: FROM
814: hxc_time_attributes ta
815: , hxc_time_attribute_usages tau
816: , hxc_time_building_blocks bb
817: , hxc_bld_blk_info_types bbit
818: WHERE

Line 1905: -- returns the name of the attribute column in HXC_TIME_ATTRIBUTES which

1901: -- function
1902: -- attribute_column
1903: --
1904: -- description
1905: -- returns the name of the attribute column in HXC_TIME_ATTRIBUTES which
1906: -- maps to the parameter p_field_name, based on the building block
1907: -- category and information type
1908: --
1909: -- parameters

Line 1961: -- attribute column in HXC_TIME_ATTRIBUTES which maps to the parameter

1957: -- attribute_column
1958: --
1959: -- description
1960: -- overload of attribute_column function. returns the name of the
1961: -- attribute column in HXC_TIME_ATTRIBUTES which maps to the parameter
1962: -- p_field_name, based on the deposit or retrieval process identifier.
1963: -- since there is no guarantee that mappings have been explicitly defined
1964: -- for the given process, the column name is returned in an out parameter,
1965: -- and the function returns true or false depending on whether a mapping

Line 2395: hxc_time_attributes ta1

2391: select /*+ LEADING(ta1) INDEX(ta1)
2392: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2393: tau1.time_building_block_id,tau1.time_building_block_ovn from
2394: hxc_time_attribute_usages tau1,
2395: hxc_time_attributes ta1
2396: where tau1.time_building_block_id = tbb.time_building_block_id
2397: AND tau1.time_building_block_ovn = tbb.object_version_number
2398: AND tau1.time_attribute_id = ta1.time_attribute_id
2399: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||

Line 2411: hxc_time_attributes ta1

2407: select /*+ LEADING(ta1) INDEX(ta1)
2408: INDEX(tau1 HXC_TIME_ATTRIBUTE_USAGES_FK1) */
2409: tau1.time_building_block_id,tau1.time_building_block_ovn from
2410: hxc_time_attribute_usages tau1,
2411: hxc_time_attributes ta1
2412: where tau1.time_building_block_id = tbb.time_building_block_id
2413: AND tau1.time_building_block_ovn = tbb.object_version_number
2414: AND tau1.time_attribute_id = ta1.time_attribute_id
2415: AND ta1.bld_blk_info_type_id = '||l_bld_block_info_id_outer||

Line 2961: from hxc_time_attributes ta,

2957: -- build dynamic SQL query
2958:
2959: l_query := '
2960: select sum(ta.'||l_segment1||')
2961: from hxc_time_attributes ta,
2962: hxc_time_attribute_usages tau,
2963: hxc_time_building_blocks tbb
2964: where
2965: tbb.scope = :p_scope

Line 2994: hxc_time_attributes ta2

2990:
2991: if(l_field_value_outer is not null) then
2992:
2993: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,
2994: hxc_time_attributes ta2
2995: where tau2.time_building_block_id = tbb.time_building_block_id
2996: AND tau2.time_building_block_ovn = tbb.object_version_number
2997: AND tau2.time_attribute_id = ta2.time_attribute_id
2998: AND ta2.bld_blk_info_type_id = '||l_bld_block_info_id_outer||

Line 3006: hxc_time_attributes ta2

3002: else
3003:
3004:
3005: l_field_value:= l_field_value||' AND EXISTS ( select 1 from hxc_time_attribute_usages tau2,
3006: hxc_time_attributes ta2
3007: where tau2.time_building_block_id = tbb.time_building_block_id
3008: AND tau2.time_building_block_ovn = tbb.object_version_number
3009: AND tau2.time_attribute_id = ta2.time_attribute_id
3010: AND ta2.bld_blk_info_type_id = '||l_bld_block_info_id_outer||