APPS.HRHIRAPL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 572: , per_assignment_status_types past

568: --
569: cursor ass_cur is
570: select pa.*
571: from per_assignments_f pa
572: , per_assignment_status_types past
573: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
574: and nvl(past.legislation_code, p_legislation_code)
575: = p_legislation_code
576: and past.per_system_status = 'ACCEPTED'

Line 597: , per_assignment_status_types past

593: /*fix for the bug 5498344 starts here
594: cursor csr_ass_cur_for_primary is
595: select pa.*
596: from per_assignments_f pa
597: , per_assignment_status_types past
598: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
599: and nvl(past.legislation_code, p_legislation_code)
600: = p_legislation_code
601: and past.per_system_status = 'ACCEPTED'

Line 621: , per_assignment_status_types past

617:
618: cursor csr_ass_cur_for_nonprimary is
619: select pa.*
620: from per_assignments_f pa
621: , per_assignment_status_types past
622: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
623: and nvl(past.legislation_code, p_legislation_code)
624: = p_legislation_code
625: and past.per_system_status = 'ACCEPTED'

Line 750: per_assignment_status_types past

746: successful_flag = 'Y'
747: where pap.person_id = p_person_id -- added for bug 5469726
748: and exists (select '1'
749: from per_assignments_f pa,
750: per_assignment_status_types past
751: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
752: and nvl(past.legislation_code, p_legislation_code)
753: = p_legislation_code
754: and past.per_system_status = 'ACCEPTED'

Line 765: per_assignment_status_types past

761: and p_start_date between pa.effective_start_date
762: and pa.effective_end_date)
763: and not exists (select '1'
764: from per_assignments_f pa,
765: per_assignment_status_types past
766: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
767: and nvl(past.legislation_code, p_legislation_code)
768: = p_legislation_code
769: and past.per_system_status <> 'ACCEPTED'

Line 1326: from per_assignment_status_types

1322:
1323: if l_irc_link_exists <> -1 then
1324:
1325: select assignment_status_type_id into l_irc_spl_status
1326: from per_assignment_status_types
1327: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
1328: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
1329:
1330: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

Line 3571: from per_assignment_status_types

3567:
3568: if l_irc_link_exists <> -1 then
3569:
3570: select assignment_status_type_id into l_irc_spl_status
3571: from per_assignment_status_types
3572: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3573: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3574:
3575: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

Line 4861: , per_assignment_status_types past

4857: cursor ass_cur is
4858: select pa.assignment_id
4859: , pa.effective_start_date
4860: from per_all_assignments_f pa
4861: , per_assignment_status_types past
4862: where nvl(past.business_group_id,p_business_group_id) = pa.business_group_id + 0
4863: and pa.person_id = p_person_id
4864: and pa.business_group_id + 0 = p_business_group_id
4865: and

Line 4968: from per_assignment_status_types past

4964: and p_end_date between pa.effective_start_date
4965: and pa.effective_end_date -- fix for bug 6036285
4966: and pa.assignment_status_type_id IN (
4967: select past.assignment_status_type_id
4968: from per_assignment_status_types past
4969: , per_ass_status_type_amends pasa
4970: where pasa.assignment_status_type_id(+)=
4971: past.assignment_status_type_id
4972: and pasa.business_group_id(+) + 0 = p_business_group_id