APPS.HXC_DEPOSIT_CHECKS dependencies on HXC_TEMPLATE_SUMMARY

Line 52: select TEMPLATE_TYPE from hxc_template_summary

48: ,p_messages in out nocopy hxc_message_table_type) is
49:
50: cursor c_template_details
51: (p_id in hxc_time_building_blocks.time_building_block_id%type) is
52: select TEMPLATE_TYPE from hxc_template_summary
53: where template_id = p_id;
54:
55: l_exists VARCHAR2(6);
56: l_template_type hxc_template_summary.template_type%type;

Line 56: l_template_type hxc_template_summary.template_type%type;

52: select TEMPLATE_TYPE from hxc_template_summary
53: where template_id = p_id;
54:
55: l_exists VARCHAR2(6);
56: l_template_type hxc_template_summary.template_type%type;
57: l_attached_public_temp_grps varchar2(1500);
58: l_pref_value VARCHAR2(170);
59:
60: Begin