APPS.PER_NL_LTSRR_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1311: FROM per_assignment_extra_info paei

1307: , p_start_date IN DATE) IS
1308: SELECT to_char(fnd_date.canonical_to_date (paei.aei_information1),'YYYYMMDD') start_date
1309: ,to_char(fnd_date.canonical_to_date (paei.aei_information2),'YYYYMMDD') end_date
1310: ,paei.aei_information3 code_kind
1311: FROM per_assignment_extra_info paei
1312: WHERE paei.assignment_id = p_assignment_id
1313: AND paei.aei_information_category = 'NL_LBR'
1314: AND p_start_date BETWEEN fnd_date.canonical_to_date (paei.aei_information1)
1315: AND nvl (fnd_date.canonical_to_date (paei.aei_information2)

Line 1396: FROM per_assignment_extra_info paei

1392: WHERE pas.assignment_id = p_assignment_id;
1393: /**************************************************************************/
1394: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1395: SELECT paei.aei_information1 numiv_override
1396: FROM per_assignment_extra_info paei
1397: WHERE paei.assignment_id = p_assignment_id
1398: AND paei.aei_information_category = 'NL_NUMIV_OVERRIDE';
1399: /**************************************************************************/
1400:

Line 1427: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;

1423: l_org_contact_info csr_get_org_contact_info%ROWTYPE;
1424: l_sickness_contact csr_get_sickness_contact%ROWTYPE;
1425: l_lbr_info csr_get_lbr_info%ROWTYPE;
1426: l_assignment_dates csr_get_assignment_dates%ROWTYPE;
1427: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;
1428:
1429:
1430: /**************************************************************************/
1431: BEGIN