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 1799: FROM ams_status_order_rules

1795: l_new_status_code VARCHAR2(30);
1796:
1797: CURSOR c_approval_flag IS
1798: SELECT theme_approval_flag, budget_approval_flag
1799: FROM ams_status_order_rules
1800: WHERE system_status_type = l_status_type
1801: AND current_status_code = l_old_status_code
1802: AND next_status_code = l_new_status_code;
1803:

Line 1906: FROM ams_status_order_rules

1902: l_custom_setup_attr VARCHAR2(4) := 'TAPL';
1903:
1904: CURSOR c_approval_flag IS
1905: SELECT theme_approval_flag, budget_approval_flag
1906: FROM ams_status_order_rules
1907: WHERE system_status_type = l_status_type
1908: AND current_status_code = l_old_status_code
1909: AND next_status_code = l_new_status_code;
1910:

Line 2935: WHERE EXISTS (SELECT * FROM ams_status_order_rules

2931: RETURN VARCHAR2
2932: IS
2933: CURSOR c_stat_det IS
2934: SELECT 1 FROM DUAL
2935: WHERE EXISTS (SELECT * FROM ams_status_order_rules
2936: WHERE current_status_code = p_current_status
2937: AND next_status_code = p_next_status
2938: AND system_status_type = p_status_type ) ;
2939: l_dummy NUMBER ;