APPS.PER_NL_WAZO_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1365: FROM per_assignment_extra_info paei

1361: , p_start_date IN DATE) IS
1362: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1363: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1364: ,paei.aei_information3 code_kind
1365: FROM per_assignment_extra_info paei
1366: WHERE paei.assignment_id = p_assignment_id
1367: AND paei.aei_information_category = 'NL_LBR'
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)

Line 1499: FROM per_assignment_extra_info paei

1495: WHERE pas.assignment_id = p_assignment_id;
1496: /**************************************************************************/
1497: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1498: SELECT paei.aei_information1 numiv_override
1499: FROM per_assignment_extra_info paei
1500: WHERE paei.assignment_id = p_assignment_id
1501: AND paei.aei_information_category = 'NL_NUMIV_OVERRIDE';
1502: /**************************************************************************/
1503:

Line 1524: l_fz_code per_assignment_extra_info.aei_information3%TYPE;

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;
1527: l_exists VARCHAR2(1);
1528: l_chunk_number NUMBER;

Line 1539: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;

1535: l_employer_bank csr_get_employer_bank_info%ROWTYPE;
1536: l_employee_bank csr_get_employee_bank_info%ROWTYPE;
1537: l_lbr_info csr_get_lbr_info%ROWTYPE;
1538: l_assignment_dates csr_get_assignment_dates%ROWTYPE;
1539: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;
1540:
1541: /**************************************************************************/
1542: BEGIN
1543: hr_utility.trace('+====archive_code==========================================+');