APPS.IRC_PENDING_DATA_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 782: l_applicant_assg_id per_all_assignments_f.assignment_id%type;

778: l_source_type irc_pending_data.source_type%type;
779: l_job_post_source_name irc_pending_data.job_post_source_name%type;
780:
781: l_applicant_person_id per_all_people_f.person_id%type;
782: l_applicant_assg_id per_all_assignments_f.assignment_id%type;
783: l_appl_ovn per_all_people_f.object_version_number%type;
784: l_emp_number per_all_people_f.employee_number%type;
785:
786: l_effective_start_date per_all_people_f.effective_start_date%type;

Line 928: from per_all_assignments_f asg,

924: -- Query built similar to JobsAppliedForVO query
925: --
926: cursor csr_job_applied_for(p_person_id in number, p_vacancy_id in number) is
927: select 1
928: from per_all_assignments_f asg,
929: per_assignment_status_types_v ast,
930: per_all_people_f ppf,
931: irc_assignment_statuses ias,
932: per_all_people_f linkppf,