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.OZF_UTILITY_PVT dependencies on AMS_STATUS_ORDER_RULES

Line 1824: FROM ams_status_order_rules

1820: l_new_status_code VARCHAR2(30);
1821:
1822: CURSOR c_approval_flag IS
1823: SELECT theme_approval_flag, budget_approval_flag
1824: FROM ams_status_order_rules
1825: WHERE system_status_type = l_status_type
1826: AND current_status_code = l_old_status_code
1827: AND next_status_code = l_new_status_code;
1828:

Line 1931: FROM ams_status_order_rules

1927: l_custom_setup_attr VARCHAR2(4) := 'TAPL';
1928:
1929: CURSOR c_approval_flag IS
1930: SELECT theme_approval_flag, budget_approval_flag
1931: FROM ams_status_order_rules
1932: WHERE system_status_type = l_status_type
1933: AND current_status_code = l_old_status_code
1934: AND next_status_code = l_new_status_code;
1935:

Line 2957: WHERE EXISTS (SELECT * FROM ams_status_order_rules

2953: RETURN VARCHAR2
2954: IS
2955: CURSOR c_stat_det IS
2956: SELECT 1 FROM DUAL
2957: WHERE EXISTS (SELECT * FROM ams_status_order_rules
2958: WHERE current_status_code = p_current_status
2959: AND next_status_code = p_next_status
2960: AND system_status_type = p_status_type ) ;
2961: l_dummy NUMBER ;