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_UTILITY_PVT dependencies on AMS_STATUS_ORDER_RULES

Line 1748: FROM ams_status_order_rules

1744: l_new_status_code VARCHAR2(30);
1745:
1746: CURSOR c_approval_flag IS
1747: SELECT theme_approval_flag, budget_approval_flag
1748: FROM ams_status_order_rules
1749: WHERE system_status_type = l_status_type
1750: AND current_status_code = l_old_status_code
1751: AND next_status_code = l_new_status_code;
1752:

Line 1855: FROM ams_status_order_rules

1851: l_custom_setup_attr VARCHAR2(4) := 'TAPL';
1852:
1853: CURSOR c_approval_flag IS
1854: SELECT theme_approval_flag, budget_approval_flag
1855: FROM ams_status_order_rules
1856: WHERE system_status_type = l_status_type
1857: AND current_status_code = l_old_status_code
1858: AND next_status_code = l_new_status_code;
1859:

Line 2546: WHERE EXISTS (SELECT * FROM ams_status_order_rules

2542: RETURN VARCHAR2
2543: IS
2544: CURSOR c_stat_det IS
2545: SELECT 1 FROM DUAL
2546: WHERE EXISTS (SELECT * FROM ams_status_order_rules
2547: WHERE current_status_code = p_current_status
2548: AND next_status_code = p_next_status
2549: AND system_status_type = p_status_type ) ;
2550: l_dummy NUMBER ;