APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on DUAL

Line 493: FROM DUAL;

489: ,-1,TO_CHAR(ADD_MONTHS(g_effective_date,-12),'YYYY')
490: ,TO_CHAR(g_effective_date,'YYYY'))
491: ,'DD-MM-YYYY')
492: INTO g_last_effective_date
493: FROM DUAL;
494:
495: END IF;
496:
497: END IF;

Line 2801: FROM DUAL

2797: IS
2798:
2799: CURSOR chkformat IS
2800: SELECT 'Y'
2801: FROM DUAL
2802: WHERE LENGTH(NVL(p_sal_grade,'x')) <= 3
2803: AND ASCII( SUBSTR(p_sal_grade,1,1))
2804: BETWEEN 65 AND 90
2805: AND TO_NUMBER(SUBSTR(p_sal_grade,2)) <= 99;