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.AS_STATUSES_PKG dependencies on DUAL

Line 834: from dual;

830: l_batch_size CONSTANT NUMBER := 10000;
831:
832: CURSOR c1 IS
833: select AS_ACCESSES_S.nextval
834: from dual;
835:
836: CURSOR Get_AC_Min_Id IS
837: select min(access_id)
838: from as_accesses_all_all;

Line 1313: from dual;

1309: l_batch_size CONSTANT NUMBER := 10000;
1310:
1311: CURSOR Get_SL_Next_Val IS
1312: select AS_SALES_LEADS_S.nextval
1313: from dual;
1314:
1315: CURSOR Get_SL_Min_Id IS
1316: select min(sales_lead_id)
1317: from as_sales_leads;

Line 1586: from dual;

1582: from as_sales_leads;
1583:
1584: CURSOR Get_SL_Next_Val IS
1585: select AS_SALES_LEADS_S.nextval
1586: from dual;
1587:
1588: CURSOR Get_flag_from_Input(c_in_param_1 VARCHAR2,c_in_param_2 VARCHAR2) IS
1589: select NVL(LEAD_FLAG,'N')
1590: from AS_STATUSES_B

Line 1765: from dual;

1761: l_batch_size CONSTANT NUMBER := 10000;
1762:
1763: CURSOR Get_SL_Next_Val IS
1764: select AS_LEADS_S.nextval
1765: from dual;
1766:
1767: CURSOR Get_SL_Min_Id IS
1768: select min(lead_id)
1769: from as_leads_all;

Line 2038: from dual;

2034: from as_leads_all;
2035:
2036: CURSOR Get_L_Next_Val IS
2037: select AS_LEADS_S.nextval
2038: from dual;
2039:
2040:
2041: CURSOR Get_flag_from_Input(c_in_param_1 VARCHAR2,c_in_param_2 VARCHAR2) IS
2042: select NVL(OPP_FLAG,'N')