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

Line 202: FROM dual;

198: l_row_id VARCHAR2(40);
199:
200: CURSOR c_seq IS
201: SELECT ams_approval_details_s.NEXTVAL
202: FROM dual;
203:
204: CURSOR c_id_exists (x_id IN NUMBER) IS
205: SELECT 1 FROM dual
206: WHERE EXISTS (SELECT 1 FROM ams_approval_details

Line 205: SELECT 1 FROM dual

201: SELECT ams_approval_details_s.NEXTVAL
202: FROM dual;
203:
204: CURSOR c_id_exists (x_id IN NUMBER) IS
205: SELECT 1 FROM dual
206: WHERE EXISTS (SELECT 1 FROM ams_approval_details
207: WHERE approval_detail_id = x_id);
208: BEGIN
209: --------------------- initialize -----------------------

Line 1566: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

1562: FROM ams_approval_details_vl
1563: WHERE approval_detail_id = id_in;
1564:
1565: cursor c_appr_name1(name_in IN VARCHAR2) IS
1566: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1567: where name = name_in);
1568:
1569: cursor c_appr_name2(name_in IN VARCHAR2, id_in IN NUMBER) IS
1570: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

Line 1570: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

1566: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1567: where name = name_in);
1568:
1569: cursor c_appr_name2(name_in IN VARCHAR2, id_in IN NUMBER) IS
1570: SELECT 1 FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1571: where name = name_in
1572: and approval_detail_id = id_in);
1573:
1574: l_approval_details_rec c_approval_details%ROWTYPE;

Line 1577: SELECT '1' FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL

1573:
1574: l_approval_details_rec c_approval_details%ROWTYPE;
1575: */
1576: cursor c_rule_name(name_in IN VARCHAR2, id_in IN NUMBER) IS
1577: SELECT '1' FROM DUAL WHERE EXISTS (select 1 from AMS_APPROVAL_DETAILS_VL
1578: where name = name_in
1579: and approval_detail_id <> id_in);
1580:
1581: BEGIN

Line 1723: SELECT 1 FROM dual

1719: AND hou.type = nvl(cur_org_type,hou.type)
1720: AND sysdate between hou.date_from and nvl(hou.date_to,sysdate +1 );
1721:
1722: Cursor c_appr_objt_type_exists(id_in IN NUMBER) IS
1723: SELECT 1 FROM dual
1724: WHERE EXISTS (SELECT 1 FROM ams_categories_b
1725: WHERE enabled_flag = 'Y'
1726: AND arc_category_created_for = 'FUND'
1727: AND category_id = id_in);

Line 1730: SELECT 1 from dual

1726: AND arc_category_created_for = 'FUND'
1727: AND category_id = id_in);
1728:
1729: cursor c_cust_setup_id_c_exists(id_in IN NUMBER) IS
1730: SELECT 1 from dual
1731: where EXISTS (select 1 FROM ams_custom_setups_b
1732: WHERE enabled_flag = 'Y'
1733: AND object_type IN ('RCAM','ECAM'));
1734:

Line 1736: SELECT 1 from dual

1732: WHERE enabled_flag = 'Y'
1733: AND object_type IN ('RCAM','ECAM'));
1734:
1735: cursor c_cust_setup_id_exists(id_in IN NUMBER, p_lookup_code IN VARCHAR2) IS
1736: SELECT 1 from dual
1737: where EXISTS (select 1 FROM ams_custom_setups_b
1738: WHERE enabled_flag = 'Y'
1739: AND object_type = p_lookup_code);
1740: BEGIN