APPS.HR_JPBP_API dependencies on PER_ALL_PEOPLE_F

Line 489: l_employee_number per_all_people_f.employee_number%TYPE;

485: --
486: -- Declare cursors and local variables
487: --
488: l_person_id number;
489: l_employee_number per_all_people_f.employee_number%TYPE;
490: l_proc varchar2(72) := g_package||'create_jp_employee_with_sit';
491: l_legislation_code varchar2(150);
492: --
493: cursor csr_bg is

Line 1051: l_employee_number per_all_people_f.employee_number%TYPE;

1047: ,p_per_information30 in varchar2 default null
1048: ) is
1049: --
1050: l_person_id number;
1051: l_employee_number per_all_people_f.employee_number%TYPE;
1052: l_exists varchar2(2);
1053: l_found boolean := false;
1054: l_proc varchar2(72) := g_package||'create_jp_emp_with_educ_add';
1055: l_legislation_code varchar2(150);

Line 1655: l_applicant_number per_all_people_f.applicant_number%TYPE;

1651: l_proc varchar2(72) := g_package||'create_jp_applicant_with_sit';
1652: l_legislation_code varchar2(2);
1653: l_person_id per_people_f.person_id%TYPE;
1654: l_application_id number;
1655: l_applicant_number per_all_people_f.applicant_number%TYPE;
1656: l_apl_object_version_number number;
1657: --
1658: cursor csr_bg is
1659: select legislation_code

Line 2179: l_applicant_number per_all_people_f.applicant_number%TYPE;

2175: ,p_add_object_version_number out nocopy number
2176: )is
2177: --
2178: l_person_id number;
2179: l_applicant_number per_all_people_f.applicant_number%TYPE;
2180: l_exists varchar2(2);
2181: l_found boolean := false;
2182: l_proc varchar2(72) := g_package||'create_jp_appl_with_educ_add';
2183: l_legislation_code varchar2(150);