APPS.HR_COPY_GSP dependencies on HR_SUMMARY_ITEM_TYPE

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

Line 224: from hr_summary_item_type

220: datatype,
221: count_clause1,
222: count_clause2,
223: where_clause
224: from hr_summary_item_type
225: where item_type_id = p_item_type_id;
226: --
227: cursor csr_vr is
228: select restriction_type_id