APPS.PSP_REPORT_TEMPLATE_API dependencies on PSP_REPORT_TEMPLATES

Line 48: l_template_name Psp_Report_Templates.TEMPLATE_NAME%TYPE;

44: -- l_in_out_parameter number;
45: -- l_effective_date date;
46: l_proc varchar2(72) := g_package||'Create_Report_Template';
47:
48: l_template_name Psp_Report_Templates.TEMPLATE_NAME%TYPE;
49:
50: --
51: -- cursor to check Duplicate TEMPLATE NAME
52: --

Line 57: from Psp_Report_Templates

53:
54: cursor c_template_name
55: is
56: select distinct Template_Name
57: from Psp_Report_Templates
58: where Template_Name = P_TEMPLATE_NAME
59: and report_type = p_report_type ;
60:
61: --