APPS.HRHIRAPL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 549: , per_assignment_status_types past

545: --
546: cursor ass_cur is
547: select pa.*
548: from per_assignments_f pa
549: , per_assignment_status_types past
550: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
551: and nvl(past.legislation_code, p_legislation_code)
552: = p_legislation_code
553: and past.per_system_status = 'ACCEPTED'

Line 574: , per_assignment_status_types past

570: /*fix for the bug 5498344 starts here
571: cursor csr_ass_cur_for_primary is
572: select pa.*
573: from per_assignments_f pa
574: , per_assignment_status_types past
575: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
576: and nvl(past.legislation_code, p_legislation_code)
577: = p_legislation_code
578: and past.per_system_status = 'ACCEPTED'

Line 598: , per_assignment_status_types past

594:
595: cursor csr_ass_cur_for_nonprimary is
596: select pa.*
597: from per_assignments_f pa
598: , per_assignment_status_types past
599: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
600: and nvl(past.legislation_code, p_legislation_code)
601: = p_legislation_code
602: and past.per_system_status = 'ACCEPTED'

Line 720: per_assignment_status_types past

716: successful_flag = 'Y'
717: where pap.person_id = p_person_id -- added for bug 5469726
718: and exists (select '1'
719: from per_assignments_f pa,
720: per_assignment_status_types past
721: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
722: and nvl(past.legislation_code, p_legislation_code)
723: = p_legislation_code
724: and past.per_system_status = 'ACCEPTED'

Line 735: per_assignment_status_types past

731: and p_start_date between pa.effective_start_date
732: and pa.effective_end_date)
733: and not exists (select '1'
734: from per_assignments_f pa,
735: per_assignment_status_types past
736: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
737: and nvl(past.legislation_code, p_legislation_code)
738: = p_legislation_code
739: and past.per_system_status <> 'ACCEPTED'

Line 4256: , per_assignment_status_types past

4252: cursor ass_cur is
4253: select pa.assignment_id
4254: , pa.effective_start_date
4255: from per_all_assignments_f pa
4256: , per_assignment_status_types past
4257: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
4258: and pa.person_id = p_person_id
4259: and pa.business_group_id + 0 = p_business_group_id
4260: and

Line 4363: from per_assignment_status_types past

4359: and p_end_date between pa.effective_start_date
4360: and pa.effective_end_date -- fix for bug 6036285
4361: and pa.assignment_status_type_id IN (
4362: select past.assignment_status_type_id
4363: from per_assignment_status_types past
4364: , per_ass_status_type_amends pasa
4365: where pasa.assignment_status_type_id(+)=
4366: past.assignment_status_type_id
4367: and pasa.business_group_id(+) + 0 = p_business_group_id