APPS.JTF_DSPMGRVALIDATION_GRP dependencies on JTF_DSP_SECTIONS_B

Line 586: select section_id from jtf_dsp_sections_b where

582: l_api_name CONSTANT VARCHAR2(40) := 'check_section_exists';
583:
584: CURSOR section_cur( p_section_id IN NUMBER ) IS
585: SELECT 1 from dual where exists (
586: select section_id from jtf_dsp_sections_b where
587: section_id = p_section_id);
588: l_exists NUMBER;
589: l_return_status boolean := false;
590:

Line 631: select section_id from jtf_dsp_sections_b where

627: l_api_name CONSTANT VARCHAR2(40) := 'check_root_section_exists';
628:
629: CURSOR section_cur( p_section_id IN NUMBER ) IS
630: SELECT 1 from dual where exists (
631: select section_id from jtf_dsp_sections_b where
632: section_id = p_section_id );
633: l_exists NUMBER;
634: l_return_status boolean := false;
635: BEGIN