APPS.PAY_SE_ARCHIVE_CWCA dependencies on PER_ALL_PEOPLE_F

Line 195: l_last_name per_all_people_f.last_name%TYPE;

191: l_assignment_id NUMBER;
192: -- *****************************************************************************
193: -- Variable Required
194: l_person_number VARCHAR2 (100);
195: l_last_name per_all_people_f.last_name%TYPE;
196: l_first_name per_all_people_f.first_name%TYPE;
197:
198: l_local_unit_id NUMBER;
199: l_legal_employer_name VARCHAR2 (100);

Line 196: l_first_name per_all_people_f.first_name%TYPE;

192: -- *****************************************************************************
193: -- Variable Required
194: l_person_number VARCHAR2 (100);
195: l_last_name per_all_people_f.last_name%TYPE;
196: l_first_name per_all_people_f.first_name%TYPE;
197:
198: l_local_unit_id NUMBER;
199: l_legal_employer_name VARCHAR2 (100);
200: l_org_number VARCHAR2 (100);

Line 373: csr_v_person_id per_all_people_f.person_id%TYPE

369:
370: lr_contact_details csr_contact_details%ROWTYPE;
371:
372: CURSOR csr_person_info (
373: csr_v_person_id per_all_people_f.person_id%TYPE
374: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE
375: )
376: IS
377: SELECT *

Line 374: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE

370: lr_contact_details csr_contact_details%ROWTYPE;
371:
372: CURSOR csr_person_info (
373: csr_v_person_id per_all_people_f.person_id%TYPE
374: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE
375: )
376: IS
377: SELECT *
378: FROM per_all_people_f p

Line 378: FROM per_all_people_f p

374: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE
375: )
376: IS
377: SELECT *
378: FROM per_all_people_f p
379: WHERE p.business_group_id = g_business_group_id
380: AND p.person_id = csr_v_person_id
381: AND csr_v_effective_date BETWEEN p.effective_start_date
382: AND p.effective_end_date;

Line 387: csr_v_person_id per_all_people_f.person_id%TYPE

383:
384: lr_person_info csr_person_info%ROWTYPE;
385:
386: CURSOR csr_assignment_info (
387: csr_v_person_id per_all_people_f.person_id%TYPE
388: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
389: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
390: )
391: IS