DBA Data[Home] [Help]

APPS.IRC_PENDING_DATA_API dependencies on PER_ALL_PEOPLE_F

Line 761: l_person_id per_all_people_f.person_id%type;

757: -- Declare cursors and local variables
758: --
759: l_proc varchar2(72) := g_package||'process_applications';
760:
761: l_person_id per_all_people_f.person_id%type;
762: l_resp_key fnd_responsibility.responsibility_key%type;
763: l_irc_resp_id fnd_responsibility.responsibility_id%type;
764: l_irc_resp_appl_id fnd_responsibility.application_id%type;
765: l_reg_bg_id number;

Line 781: l_applicant_person_id per_all_people_f.person_id%type;

777: l_doc_ovn number;
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:

Line 783: l_appl_ovn per_all_people_f.object_version_number%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;
787: l_effective_end_date per_all_people_f.effective_end_date%type;

Line 784: l_emp_number per_all_people_f.employee_number%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;
787: l_effective_end_date per_all_people_f.effective_end_date%type;
788: l_full_name per_all_people_f.full_name%type;

Line 786: l_effective_start_date per_all_people_f.effective_start_date%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;
787: l_effective_end_date per_all_people_f.effective_end_date%type;
788: l_full_name per_all_people_f.full_name%type;
789: l_comment_id per_all_people_f.comment_id%type;
790: l_name_combination_warning boolean;

Line 787: l_effective_end_date per_all_people_f.effective_end_date%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;
787: l_effective_end_date per_all_people_f.effective_end_date%type;
788: l_full_name per_all_people_f.full_name%type;
789: l_comment_id per_all_people_f.comment_id%type;
790: l_name_combination_warning boolean;
791: l_assign_payroll_warning boolean;

Line 788: l_full_name per_all_people_f.full_name%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;
787: l_effective_end_date per_all_people_f.effective_end_date%type;
788: l_full_name per_all_people_f.full_name%type;
789: l_comment_id per_all_people_f.comment_id%type;
790: l_name_combination_warning boolean;
791: l_assign_payroll_warning boolean;
792: l_orig_hire_warning boolean;

Line 789: l_comment_id per_all_people_f.comment_id%type;

785:
786: l_effective_start_date per_all_people_f.effective_start_date%type;
787: l_effective_end_date per_all_people_f.effective_end_date%type;
788: l_full_name per_all_people_f.full_name%type;
789: l_comment_id per_all_people_f.comment_id%type;
790: l_name_combination_warning boolean;
791: l_assign_payroll_warning boolean;
792: l_orig_hire_warning boolean;
793: l_per_ovn number;

Line 795: l_applicant_number per_all_people_f.applicant_number%type;

791: l_assign_payroll_warning boolean;
792: l_orig_hire_warning boolean;
793: l_per_ovn number;
794: l_asg_ovn number;
795: l_applicant_number per_all_people_f.applicant_number%type;
796: l_err_msg varchar2(4000);
797: l_msg varchar2(4000);
798: l_err_num number;
799: l_allow_access irc_pending_data.allow_access%type;

Line 858: from per_all_people_f ppf

854: cursor csr_get_person_id_in_vac_bg(p_person_id number, p_vacancy_id number) is
855: select ppf.person_id
856: ,ppf.object_version_number
857: ,ppf.employee_number
858: from per_all_people_f ppf
859: where trunc(sysdate) between
860: ppf.effective_start_date and ppf.effective_end_date
861: and ppf.party_id in (select party_id from per_all_people_f
862: where person_id=p_person_id

Line 861: and ppf.party_id in (select party_id from per_all_people_f

857: ,ppf.employee_number
858: from per_all_people_f ppf
859: where trunc(sysdate) between
860: ppf.effective_start_date and ppf.effective_end_date
861: and ppf.party_id in (select party_id from per_all_people_f
862: where person_id=p_person_id
863: and trunc(sysdate) between
864: effective_start_date and effective_end_date)
865: and ppf.business_group_id in

Line 930: per_all_people_f ppf,

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,
933: per_assignment_status_types_v ast1
934: where asg.vacancy_id = p_vacancy_id

Line 932: per_all_people_f linkppf,

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,
933: per_assignment_status_types_v ast1
934: where asg.vacancy_id = p_vacancy_id
935: and asg.effective_start_date=(select max(effective_start_date)
936: from per_assignments_f asg2