eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_PHONES

Line 2802: FROM per_phones

2798: ,SUBSTR(phone_number
2799: ,INSTR(phone_number,'-',1,1) + 1
2800: ,INSTR(phone_number,'-',1,2) - INSTR(phone_number,'-',1,1) -1
2801: )STD_CODE
2802: FROM per_phones
2803: WHERE parent_id = p_person_id
2804: AND phone_type = 'W1'
2805: AND g_qr_end_date BETWEEN date_from AND NVL(date_to,TO_DATE('31-12-4712','DD-MM-YYYY'));
2806:

Line 2998: l_rep_work_phone per_phones.phone_number%TYPE;

2994: l_rep_name per_all_people_f.full_name%TYPE;
2995: l_rep_position per_all_positions.name%TYPE;
2996: l_rep_location hr_organization_units.location_id%TYPE;
2997: l_rep_email_id per_all_people_f.email_address%TYPE;
2998: l_rep_work_phone per_phones.phone_number%TYPE;
2999: l_rep_std_code per_phones.phone_number%TYPE;
3000: l_procedure VARCHAR2(250);
3001: l_message VARCHAR2(250);
3002: BEGIN

Line 2999: l_rep_std_code per_phones.phone_number%TYPE;

2995: l_rep_position per_all_positions.name%TYPE;
2996: l_rep_location hr_organization_units.location_id%TYPE;
2997: l_rep_email_id per_all_people_f.email_address%TYPE;
2998: l_rep_work_phone per_phones.phone_number%TYPE;
2999: l_rep_std_code per_phones.phone_number%TYPE;
3000: l_procedure VARCHAR2(250);
3001: l_message VARCHAR2(250);
3002: BEGIN
3003: g_debug := hr_utility.debug_enabled;

Line 7574: l_rep_work_phone per_phones.phone_number%TYPE;

7570: l_rep_name per_all_people_f.full_name%TYPE;
7571: l_rep_position per_all_positions.name%TYPE;
7572: l_rep_location hr_organization_units.location_id%TYPE;
7573: l_rep_email_id per_all_people_f.email_address%TYPE;
7574: l_rep_work_phone per_phones.phone_number%TYPE;
7575: l_rep_std_code per_phones.phone_number%TYPE;
7576:
7577: l_action_info_id NUMBER;
7578: l_ovn NUMBER;

Line 7575: l_rep_std_code per_phones.phone_number%TYPE;

7571: l_rep_position per_all_positions.name%TYPE;
7572: l_rep_location hr_organization_units.location_id%TYPE;
7573: l_rep_email_id per_all_people_f.email_address%TYPE;
7574: l_rep_work_phone per_phones.phone_number%TYPE;
7575: l_rep_std_code per_phones.phone_number%TYPE;
7576:
7577: l_action_info_id NUMBER;
7578: l_ovn NUMBER;
7579: l_new_nil_challan VARCHAR2(1);

Line 8093: l_rep_work_phone per_phones.phone_number%TYPE;

8089: l_rep_name per_all_people_f.full_name%TYPE;
8090: l_rep_position per_all_positions.name%TYPE;
8091: l_rep_location hr_organization_units.location_id%TYPE;
8092: l_rep_email_id per_all_people_f.email_address%TYPE;
8093: l_rep_work_phone per_phones.phone_number%TYPE;
8094: l_rep_std_code per_phones.phone_number%TYPE;
8095: l_flag_number NUMBER := -1;
8096: l_action_info_id NUMBER;
8097: l_ovn NUMBER;

Line 8094: l_rep_std_code per_phones.phone_number%TYPE;

8090: l_rep_position per_all_positions.name%TYPE;
8091: l_rep_location hr_organization_units.location_id%TYPE;
8092: l_rep_email_id per_all_people_f.email_address%TYPE;
8093: l_rep_work_phone per_phones.phone_number%TYPE;
8094: l_rep_std_code per_phones.phone_number%TYPE;
8095: l_flag_number NUMBER := -1;
8096: l_action_info_id NUMBER;
8097: l_ovn NUMBER;
8098: