APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_ADDRESSES

Line 630: FROM per_addresses

626: CURSOR c_employee_address(p_person_id NUMBER)
627: IS
628: SELECT address_id
629: ,address_type
630: FROM per_addresses
631: WHERE person_id = p_person_id
632: AND address_type = DECODE(address_type,'IN_P','IN_P','IN_C')
633: AND p_effective_end_date BETWEEN date_from AND nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'))
634: ORDER BY address_type DESC;

Line 659: l_employee_address per_addresses.address_id%TYPE;

655: l_gender per_all_people_f.sex%TYPE;
656: l_pos per_all_positions.name%TYPE;
657: l_job per_jobs.name%TYPE;
658: l_email_address per_all_people_f.email_address%TYPE;
659: l_employee_address per_addresses.address_id%TYPE;
660: l_employee_address_type per_addresses.address_type%TYPE;
661: l_phone_no per_phones.phone_number%TYPE;
662: l_phone_type per_phones.phone_type%TYPE;
663: l_interest VARCHAR2(2);

Line 660: l_employee_address_type per_addresses.address_type%TYPE;

656: l_pos per_all_positions.name%TYPE;
657: l_job per_jobs.name%TYPE;
658: l_email_address per_all_people_f.email_address%TYPE;
659: l_employee_address per_addresses.address_id%TYPE;
660: l_employee_address_type per_addresses.address_type%TYPE;
661: l_phone_no per_phones.phone_number%TYPE;
662: l_phone_type per_phones.phone_type%TYPE;
663: l_interest VARCHAR2(2);
664: l_action_info_id NUMBER;