297: fcr.actual_start_date,
298: fcr.printer,
299: fcr.number_of_copies,
300: fcr.save_output_flag
301: FROM FND_CONCURRENT_REQUESTS FCR,
302: FND_APPLICATION_VL FA,
303: FND_RESPONSIBILITY_VL FR
304: WHERE fcr.responsibility_id = fr.responsibility_id
305: AND fcr.program_application_id = fa.application_id
304: WHERE fcr.responsibility_id = fr.responsibility_id
305: AND fcr.program_application_id = fa.application_id
306: and fcr.request_id = p_request_id;
307:
308: CURSOR c_get_rs (cp_parent_id fnd_concurrent_requests.parent_request_id%TYPE) IS
309: SELECT parent_request_id,
310: request_type, description
311: FROM fnd_concurrent_requests
312: WHERE request_id = cp_parent_id;
307:
308: CURSOR c_get_rs (cp_parent_id fnd_concurrent_requests.parent_request_id%TYPE) IS
309: SELECT parent_request_id,
310: request_type, description
311: FROM fnd_concurrent_requests
312: WHERE request_id = cp_parent_id;
313:
314:
315: BEGIN