APPS.PAY_IN_EOY_ARCHIVE dependencies on PER_PHONES

Line 640: FROM per_phones

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

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

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

Line 2546: FROM per_phones

2542: CURSOR c_rep_phone(p_person_id NUMBER)
2543: IS
2544: SELECT phone_number rep_phone_no
2545: ,phone_type
2546: FROM per_phones
2547: WHERE parent_id = p_person_id
2548: AND phone_type = DECODE(phone_type,'H1','H1','M')
2549: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'))
2550: ORDER BY phone_type ASC;

Line 2555: FROM per_phones

2551:
2552: CURSOR c_rep_work_fax(p_person_id NUMBER)
2553: IS
2554: SELECT phone_number work_fax
2555: FROM per_phones
2556: WHERE parent_id = p_person_id
2557: AND phone_type = 'WF'
2558: AND p_effective_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2559:

Line 2574: l_rep_phone_no per_phones.phone_number%TYPE;

2570: l_position per_all_positions.name%TYPE;
2571: l_job per_jobs.name%TYPE;
2572: l_rep_father per_all_people_f.full_name%TYPE;
2573: l_rep_location hr_organization_units.location_id%TYPE;
2574: l_rep_phone_no per_phones.phone_number%TYPE;
2575: l_phone_type per_phones.phone_type%TYPE;
2576: l_rep_father_title per_all_people_f.title%TYPE;
2577: l_rep_title per_all_people_f.title%TYPE;
2578: l_rep_work_fax per_phones.phone_number%TYPE;

Line 2575: l_phone_type per_phones.phone_type%TYPE;

2571: l_job per_jobs.name%TYPE;
2572: l_rep_father per_all_people_f.full_name%TYPE;
2573: l_rep_location hr_organization_units.location_id%TYPE;
2574: l_rep_phone_no per_phones.phone_number%TYPE;
2575: l_phone_type per_phones.phone_type%TYPE;
2576: l_rep_father_title per_all_people_f.title%TYPE;
2577: l_rep_title per_all_people_f.title%TYPE;
2578: l_rep_work_fax per_phones.phone_number%TYPE;
2579: l_action_info_id NUMBER;

Line 2578: l_rep_work_fax per_phones.phone_number%TYPE;

2574: l_rep_phone_no per_phones.phone_number%TYPE;
2575: l_phone_type per_phones.phone_type%TYPE;
2576: l_rep_father_title per_all_people_f.title%TYPE;
2577: l_rep_title per_all_people_f.title%TYPE;
2578: l_rep_work_fax per_phones.phone_number%TYPE;
2579: l_action_info_id NUMBER;
2580: l_ovn NUMBER;
2581: l_message VARCHAR2(255);
2582: l_procedure VARCHAR2(100);