DBA Data[Home] [Help]

APPS.PER_NL_DSRR_ARCHIVE dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1377: FROM per_assignment_extra_info paei

1373: AND paa.assignment_action_id = c_assignment_action_id;
1374: /**************************************************************************/
1375: CURSOR csr_numiv_override(p_assignment_id IN NUMBER) IS
1376: SELECT paei.aei_information1 numiv_override
1377: FROM per_assignment_extra_info paei
1378: WHERE paei.assignment_id = p_assignment_id
1379: AND paei.aei_information_category = 'NL_NUMIV_OVERRIDE';
1380: /**************************************************************************/
1381:

Line 1407: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;

1403:
1404: l_sickness_contact csr_get_sickness_contact%ROWTYPE;
1405: l_person_info csr_get_person_info%ROWTYPE;
1406: l_org_contact_info csr_get_org_contact_info%ROWTYPE;
1407: l_numiv_override per_assignment_extra_info.aei_information1%TYPE;
1408:
1409:
1410:
1411: