DBA Data[Home] [Help]

APPS.HXC_TIMECARD_VALIDATION dependencies on HXC_TEMPLATE_SUMMARY

Line 383: from hxc_template_summary

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

Line 394: from hxc_template_summary

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