APPS.JTF_DSPMGRVALIDATION_GRP dependencies on JTF_DSP_LGL_PHYS_MAP

Line 1105: -- 1. Returns true if lgl_phys_map_id (JTF_DSP_LGL_PHYS_MAP) exists

1101:
1102: ----------------------------------------------------------------------------------------
1103: -----------------------------------------------------------------
1104: -- NOTES
1105: -- 1. Returns true if lgl_phys_map_id (JTF_DSP_LGL_PHYS_MAP) exists
1106: -- 2. If not , message JTF_DSP_PHYSMAP_NOT_EXISTS is pushed on the stack
1107: ---------------------------------------------------------------------
1108: FUNCTION check_physicalmap_exists(p_lgl_phys_map_id IN NUMBER)
1109: RETURN boolean

Line 1117: SELECT lgl_phys_map_id FROM JTF_DSP_LGL_PHYS_MAP

1113: l_exists NUMBER;
1114:
1115: CURSOR lgl_phys_map_cur( p_lgl_phys_map_id IN NUMBER ) IS
1116: SELECT 1 from dual where exists (
1117: SELECT lgl_phys_map_id FROM JTF_DSP_LGL_PHYS_MAP
1118: where lgl_phys_map_id = p_lgl_phys_map_id);
1119:
1120: l_map_not_exists_exception EXCEPTION;
1121:

Line 1596: SELECT attachment_id FROM JTF_DSP_LGL_PHYS_MAP

1592: l_api_name CONSTANT VARCHAR2(40) := 'check_default_attachment';
1593:
1594: CURSOR physmap_cur(p_attachment_id IN NUMBER) IS
1595: SELECT 1 FROM DUAL WHERE EXISTS (
1596: SELECT attachment_id FROM JTF_DSP_LGL_PHYS_MAP
1597: WHERE attachment_id = p_attachment_id
1598: AND default_site = 'Y'
1599: AND default_language = 'Y');
1600: