APPS.HR_LEGISLATION dependencies on HR_LEGISLATION_SUBGROUPS

Line 1940: from hr_legislation_subgroups d

1936: or
1937: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
1938: and exists (
1939: select null
1940: from hr_legislation_subgroups d
1941: where d.legislation_code = stu_rec.c_leg_code
1942: and d.legislation_subgroup = stu_rec.c_leg_sgrp
1943: and d.active_inactive_flag = 'A' );
1944: end if;

Line 2840: from hr_legislation_subgroups d

2836: or
2837: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
2838: and exists (
2839: select null
2840: from hr_legislation_subgroups d
2841: where d.legislation_code = stu_rec.c_leg_code
2842: and d.legislation_subgroup = stu_rec.c_leg_sgrp
2843: and d.active_inactive_flag = 'A' );
2844: end if;

Line 4826: from hr_legislation_subgroups d

4822: or
4823: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
4824: and exists (
4825: select null
4826: from hr_legislation_subgroups d
4827: where d.legislation_code = r_distinct.legislation_code
4828: and d.legislation_subgroup = r_distinct.legislation_subgroup
4829: and d.active_inactive_flag = 'A'
4830: );