178: or ( pud.legislation_code is null
179: and ( nvl(pud.legislatively_enabled, 'N') = 'N'
180: or ( nvl(pud.legislatively_enabled, 'N') = 'Y'
181: and exists (select ''
182: from pay_upgrade_legislations pul
183: where pul.upgrade_definition_id
184: = pud.upgrade_definition_id
185: and pul.legislation_code = p_legislation
186: )
197: and ( pud.legislation_code = p_legislation
198: or ( pud.legislation_code is null
199: and nvl(pud.legislatively_enabled, 'N') = 'Y'
200: and exists (select ''
201: from pay_upgrade_legislations pul
202: where pul.upgrade_definition_id
203: = pud.upgrade_definition_id
204: and pul.legislation_code = p_legislation
205: )