APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_LEGISLATION_SUBGROUPS

Line 403: and exists (select null from hr_legislation_subgroups d

399: and c.application_id = b.application_id
400: and ((b.status = 'I' and c.application_short_name <> 'PQP')
401: or
402: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
403: and exists (select null from hr_legislation_subgroups d
404: where d.legislation_code = stu_rec.c_leg_code
405: and d.legislation_subgroup = stu_rec.c_leg_sgrp
406: and d.active_inactive_flag = 'A'
407: );

Line 1842: from hr_legislation_subgroups d

1838: or
1839: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
1840: and exists
1841: (select null
1842: from hr_legislation_subgroups d
1843: where d.legislation_code = r_distinct.legislation_code
1844: and d.legislation_subgroup =
1845: r_distinct.legislation_subgroup
1846: and d.active_inactive_flag = 'A'

Line 3561: and exists (select null from hr_legislation_subgroups d

3557: and c.application_id = b.application_id
3558: and ((b.status = 'I' and c.application_short_name <> 'PQP')
3559: or
3560: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
3561: and exists (select null from hr_legislation_subgroups d
3562: where d.legislation_code = stu_rec.c_leg_code
3563: and d.legislation_subgroup = stu_rec.c_leg_sgrp
3564: and d.active_inactive_flag = 'A'
3565: );

Line 4079: and exists (select null from hr_legislation_subgroups d

4075: and c.application_id = b.application_id
4076: and ((b.status = 'I' and c.application_short_name <> 'PQP')
4077: or
4078: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
4079: and exists (select null from hr_legislation_subgroups d
4080: where d.legislation_code = stu_rec.c_leg_code
4081: and d.legislation_subgroup = stu_rec.c_leg_sgrp
4082: and d.active_inactive_flag = 'A'
4083: );