APPS.OZF_ACTIVITY_DENORM_PVT dependencies on FND_CONCURRENT_REQUESTS

Line 117: FROM fnd_concurrent_requests

113: AND concurrent_program_name = 'OZFOEPD';
114:
115: CURSOR c_get_latest_comp_date(l_conc_program_id NUMBER, l_app_id NUMBER) IS
116: SELECT max(actual_completion_date)
117: FROM fnd_concurrent_requests
118: WHERE program_application_id = l_app_id
119: AND concurrent_program_id = l_conc_program_id
120: --16-APR-2007 kdass added for bug 5975207
121: AND (argument2 = NVL(p_offer_id,0) OR argument2 IS NULL)