APPS.HXC_DEPOSIT_CHECKS dependencies on HXC_TEMPLATE_SUMMARY

Line 55: select TEMPLATE_TYPE from hxc_template_summary

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

Line 59: l_template_type hxc_template_summary.template_type%type;

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