DBA Data[Home] [Help]

APPS.PER_NL_LTSR_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1348: FROM per_assignment_extra_info paei

1344: AND paa.assignment_action_id = c_assignment_action_id;
1345: /**************************************************************************/
1346: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1347: SELECT paei.aei_information1 numiv_override
1348: FROM per_assignment_extra_info paei
1349: WHERE paei.assignment_id = p_assignment_id
1350: AND paei.aei_information_category = 'NL_NUMIV_OVERRIDE';
1351: /**************************************************************************/
1352:

Line 1376: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;

1372: l_chunk_number NUMBER;
1373: l_person_info csr_get_person_info%ROWTYPE;
1374: l_org_contact_info csr_get_org_contact_info%ROWTYPE;
1375: l_sickness_contact csr_get_sickness_contact%ROWTYPE;
1376: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;
1377:
1378:
1379: BEGIN
1380: