APPS.PSP_GENERAL dependencies on PSP_UPGRADE_115

Line 2627: SELECT NVL(MAX(PHASE),0) INTO l_curr_er_phase FROM PSP_UPGRADE_115 WHERE STATUS ='R' ;

2623: IS
2624: l_curr_er_phase NUMBER;
2625: er_flag BOOLEAN;
2626: BEGIN
2627: SELECT NVL(MAX(PHASE),0) INTO l_curr_er_phase FROM PSP_UPGRADE_115 WHERE STATUS ='R' ;
2628: IF l_curr_er_phase = 10000 THEN
2629: er_flag := TRUE;
2630: ELSE
2631: er_flag := FALSE;