APPS.HR_LEGISLATION_BENEFITS dependencies on HR_LEGISLATION_SUBGROUPS

Line 422: from hr_legislation_subgroups d

418: or
419: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
420: and exists (
421: select null
422: from hr_legislation_subgroups d
423: where d.legislation_code = r_distinct.c_leg_code
424: and d.legislation_subgroup = r_distinct.c_leg_sgrp
425: and d.active_inactive_flag = 'A' );
426: end if;