eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_ENTITLEMENTS_PVT dependencies on DUAL

Line 1683: FROM ( SELECT Cd_SVL_Start Start_Date, Cd_SVL_End End_Date FROM DUAL

1679: ,Cd_RTL_Start IN DATE
1680: ,Cd_RTL_End IN DATE)
1681: IS
1682: SELECT MAX(Start_Date), MIN(End_Date)
1683: FROM ( SELECT Cd_SVL_Start Start_Date, Cd_SVL_End End_Date FROM DUAL
1684: UNION
1685: SELECT Cd_CVL_Start Start_Date, Cd_CVL_End End_Date FROM DUAL
1686: UNION
1687: SELECT Cd_BPL_Start Start_Date, Cd_BPL_End End_Date FROM DUAL

Line 1685: SELECT Cd_CVL_Start Start_Date, Cd_CVL_End End_Date FROM DUAL

1681: IS
1682: SELECT MAX(Start_Date), MIN(End_Date)
1683: FROM ( SELECT Cd_SVL_Start Start_Date, Cd_SVL_End End_Date FROM DUAL
1684: UNION
1685: SELECT Cd_CVL_Start Start_Date, Cd_CVL_End End_Date FROM DUAL
1686: UNION
1687: SELECT Cd_BPL_Start Start_Date, Cd_BPL_End End_Date FROM DUAL
1688: UNION
1689: SELECT Cd_RTL_Start Start_Date, Cd_RTL_End End_Date FROM DUAL);

Line 1687: SELECT Cd_BPL_Start Start_Date, Cd_BPL_End End_Date FROM DUAL

1683: FROM ( SELECT Cd_SVL_Start Start_Date, Cd_SVL_End End_Date FROM DUAL
1684: UNION
1685: SELECT Cd_CVL_Start Start_Date, Cd_CVL_End End_Date FROM DUAL
1686: UNION
1687: SELECT Cd_BPL_Start Start_Date, Cd_BPL_End End_Date FROM DUAL
1688: UNION
1689: SELECT Cd_RTL_Start Start_Date, Cd_RTL_End End_Date FROM DUAL);
1690:
1691: Ld_SVL_Start CONSTANT DATE := P_SVL_Start;

Line 1689: SELECT Cd_RTL_Start Start_Date, Cd_RTL_End End_Date FROM DUAL);

1685: SELECT Cd_CVL_Start Start_Date, Cd_CVL_End End_Date FROM DUAL
1686: UNION
1687: SELECT Cd_BPL_Start Start_Date, Cd_BPL_End End_Date FROM DUAL
1688: UNION
1689: SELECT Cd_RTL_Start Start_Date, Cd_RTL_End End_Date FROM DUAL);
1690:
1691: Ld_SVL_Start CONSTANT DATE := P_SVL_Start;
1692: Ld_SVL_End CONSTANT DATE := P_SVL_End;
1693: Ld_CVL_Start CONSTANT DATE := P_CVL_Start;

Line 2457: FROM DUAL; */

2453: ,TO_CHAR(NEXT_DAY(Cd_Request_Date,Get_NLS_Day_Of_Week(Cv_USA_DY_Char)),'D') React_Day_Num
2454: , DECODE(SIGN((TO_NUMBER(TO_CHAR(NEXT_DAY(Cd_Request_Date,Get_NLS_Day_Of_Week(Cv_USA_DY_Char)),'D')) - TO_NUMBER(TO_CHAR(Cd_Request_Date,'D')))+1),1
2455: ,TO_NUMBER(TO_CHAR(NEXT_DAY(Cd_Request_Date,Get_NLS_Day_Of_Week(Cv_USA_DY_Char)),'D')) - TO_NUMBER(TO_CHAR(Cd_Request_Date,'D'))
2456: ,TO_NUMBER(TO_CHAR(NEXT_DAY(Cd_Request_Date,Get_NLS_Day_Of_Week(Cv_USA_DY_Char)),'D')) - TO_NUMBER(TO_CHAR(Cd_Request_Date,'D')) + 7) ReqDay_Relative
2457: FROM DUAL; */
2458:
2459: CURSOR c_NLS_Day(Cd_Request_Date IN DATE, Cv_USA_DY_Char IN VARCHAR2) IS
2460: SELECT TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'DY')React_Day_Char
2461: ,TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D') React_Day_Num

Line 2465: FROM DUAL;

2461: ,TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D') React_Day_Num
2462: , DECODE(SIGN((TO_NUMBER(TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D')) - TO_NUMBER(TO_CHAR(Cd_Request_Date,'D')))+1),1
2463: ,TO_NUMBER(TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D')) - TO_NUMBER(TO_CHAR(Cd_Request_Date,'D'))
2464: ,TO_NUMBER(TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D')) - TO_NUMBER(TO_CHAR(Cd_Request_Date,'D')) + 7) ReqDay_Relative
2465: FROM DUAL;
2466:
2467:
2468: --
2469:

Line 19004: FROM DUAL;

19000: ,TO_CHAR(SYSDATE+4,'DY','NLS_DATE_LANGUAGE = AMERICAN'),TO_CHAR(SYSDATE+4,'DY')
19001: ,TO_CHAR(SYSDATE+5,'DY','NLS_DATE_LANGUAGE = AMERICAN'),TO_CHAR(SYSDATE+5,'DY')
19002: ,TO_CHAR(SYSDATE+6,'DY','NLS_DATE_LANGUAGE = AMERICAN'),TO_CHAR(SYSDATE+6,'DY')
19003: ,'-1')
19004: FROM DUAL;
19005:
19006: lv_Result VARCHAR2(50);
19007:
19008: BEGIN