APPS.HR_LEGISLATION dependencies on HR_LEGISLATION_SUBGROUPS

Line 2157: from hr_legislation_subgroups d

2153: or
2154: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
2155: and exists (
2156: select null
2157: from hr_legislation_subgroups d
2158: where d.legislation_code = stu_rec.c_leg_code
2159: and d.legislation_subgroup = stu_rec.c_leg_sgrp
2160: and d.active_inactive_flag = 'A' );
2161: end if;

Line 3086: from hr_legislation_subgroups d

3082: or
3083: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
3084: and exists (
3085: select null
3086: from hr_legislation_subgroups d
3087: where d.legislation_code = stu_rec.c_leg_code
3088: and d.legislation_subgroup = stu_rec.c_leg_sgrp
3089: and d.active_inactive_flag = 'A' );
3090: end if;

Line 5076: from hr_legislation_subgroups d

5072: or
5073: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
5074: and exists (
5075: select null
5076: from hr_legislation_subgroups d
5077: where d.legislation_code = r_distinct.legislation_code
5078: and d.legislation_subgroup = r_distinct.legislation_subgroup
5079: and d.active_inactive_flag = 'A'
5080: );