APPS.PER_NL_DSR_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 350: FROM per_assignment_extra_info aei

346: /**************************************************************************/
347: CURSOR cur_get_tml_info(c_assignment_id IN NUMBER
348: , c_effective_date IN DATE) IS
349: SELECT aei.aei_information3 temp_worker
350: FROM per_assignment_extra_info aei
351: WHERE aei.assignment_id = c_assignment_id
352: AND aei_information_category = 'NL_TML'
353: AND c_effective_date BETWEEN fnd_date.canonical_to_date (aei_information1)
354: AND nvl (fnd_date.canonical_to_date (aei_information2)

Line 1551: FROM per_assignment_extra_info paei

1547: /* code fz*/
1548: CURSOR csr_get_fzcode (p_assignment_id IN NUMBER
1549: , p_start_date IN DATE) IS
1550: SELECT paei.aei_information3 fzcode
1551: FROM per_assignment_extra_info paei
1552: WHERE paei.assignment_id = p_assignment_id
1553: AND paei.aei_information_category = 'NL_TML'
1554: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1555: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)

Line 1564: FROM per_assignment_extra_info paei

1560: , p_start_date IN DATE) IS
1561: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1562: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1563: ,paei.aei_information3 code_kind
1564: FROM per_assignment_extra_info paei
1565: WHERE paei.assignment_id = p_assignment_id
1566: AND paei.aei_information_category = 'NL_LBR'
1567: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1568: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)

Line 1735: FROM per_assignment_extra_info paei

1731: WHERE pas.assignment_id = p_assignment_id;
1732: /**************************************************************************/
1733: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1734: SELECT paei.aei_information1 numiv_override
1735: FROM per_assignment_extra_info paei
1736: WHERE paei.assignment_id = p_assignment_id
1737: AND paei.aei_information_category = 'NL_NUMIV_OVERRIDE';
1738: /**************************************************************************/
1739:

Line 1764: l_fz_code per_assignment_extra_info.aei_information3%TYPE;

1760: l_sick_ph_no per_phones.phone_number%TYPE;
1761: l_for_sick_ph_no per_phones.phone_number%TYPE;
1762: l_sick_mobile_no per_phones.phone_number%TYPE;
1763: l_job_name per_jobs.name%TYPE;
1764: l_fz_code per_assignment_extra_info.aei_information3%TYPE;
1765: l_contract per_shared_types.system_type_cd%TYPE;
1766: l_action_info_id NUMBER;
1767: l_ovn NUMBER;
1768: l_exists VARCHAR2(1);

Line 1781: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;

1777: l_employer_bank csr_get_employer_bank_info%ROWTYPE;
1778: l_employee_bank csr_get_employee_bank_info%ROWTYPE;
1779: l_lbr_info csr_get_lbr_info%ROWTYPE;
1780: l_assignment_dates csr_get_assignment_dates%ROWTYPE;
1781: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;
1782:
1783: /**************************************************************************/
1784: BEGIN
1785: hr_utility.trace('+====archive_code==========================================+');