[Home] [Help]
APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_TIME_CATEGORY_COMPS2
Line 3060: hxc_time_category_comps2 tcc
3056: IS SELECT /*+ LEADING(tmp)
3057: INDEX(tcc HXC_HTCC2_FK1) */
3058: DISTINCT time_category_id
3059: FROM hxc_tmp_atts tmp,
3060: hxc_time_category_comps2 tcc
3061: WHERE tmp.bld_blk_info_type_id = tcc.bld_blk_info_type_id
3062: AND tmp.attribute_category = tcc.attribute_category
3063: AND tmp.attribute1 = tcc.attribute1
3064: AND (tmp.attribute2 = tcc.attribute2