APPS.PSP_ENC_CREATE_LINES dependencies on PER_ALL_PEOPLE_F

Line 6797: l_full_name per_all_people_f.full_name%TYPE;

6793: l_person_id NUMBER(15);
6794: l_organization_id NUMBER(15);
6795: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6796: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6797: l_full_name per_all_people_f.full_name%TYPE;
6798: l_organization_name hr_organization_units.name%TYPE;
6799: l_process_mode VARCHAR2(15);
6800: l_enc_begin_date DATE;
6801: l_min_asg_id NUMBER(15);

Line 6972: FROM per_all_people_f

6968: AND gl_set_of_books_id = g_set_of_books_id;
6969:
6970: CURSOR person_name_cur (p_effective_date IN DATE) IS
6971: SELECT full_name
6972: FROM per_all_people_f
6973: WHERE person_id = l_person_id
6974: AND effective_end_date >= p_effective_date
6975: AND ROWNUM = 1;
6976:

Line 8807: l_full_name per_all_people_f.full_name%TYPE;

8803: l_person_id NUMBER(15);
8804: l_organization_id NUMBER(15);
8805: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8806: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8807: l_full_name per_all_people_f.full_name%TYPE;
8808: l_organization_name hr_organization_units.name%TYPE;
8809: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8810: l_process_mode VARCHAR2(15);
8811: l_person_id1 NUMBER(15);

Line 8890: FROM per_all_people_f

8886: AND ROWNUM = 1;
8887:
8888: CURSOR person_name_cur (p_start_date IN DATE) IS
8889: SELECT full_name
8890: FROM per_all_people_f
8891: WHERE person_id = l_person_id
8892: AND effective_end_date >= p_start_date
8893: AND ROWNUM = 1;
8894: