APPS.HXC_HPH_BUS dependencies on DUAL

Line 466: FROM sys.dual

462: -- cursor to check that a duplicate child pref hierarchy name is not entered
463: --
464: CURSOR csr_chk_name IS
465: SELECT 'error'
466: FROM sys.dual
467: WHERE EXISTS (
468: SELECT 'x'
469: FROM hxc_pref_hierarchies hph
470: WHERE upper(hph.name) = upper(p_name)

Line 746: FROM sys.dual

742: --
743:
744: CURSOR csr_chk_code IS
745: SELECT 'error'
746: FROM sys.dual
747: WHERE EXISTS (
748: SELECT 'x'
749: FROM hxc_pref_hierarchies hph
750: WHERE hph.attribute_category = p_pref_code

Line 757: FROM sys.dual

753: CONNECT BY PRIOR hph.pref_hierarchy_id = hph.parent_pref_hierarchy_id);
754:
755: CURSOR csr_chk_code2 IS
756: SELECT 'error'
757: FROM sys.dual
758: WHERE EXISTS (
759: SELECT 'x'
760: FROM hxc_pref_hierarchies hph
761: WHERE hph.attribute_category is not null

Line 856: FROM sys.dual

852: -- cursor to check that a duplicate top node name is not entered
853: --
854: CURSOR csr_chk_top_node IS
855: SELECT 'error'
856: FROM sys.dual
857: WHERE EXISTS (
858: SELECT 'x'
859: FROM hxc_pref_hierarchies hph
860: WHERE hph.name = p_name

Line 937: FROM sys.dual

933: -- single hierarchy
934: --
935: CURSOR csr_chk_preference IS
936: SELECT 'error'
937: FROM sys.dual
938: WHERE EXISTS (
939: SELECT 'x'
940: FROM hxc_pref_hierarchies hph
941: WHERE hph.pref_definition_id = p_pref_definition_id