60: , it.name it_name
61: , itu.name itu_name
62: , itu.ITEM_TYPE_USAGE_ID
63: , itu.ITEM_TYPE_ID
64: from hr_summary_item_type_usage itu
65: , hr_summary_item_type it
66: where itu.template_id = p_template_id
67: and itu.ITEM_TYPE_ID = it.ITEM_TYPE_ID
68: and nvl(p_item_type_usage_id,item_type_usage_id) = item_type_usage_id
525: , it.name it_name
526: , itu.name itu_name
527: , itu.ITEM_TYPE_USAGE_ID
528: , itu.ITEM_TYPE_ID
529: from hr_summary_item_type_usage itu
530: , hr_summary_item_type it
531: where itu.template_id = p_template_id
532: and itu.ITEM_TYPE_ID = it.ITEM_TYPE_ID
533: and nvl(p_item_type_usage_id,item_type_usage_id) = item_type_usage_id