APPS.OTA_TPC_UTIL dependencies on HR_SUMMARY_ITEM_TYPE_USAGE

Line 20: l_template_id hr_summary_item_type_usage.template_id%type;

16: p_to_currency in varchar2,
17: p_payroll_id in number)
18: return number
19: is
20: l_template_id hr_summary_item_type_usage.template_id%type;
21: l_prmrec hr_summary_util.prmtabtype;
22: l_statement varchar2(32000);
23: l_result ota_training_plan_costs.amount%type;
24: l_dyn_curs integer;

Line 28: from hr_summary_item_type_usage

24: l_dyn_curs integer;
25: l_dyn_rows integer;
26: begin
27: select template_id into l_template_id
28: from hr_summary_item_type_usage
29: where item_type_usage_id = p_item_type_usage_id;
30: --
31: l_prmrec(1).name := 'P_BUSINESS_GROUP_ID';
32: l_prmrec(1).value := p_business_group_id;