APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_PHONES

Line 740: FROM per_phones

736:
737: CURSOR c_rep_phone(p_person_id NUMBER)
738: IS
739: SELECT phone_number rep_phone_no
740: FROM per_phones
741: WHERE parent_id = p_person_id
742: AND phone_type = 'W1'
743: AND p_effective_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
744:

Line 766: l_rep_phone_no per_phones.phone_number%TYPE;

762: l_rep_person_id per_all_people_f.person_id%TYPE;
763: l_rep_name per_all_people_f.full_name%TYPE;
764: l_position per_all_positions.name%TYPE;
765: l_rep_location hr_organization_units.location_id%TYPE;
766: l_rep_phone_no per_phones.phone_number%TYPE;
767: l_rep_email_id per_all_people_f.email_address%TYPE;
768: l_action_info_id NUMBER;
769: l_ovn NUMBER;
770: l_challan_count NUMBER;