APPS.IRC_PARTY_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1926: from per_all_assignments_f paaf

1922: ,p_effective_date IN date) IS
1923: --
1924: cursor csr_application_count(p_vacancy_id number, p_effective_date date) is
1925: select count(*)
1926: from per_all_assignments_f paaf
1927: , IRC_AGENCY_VACANCIES AGV1
1928: ,per_all_people_f per1
1929: ,irc_notification_preferences prefs
1930: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'

Line 2004: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

2000: ,p_applicant_number OUT NOCOPY varchar2) IS
2001: --
2002: l_proc varchar2(72) := g_package||'registered_user_application';
2003: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
2004: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2005: l_person_id per_all_people_f.person_id%TYPE;
2006: l_party_id per_all_people_f.party_id%TYPE;
2007: l_rec_person_id per_all_people_f.person_id%TYPE;
2008: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 2008: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2004: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
2005: l_person_id per_all_people_f.person_id%TYPE;
2006: l_party_id per_all_people_f.party_id%TYPE;
2007: l_rec_person_id per_all_people_f.person_id%TYPE;
2008: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2009: l_effective_date date;
2010: l_application_received_date date;
2011: l_party_last_update_date date;
2012: l_return_status varchar2(10);

Line 2069: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;

2065: l_cagr_grade_def_id number;
2066: l_cagr_concatenated_segments varchar2(2000);
2067: l_group_name pay_people_groups.group_name%type;
2068: l_soft_coding_keyflex_id number;
2069: l_assignment_sequence per_all_assignments_f.assignment_sequence%type;
2070: -- those required for hr_applicant_api.create_applicant
2071: l_application_id number;
2072: l_full_name per_all_people_f.full_name%type;
2073: l_person_type per_person_types.system_person_type%type;

Line 2147: from per_all_assignments_f

2143: where vacancy_id = p_vacancy_id;
2144: --
2145: cursor get_new_asg(p_person_id number, p_effective_date date) is
2146: select assignment_id,object_version_number
2147: from per_all_assignments_f
2148: where person_id=p_person_id
2149: and effective_start_date = p_effective_date
2150: and assignment_type='A';
2151: --

Line 3359: ,per_all_assignments_f asg2

3355: where addr.person_id=per1.person_id
3356: and addr.address_type in ('H','REC','HOME')))
3357: and (p_manager_last_name is null
3358: or exists (select 1 from per_all_people_f per2
3359: ,per_all_assignments_f asg2
3360: where asg2.person_id=per1.person_id
3361: and asg2.assignment_type in ('E','C')
3362: and asg2.supervisor_id=per2.person_id
3363: and asg2.effective_start_date between per2.effective_start_date and per2.effective_end_date