APPS.ZX_CONDITIONS_PKG dependencies on ZX_CONDITION_GROUPS_B

Line 168: FROM zx_condition_groups_b a, zx_conditions b

164: -- repeating the query under two clauses to do complete index scan on ZX_CONDITIONS_N1
165: IF p_det_factor_cq_code IS NULL THEN
166: SELECT a.condition_group_code
167: INTO x_condition_group_code
168: FROM zx_condition_groups_b a, zx_conditions b
169: WHERE a.det_factor_templ_code = p_det_factor_templ_code
170: AND a.condition_group_id <> p_condition_group_id
171: AND b.condition_id <> p_condition_id
172: AND b.condition_group_code = a.condition_group_code

Line 187: FROM zx_condition_groups_b a, zx_conditions b

183: AND rownum = 1;
184: ELSE
185: SELECT a.condition_group_code
186: INTO x_condition_group_code
187: FROM zx_condition_groups_b a, zx_conditions b
188: WHERE a.det_factor_templ_code = p_det_factor_templ_code
189: AND a.condition_group_id <> p_condition_group_id
190: AND b.condition_id <> p_condition_id
191: AND b.condition_group_code = a.condition_group_code