APPS.CZ_QC_MGR dependencies on CZ_CONFIG_HDRS

Line 60: FROM CZ_CONFIG_HDRS WHERE deleted_flag='1';

56: BEGIN
57:
58: SELECT config_hdr_id,config_rev_nbr
59: BULK COLLECT INTO t_cfg_id,t_cfg_nbr
60: FROM CZ_CONFIG_HDRS WHERE deleted_flag='1';
61:
62: IF t_cfg_id.Count>0 THEN
63:
64: FORALL i IN t_cfg_id.First..t_cfg_id.Last

Line 116: FROM cz_config_hdrs

112: l_log_return_value BOOLEAN;
113: PurgeDeleteConfigBatchsize NUMBER;
114: CURSOR cur_configs IS
115: SELECT config_hdr_id, config_rev_nbr
116: FROM cz_config_hdrs
117: WHERE (to_be_deleted_flag = '1'
118: OR deleted_flag = '1') and
119: component_instance_type = 'R';
120: BEGIN