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 1680: FROM ( SELECT Cd_SVL_Start Start_Date, Cd_SVL_End End_Date FROM DUAL

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

Line 1682: SELECT Cd_CVL_Start Start_Date, Cd_CVL_End End_Date FROM DUAL

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

Line 1684: SELECT Cd_BPL_Start Start_Date, Cd_BPL_End End_Date FROM DUAL

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

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

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

Line 2105: FROM DUAL; */

2101: ,TO_CHAR(NEXT_DAY(Cd_Request_Date,Get_NLS_Day_Of_Week(Cv_USA_DY_Char)),'D') React_Day_Num
2102: , 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
2103: ,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'))
2104: ,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
2105: FROM DUAL; */
2106:
2107: CURSOR c_NLS_Day(Cd_Request_Date IN DATE, Cv_USA_DY_Char IN VARCHAR2) IS
2108: SELECT TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'DY')React_Day_Char
2109: ,TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D') React_Day_Num

Line 2113: FROM DUAL;

2109: ,TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D') React_Day_Num
2110: , 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
2111: ,TO_NUMBER(TO_CHAR(NEXT_DAY(Cd_Request_Date,Cv_USA_DY_Char),'D')) - TO_NUMBER(TO_CHAR(Cd_Request_Date,'D'))
2112: ,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
2113: FROM DUAL;
2114:
2115:
2116: --
2117:

Line 17160: FROM DUAL;

17156: ,TO_CHAR(SYSDATE+4,'DY','NLS_DATE_LANGUAGE = AMERICAN'),TO_CHAR(SYSDATE+4,'DY')
17157: ,TO_CHAR(SYSDATE+5,'DY','NLS_DATE_LANGUAGE = AMERICAN'),TO_CHAR(SYSDATE+5,'DY')
17158: ,TO_CHAR(SYSDATE+6,'DY','NLS_DATE_LANGUAGE = AMERICAN'),TO_CHAR(SYSDATE+6,'DY')
17159: ,'-1')
17160: FROM DUAL;
17161:
17162: lv_Result VARCHAR2(50);
17163:
17164: BEGIN