APPS.PSP_ENC_CREATE_LINES dependencies on PER_ALL_PEOPLE_F

Line 6540: l_full_name per_all_people_f.full_name%TYPE;

6536: l_person_id NUMBER(15);
6537: l_organization_id NUMBER(15);
6538: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6539: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6540: l_full_name per_all_people_f.full_name%TYPE;
6541: l_organization_name hr_organization_units.name%TYPE;
6542: l_process_mode VARCHAR2(15);
6543: l_enc_begin_date DATE;
6544: l_min_asg_id NUMBER(15);

Line 6695: FROM per_all_people_f

6691: AND gl_set_of_books_id = g_set_of_books_id;
6692:
6693: CURSOR person_name_cur (p_effective_date IN DATE) IS
6694: SELECT full_name
6695: FROM per_all_people_f
6696: WHERE person_id = l_person_id
6697: AND effective_end_date >= p_effective_date
6698: AND ROWNUM = 1;
6699:

Line 8484: l_full_name per_all_people_f.full_name%TYPE;

8480: l_person_id NUMBER(15);
8481: l_organization_id NUMBER(15);
8482: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8483: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8484: l_full_name per_all_people_f.full_name%TYPE;
8485: l_organization_name hr_organization_units.name%TYPE;
8486: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8487: l_process_mode VARCHAR2(15);
8488: l_person_id1 NUMBER(15);

Line 8566: FROM per_all_people_f

8562: AND ROWNUM = 1;
8563:
8564: CURSOR person_name_cur (p_start_date IN DATE) IS
8565: SELECT full_name
8566: FROM per_all_people_f
8567: WHERE person_id = l_person_id
8568: AND effective_end_date >= p_start_date
8569: AND ROWNUM = 1;
8570: