APPS.PQP_HROSS_INTEGRATION dependencies on PER_PEOPLE_F

Line 407: FROM per_people_f

403:
404: -- Cursor to get the Employee Number
405: CURSOR csr_get_employee_num(c_person_id IN Number) IS
406: SELECT employee_number
407: FROM per_people_f
408: WHERE person_id = c_person_id;
409:
410: -- =============================================================================
411: -- ~ Student_FICA_Status: Procedure to update the FICA status of a student

Line 5543: FROM per_people_f ppf, per_person_types ppt

5539: CURSOR csr_chk_ni_exists (c_ni Varchar2
5540: ,c_bgid Number
5541: ,c_eff_date Date) IS
5542: SELECT 'Y'
5543: FROM per_people_f ppf, per_person_types ppt
5544: WHERE ppf.national_identifier = c_ni
5545: AND ppf.business_group_id = c_bgid
5546: AND ppf.business_group_id = ppt.business_group_id
5547: AND ppf.person_type_id = ppt.person_type_id

Line 5557: FROM per_people_f ppf, per_assignments_f paf

5553: CURSOR get_dup_asg_id (c_dup_per_id Varchar2
5554: ,c_business_group_id Varchar2
5555: ,c_eff_date Date) IS
5556: SELECT paf.assignment_id
5557: FROM per_people_f ppf, per_assignments_f paf
5558: WHERE paf.person_id = c_dup_per_id
5559: AND paf.person_id = ppf.person_id
5560: AND paf.business_group_id = c_business_group_id
5561: AND paf.business_group_id = ppf.business_group_id

Line 5582: l_national_identifier per_people_f.national_identifier%TYPE;

5578: l_updper_api_out t_UpdEmp_Api;
5579: l_crt_emp_api_out t_CreateContact_Api;
5580: l_HireToJobapi_out t_HrToJob_Api;
5581: l_effective_date Date;
5582: l_national_identifier per_people_f.national_identifier%TYPE;
5583: l_party_id per_people_f.party_id%TYPE;
5584: l_ni_exists Varchar2(10);
5585: l_dyn_sql_qry Varchar(500);
5586: l_sql_qry Varchar(500);

Line 5583: l_party_id per_people_f.party_id%TYPE;

5579: l_crt_emp_api_out t_CreateContact_Api;
5580: l_HireToJobapi_out t_HrToJob_Api;
5581: l_effective_date Date;
5582: l_national_identifier per_people_f.national_identifier%TYPE;
5583: l_party_id per_people_f.party_id%TYPE;
5584: l_ni_exists Varchar2(10);
5585: l_dyn_sql_qry Varchar(500);
5586: l_sql_qry Varchar(500);
5587: l_proc_name CONSTANT Varchar2(150):= g_pkg ||'Create_Student_Employee';

Line 8056: FROM per_people_f ppf

8052: ,c_effective_date IN Date) IS
8053: SELECT ppt.system_person_type
8054: ,ppt.user_person_type
8055: ,ppt.person_type_id
8056: FROM per_people_f ppf
8057: ,per_person_types ppt
8058: WHERE ppt.person_type_id = ppf.person_type_id
8059: AND c_effective_date BETWEEN ppf.effective_start_date
8060: AND ppf.effective_end_date