APPS.XNP_MSG_SCHEMA dependencies on XNP_MSG_STRUCTURES

Line 35: FROM xnp_msg_elements met, xnp_msg_structures mse

31: met.parameter_flag,
32: mse.data_source,
33: mse.data_source_type,
34: mse.data_source_reference
35: FROM xnp_msg_elements met, xnp_msg_structures mse
36: WHERE met.msg_code = mse.msg_code
37: AND met.msg_code = p_msg_code
38: -- skilaru 03/27/2001
39: -- AND met.msg_element_id IN( mse.child_element_id);

Line 316: --SELECT * FROM xnp_msg_structures

312: IS
313:
314: CURSOR get_parent IS
315: --skilaru 03/27/2001
316: --SELECT * FROM xnp_msg_structures
317: SELECT 'Y' FROM xnp_msg_structures
318: WHERE parent_element_id = p_element_id ;
319: --skilaru 03/27/2001
320: --l_row xnp_msg_structures%ROWTYPE ;

Line 317: SELECT 'Y' FROM xnp_msg_structures

313:
314: CURSOR get_parent IS
315: --skilaru 03/27/2001
316: --SELECT * FROM xnp_msg_structures
317: SELECT 'Y' FROM xnp_msg_structures
318: WHERE parent_element_id = p_element_id ;
319: --skilaru 03/27/2001
320: --l_row xnp_msg_structures%ROWTYPE ;
321: l_row VARCHAR2(1) ;

Line 320: --l_row xnp_msg_structures%ROWTYPE ;

316: --SELECT * FROM xnp_msg_structures
317: SELECT 'Y' FROM xnp_msg_structures
318: WHERE parent_element_id = p_element_id ;
319: --skilaru 03/27/2001
320: --l_row xnp_msg_structures%ROWTYPE ;
321: l_row VARCHAR2(1) ;
322:
323: BEGIN
324: