APPS.HXC_TIMECARD_VALIDATION dependencies on HXC_TEMPLATE_SUMMARY

Line 381: from hxc_template_summary

377: p_resoure_id in number,
378: p_time_building_block_id in number
379: ) is
380: select 'Y'
381: from hxc_template_summary
382: where template_type = 'PRIVATE'
383: and template_id <> p_time_building_block_id
384: and template_name = p_name_to_check
385: and resource_id = p_resource_id;

Line 392: from hxc_template_summary

388: (p_name_to_check in varchar2,
389: p_time_building_block_id in number,
390: p_business_group_id in varchar2) is
391: select 'Y'
392: from hxc_template_summary
393: where template_type = 'PUBLIC'
394: and template_id <> p_time_building_block_id
395: and template_name = p_name_to_check
396: and business_group_id =p_business_group_id ;