APPS.HR_COPY_GSP dependencies on HR_SUMMARY_ITEM_TYPE_USAGE

Line 16: from hr_summary_item_type_usage

12: select item_type_id,
13: item_type_usage_id,
14: sequence_number,
15: name
16: from hr_summary_item_type_usage
17: where template_id = p_template_id
18: order by sequence_number;
19: --
20: cursor csr_ktu (p_itu_id in number) is

Line 116: from hr_summary_item_type_usage

112: p_copy_kt in varchar2) is
113: --
114: cursor csr_itu is
115: select item_type_id
116: from hr_summary_item_type_usage
117: where item_type_usage_id = p_itu_id;
118: --
119: cursor csr_seq is
120: select nvl(max(sequence_number),0)+1

Line 121: from hr_summary_item_type_usage

117: where item_type_usage_id = p_itu_id;
118: --
119: cursor csr_seq is
120: select nvl(max(sequence_number),0)+1
121: from hr_summary_item_type_usage
122: where template_id = p_template_id;
123: --
124: cursor csr_ktu (p_itu_id in number) is
125: select valid_key_type_id