DBA Data[Home] [Help]

APPS.CZ_IB_LOCKING dependencies on CZ_CONFIG_HDRS

Line 18: -- check CZ_CONFIG_HDRS

14:
15: BEGIN
16: IF p_config_session_item_id IS NULL THEN
17: -- if p_config_session_item_id is not specified then
18: -- check CZ_CONFIG_HDRS
19: FOR i IN(SELECT 'x' FROM CZ_CONFIG_HDRS
20: WHERE config_hdr_id=p_config_session_hdr_id AND
21: config_rev_nbr=p_config_session_rev_nbr AND
22: component_instance_type='R' AND

Line 19: FOR i IN(SELECT 'x' FROM CZ_CONFIG_HDRS

15: BEGIN
16: IF p_config_session_item_id IS NULL THEN
17: -- if p_config_session_item_id is not specified then
18: -- check CZ_CONFIG_HDRS
19: FOR i IN(SELECT 'x' FROM CZ_CONFIG_HDRS
20: WHERE config_hdr_id=p_config_session_hdr_id AND
21: config_rev_nbr=p_config_session_rev_nbr AND
22: component_instance_type='R' AND
23: deleted_flag='0')