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 370: csr_v_person_id per_all_people_f.person_id%TYPE

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

Line 371: ,csr_v_effective_date per_all_people_f.effective_start_date%TYPE

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

Line 375: FROM per_all_people_f p

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

Line 384: csr_v_person_id per_all_people_f.person_id%TYPE

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