APPS.HR_APPLICANT_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1830: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;

1826: --
1827: l_exists varchar2(1);
1828: l_count number;
1829: l_multi_flag boolean;
1830: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;
1831: l_chk_person_id per_all_people_f.person_id%TYPE;
1832: --
1833: l_person_type_id number := p_person_type_id;
1834: l_person_type_id1 number;

Line 1847: l_per_system_status per_assignment_status_types.per_system_status%TYPE;

1843: --
1844: l_hire_date date;
1845: l_original_date_of_hire date;
1846: --
1847: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1848: l_assignment_id per_assignments_f.assignment_id%TYPE;
1849: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1850: --
1851: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

Line 1962: per_assignment_status_types pas

1958: l_dummy_char varchar2(1);
1959: cursor chk_hire_date is
1960: select 'Y'
1961: from per_all_assignments_f asg,
1962: per_assignment_status_types pas
1963: where asg.assignment_status_type_id = pas.assignment_status_type_id
1964: and asg.person_id = p_person_id
1965: and pas.per_system_status = 'ACCEPTED'
1966: and l_hire_date - 1 between asg.effective_start_date and asg.effective_end_date

Line 2037: per_assignment_status_types pas

2033: --
2034: cursor csr_chk_asg_status is
2035: select count(asg.assignment_id)
2036: from per_assignments_f asg,
2037: per_assignment_status_types pas
2038: where asg.assignment_status_type_id = pas.assignment_status_type_id
2039: and asg.person_id = p_person_id
2040: and pas.per_system_status = 'ACCEPTED'
2041: and l_hire_date between asg.effective_start_date

Line 2049: per_assignment_status_types pas

2045: select per.person_id,
2046: pas.per_system_status
2047: from per_all_people_f per,
2048: per_assignments_f asg,
2049: per_assignment_status_types pas
2050: where asg.assignment_status_type_id = pas.assignment_status_type_id
2051: and per.person_id = asg.person_id
2052: and l_hire_date between per.effective_start_date
2053: and per.effective_end_date

Line 2062: per_assignment_status_types pas

2058: cursor csr_get_un_accepted is
2059: select asg.assignment_id,
2060: asg.object_version_number
2061: from per_assignments_f asg,
2062: per_assignment_status_types pas
2063: where asg.assignment_status_type_id = pas.assignment_status_type_id
2064: and asg.person_id = p_person_id
2065: and l_hire_date between asg.effective_start_date
2066: and asg.effective_end_date

Line 2076: per_assignment_status_types pas

2072: select asg.assignment_id,
2073: asg.object_version_number,
2074: asg.vacancy_id
2075: from per_assignments_f asg,
2076: per_assignment_status_types pas
2077: where asg.assignment_status_type_id = pas.assignment_status_type_id
2078: and asg.person_id = p_person_id
2079: and l_hire_date between asg.effective_start_date
2080: and asg.effective_end_date

Line 2091: per_assignment_status_types pas

2087: select asg.assignment_id,
2088: asg.object_version_number,
2089: asg.vacancy_id
2090: from per_assignments_f asg,
2091: per_assignment_status_types pas
2092: where asg.assignment_status_type_id = pas.assignment_status_type_id
2093: and asg.person_id = p_person_id
2094: and l_hire_date between asg.effective_start_date
2095: and asg.effective_end_date

Line 2104: per_assignment_status_types pas

2100: select asg.assignment_id,
2101: asg.object_version_number,
2102: asg.vacancy_id
2103: from per_assignments_f asg,
2104: per_assignment_status_types pas
2105: where asg.assignment_status_type_id = pas.assignment_status_type_id
2106: and asg.person_id = p_person_id
2107: and l_hire_date between asg.effective_start_date
2108: and asg.effective_end_date

Line 2246: from per_assignments_f asg,per_assignment_status_types pas

2242:
2243: -- Bug 8831084 Fix Starts
2244: cursor csr_get_ex_ass_entmnt is
2245: select asg.assignment_id
2246: from per_assignments_f asg,per_assignment_status_types pas
2247: where asg.assignment_status_type_id = pas.assignment_status_type_id
2248: and asg.person_id = p_person_id
2249: and p_hire_date between asg.effective_start_date
2250: and asg.effective_end_date

Line 3009: from per_assignment_status_types

3005:
3006: if l_irc_link_exists <> -1 then
3007:
3008: select assignment_status_type_id into l_irc_spl_status
3009: from per_assignment_status_types
3010: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3011: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3012:
3013: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

Line 3479: from per_assignment_status_types

3475:
3476: if l_irc_link_exists <> -1 then
3477:
3478: select assignment_status_type_id into l_irc_spl_status
3479: from per_assignment_status_types
3480: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3481: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3482:
3483: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

Line 3706: from per_assignment_status_types

3702:
3703: if l_irc_link_exists <> -1 then
3704:
3705: select assignment_status_type_id into l_irc_spl_status
3706: from per_assignment_status_types
3707: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3708: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3709:
3710: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

Line 3887: from per_assignment_status_types

3883:
3884: if l_irc_link_exists <> -1 then
3885:
3886: select assignment_status_type_id into l_irc_spl_status
3887: from per_assignment_status_types
3888: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3889: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3890:
3891: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);