APPS.CZ_SECURITY_PVT dependencies on CZ_UI_REFS

Line 801: FROM cz_ui_refs

797: SELECT ref_ui_def_id
798: BULK
799: COLLECT
800: INTO x_locked_entities
801: FROM cz_ui_refs
802: WHERE cz_ui_refs.ui_def_id = p_entity_id
803: AND cz_ui_refs.deleted_flag = '0'
804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
805: FROM cz_ui_defs

Line 802: WHERE cz_ui_refs.ui_def_id = p_entity_id

798: BULK
799: COLLECT
800: INTO x_locked_entities
801: FROM cz_ui_refs
802: WHERE cz_ui_refs.ui_def_id = p_entity_id
803: AND cz_ui_refs.deleted_flag = '0'
804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
805: FROM cz_ui_defs
806: WHERE cz_ui_defs.deleted_flag = '0'

Line 803: AND cz_ui_refs.deleted_flag = '0'

799: COLLECT
800: INTO x_locked_entities
801: FROM cz_ui_refs
802: WHERE cz_ui_refs.ui_def_id = p_entity_id
803: AND cz_ui_refs.deleted_flag = '0'
804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
805: FROM cz_ui_defs
806: WHERE cz_ui_defs.deleted_flag = '0'
807: AND cz_ui_defs.ui_style = '7');

Line 804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id

800: INTO x_locked_entities
801: FROM cz_ui_refs
802: WHERE cz_ui_refs.ui_def_id = p_entity_id
803: AND cz_ui_refs.deleted_flag = '0'
804: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
805: FROM cz_ui_defs
806: WHERE cz_ui_defs.deleted_flag = '0'
807: AND cz_ui_defs.ui_style = '7');
808: EXCEPTION

Line 932: FROM cz_ui_refs

928: SELECT ref_ui_def_id
929: BULK
930: COLLECT
931: INTO l_locked_entities
932: FROM cz_ui_refs
933: WHERE cz_ui_refs.ui_def_id = p_entity_id
934: AND cz_ui_refs.deleted_flag = '0'
935: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
936: FROM cz_ui_defs x

Line 933: WHERE cz_ui_refs.ui_def_id = p_entity_id

929: BULK
930: COLLECT
931: INTO l_locked_entities
932: FROM cz_ui_refs
933: WHERE cz_ui_refs.ui_def_id = p_entity_id
934: AND cz_ui_refs.deleted_flag = '0'
935: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
936: FROM cz_ui_defs x
937: WHERE x.deleted_flag = '0'

Line 934: AND cz_ui_refs.deleted_flag = '0'

930: COLLECT
931: INTO l_locked_entities
932: FROM cz_ui_refs
933: WHERE cz_ui_refs.ui_def_id = p_entity_id
934: AND cz_ui_refs.deleted_flag = '0'
935: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
936: FROM cz_ui_defs x
937: WHERE x.deleted_flag = '0'
938: AND x.checkout_user IS NOT NULL

Line 935: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id

931: INTO l_locked_entities
932: FROM cz_ui_refs
933: WHERE cz_ui_refs.ui_def_id = p_entity_id
934: AND cz_ui_refs.deleted_flag = '0'
935: AND cz_ui_refs.ref_ui_def_id IN (SELECT ui_def_id
936: FROM cz_ui_defs x
937: WHERE x.deleted_flag = '0'
938: AND x.checkout_user IS NOT NULL
939: AND x.ui_style = '7');