APPS.PJI_PMV_AVL dependencies on PA_RESOURCES_DENORM

Line 1646: -- FROM PA_RESOURCES_DENORM

1642: -- BEFORE GOING INTO THE LOOP
1643: FOR I IN 1..L_AVL_RES_DET_TBL.COUNT LOOP
1644:
1645: -- GET PERSON_ID OF THE RECORD TO GET THE NAME
1646: -- FROM PA_RESOURCES_DENORM
1647: BEGIN
1648: SELECT RESOURCE_NAME
1649: INTO L_AVL_RES_DET_TBL(I).PERSON_NAME
1650: FROM PA_RESOURCES_DENORM

Line 1650: FROM PA_RESOURCES_DENORM

1646: -- FROM PA_RESOURCES_DENORM
1647: BEGIN
1648: SELECT RESOURCE_NAME
1649: INTO L_AVL_RES_DET_TBL(I).PERSON_NAME
1650: FROM PA_RESOURCES_DENORM
1651: WHERE PERSON_ID = L_AVL_RES_DET_TBL(I).PERSON_ID
1652: AND ROWNUM=1;
1653: EXCEPTION
1654: WHEN NO_DATA_FOUND THEN