DBA Data[Home] [Help]

APPS.POA_FACTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

    SELECT NVL(TO_DATE(p_start_date, 'YYYY/MM/DD HH24:MI:SS'), to_date(1,'J'))
    INTO v_start_date
    FROM sys.dual;
Line: 33

    SELECT NVL(TO_DATE(p_end_date, 'YYYY/MM/DD HH24:MI:SS'), sysdate)
    INTO v_end_date
    FROM sys.dual;