APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_PHONES

Line 639: FROM per_phones

635: CURSOR c_phone(p_person_id NUMBER)
636: IS
637: SELECT phone_number rep_phone_no
638: ,phone_type
639: FROM per_phones
640: WHERE parent_id = p_person_id
641: AND phone_type = DECODE(phone_type,'H1','H1','M')
642: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'))
643: ORDER BY phone_type ASC;

Line 658: l_phone_no per_phones.phone_number%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;
662: l_ovn NUMBER;

Line 659: l_phone_type per_phones.phone_type%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;
662: l_ovn NUMBER;
663: flag BOOLEAN;

Line 2480: FROM per_phones

2476: CURSOR c_rep_phone(p_person_id NUMBER)
2477: IS
2478: SELECT phone_number rep_phone_no
2479: ,phone_type
2480: FROM per_phones
2481: WHERE parent_id = p_person_id
2482: AND phone_type = DECODE(phone_type,'H1','H1','M')
2483: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'))
2484: ORDER BY phone_type ASC;

Line 2489: FROM per_phones

2485:
2486: CURSOR c_rep_work_fax(p_person_id NUMBER)
2487: IS
2488: SELECT phone_number work_fax
2489: FROM per_phones
2490: WHERE parent_id = p_person_id
2491: AND phone_type = 'WF'
2492: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2493:

Line 2507: l_rep_phone_no per_phones.phone_number%TYPE;

2503: l_rep_name per_all_people_f.full_name%TYPE;
2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;
2509: l_rep_father_title per_all_people_f.title%TYPE;
2510: l_rep_title per_all_people_f.title%TYPE;
2511: l_rep_work_fax per_phones.phone_number%TYPE;

Line 2508: l_phone_type per_phones.phone_type%TYPE;

2504: l_position per_all_positions.name%TYPE;
2505: l_rep_father per_all_people_f.full_name%TYPE;
2506: l_rep_location hr_organization_units.location_id%TYPE;
2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;
2509: l_rep_father_title per_all_people_f.title%TYPE;
2510: l_rep_title per_all_people_f.title%TYPE;
2511: l_rep_work_fax per_phones.phone_number%TYPE;
2512: l_action_info_id NUMBER;

Line 2511: l_rep_work_fax per_phones.phone_number%TYPE;

2507: l_rep_phone_no per_phones.phone_number%TYPE;
2508: l_phone_type per_phones.phone_type%TYPE;
2509: l_rep_father_title per_all_people_f.title%TYPE;
2510: l_rep_title per_all_people_f.title%TYPE;
2511: l_rep_work_fax per_phones.phone_number%TYPE;
2512: l_action_info_id NUMBER;
2513: l_ovn NUMBER;
2514: l_message VARCHAR2(255);
2515: l_procedure VARCHAR2(100);