APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_ADDRESSES

Line 629: FROM per_addresses

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

Line 656: l_employee_address per_addresses.address_id%TYPE;

652: l_emp_fath_title per_all_people_f.title%TYPE;
653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;
655: l_pos per_all_positions.name%TYPE;
656: l_employee_address per_addresses.address_id%TYPE;
657: l_employee_address_type per_addresses.address_type%TYPE;
658: l_phone_no per_phones.phone_number%TYPE;
659: l_phone_type per_phones.phone_type%TYPE;
660: l_interest VARCHAR2(2);

Line 657: l_employee_address_type per_addresses.address_type%TYPE;

653: l_father_name per_all_people_f.full_name%TYPE;
654: l_gender per_all_people_f.sex%TYPE;
655: l_pos per_all_positions.name%TYPE;
656: l_employee_address per_addresses.address_id%TYPE;
657: l_employee_address_type per_addresses.address_type%TYPE;
658: l_phone_no per_phones.phone_number%TYPE;
659: l_phone_type per_phones.phone_type%TYPE;
660: l_interest VARCHAR2(2);
661: l_action_info_id NUMBER;