APPS.PER_NL_WAZO_ARCHIVE dependencies on PER_PHONES

Line 1372: /* per_phones */

1368: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1369: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)
1370: ,hr_general.end_of_time);
1371: /**************************************************************************/
1372: /* per_phones */
1373: CURSOR csr_get_phone_no(p_assignment_id IN NUMBER
1374: , p_start_date IN DATE
1375: , p_type IN VARCHAR2) IS
1376: SELECT pp.phone_number phone_no

Line 1378: ,per_phones pp

1374: , p_start_date IN DATE
1375: , p_type IN VARCHAR2) IS
1376: SELECT pp.phone_number phone_no
1377: FROM per_all_assignments_f pas
1378: ,per_phones pp
1379: WHERE pas.assignment_id = p_assignment_id
1380: AND p_start_date BETWEEN pas.effective_start_date
1381: AND pas.effective_end_date
1382: AND pas.person_id = pp.parent_id

Line 1520: l_sick_ph_no per_phones.phone_number%TYPE;

1516: l_org_name VARCHAR2(150);
1517: l_abs_start_date DATE :=NULL;
1518: l_abs_end_date DATE :=NULL;
1519: l_assignment_id NUMBER :=NULL;
1520: l_sick_ph_no per_phones.phone_number%TYPE;
1521: l_for_sick_ph_no per_phones.phone_number%TYPE;
1522: l_sick_mobile_no per_phones.phone_number%TYPE;
1523: l_job_name per_jobs.name%TYPE;
1524: l_fz_code per_assignment_extra_info.aei_information3%TYPE;

Line 1521: l_for_sick_ph_no per_phones.phone_number%TYPE;

1517: l_abs_start_date DATE :=NULL;
1518: l_abs_end_date DATE :=NULL;
1519: l_assignment_id NUMBER :=NULL;
1520: l_sick_ph_no per_phones.phone_number%TYPE;
1521: l_for_sick_ph_no per_phones.phone_number%TYPE;
1522: l_sick_mobile_no per_phones.phone_number%TYPE;
1523: l_job_name per_jobs.name%TYPE;
1524: l_fz_code per_assignment_extra_info.aei_information3%TYPE;
1525: l_action_info_id NUMBER;

Line 1522: l_sick_mobile_no per_phones.phone_number%TYPE;

1518: l_abs_end_date DATE :=NULL;
1519: l_assignment_id NUMBER :=NULL;
1520: l_sick_ph_no per_phones.phone_number%TYPE;
1521: l_for_sick_ph_no per_phones.phone_number%TYPE;
1522: l_sick_mobile_no per_phones.phone_number%TYPE;
1523: l_job_name per_jobs.name%TYPE;
1524: l_fz_code per_assignment_extra_info.aei_information3%TYPE;
1525: l_action_info_id NUMBER;
1526: l_ovn NUMBER;