DBA Data[Home] [Help]

APPS.HXC_PUBLIC_TEMP_GROUP_COMP_API dependencies on DUAL

Line 29: FROM dual

25: )
26: IS
27: CURSOR csr_group_name_exists IS
28: SELECT 'error'
29: FROM dual
30: WHERE EXISTS (
31: SELECT 'x'
32: FROM hxc_entity_groups heg
33: WHERE heg.name = p_name

Line 107: FROM dual

103: l_attribute30 HXC_ENTITY_GROUP_COMPS.ATTRIBUTE30%TYPE;
104:
105: CURSOR csr_entity_comp_exists IS
106: SELECT 'error'
107: FROM dual
108: WHERE EXISTS (
109: SELECT 'x'
110: FROM hxc_entity_group_comps egc
111: WHERE egc.entity_group_id = p_entity_group_id

Line 117: FROM dual

113: AND egc.entity_id = p_entity_id );
114:
115: CURSOR csr_exists_dynamic_comps IS
116: SELECT 'error'
117: FROM dual
118: WHERE EXISTS (
119: SELECT 'x'
120: FROM hxc_entity_group_comps egc
121: WHERE egc.entity_group_id = p_entity_group_id

Line 341: FROM dual

337: entity_group_id = p_entity_group_id;
338:
339: CURSOR csr_exist_template_name(l_business_group_id in HXC_ENTITY_GROUPS.LEGISLATION_CODE%TYPE) IS
340: SELECT 'error'
341: FROM dual
342: WHERE EXISTS (
343: SELECT 'x'
344: FROM hxc_entity_groups heg
345: WHERE heg.name = p_name