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 1863: from hr_legislation_subgroups d

1859: or
1860: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
1861: and exists
1862: (select null
1863: from hr_legislation_subgroups d
1864: where d.legislation_code = r_distinct.legislation_code
1865: and d.legislation_subgroup =
1866: r_distinct.legislation_subgroup
1867: and d.active_inactive_flag = 'A'

Line 3593: and exists (select null from hr_legislation_subgroups d

3589: and c.application_id = b.application_id
3590: and ((b.status = 'I' and c.application_short_name <> 'PQP')
3591: or
3592: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
3593: and exists (select null from hr_legislation_subgroups d
3594: where d.legislation_code = stu_rec.c_leg_code
3595: and d.legislation_subgroup = stu_rec.c_leg_sgrp
3596: and d.active_inactive_flag = 'A'
3597: );

Line 4111: and exists (select null from hr_legislation_subgroups d

4107: and c.application_id = b.application_id
4108: and ((b.status = 'I' and c.application_short_name <> 'PQP')
4109: or
4110: (b.status in ('I', 'S') and c.application_short_name = 'PQP')))
4111: and exists (select null from hr_legislation_subgroups d
4112: where d.legislation_code = stu_rec.c_leg_code
4113: and d.legislation_subgroup = stu_rec.c_leg_sgrp
4114: and d.active_inactive_flag = 'A'
4115: );