DBA Data[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on CSF_R_PLAN_OPTIONS_S1

Line 246: , csf_r_plan_options_s1.NEXTVAL plan_option_id

242: , p_spares_cost NUMBER
243: ) IS
244: SELECT rr.resource_result_id
245: , so.spares_option_id
246: , csf_r_plan_options_s1.NEXTVAL plan_option_id
247: FROM csf_r_resource_results rr, csf_r_spares_options so
248: WHERE rr.request_task_id = p_request_task_id
249: AND rr.resource_id = p_resource_id
250: AND rr.resource_type = p_resource_type

Line 625: , csf_r_plan_options_s1.NEXTVAL plan_option_id

621: , p_spares_cost NUMBER
622: ) IS
623: SELECT rr.resource_result_id
624: , so.spares_option_id
625: , csf_r_plan_options_s1.NEXTVAL plan_option_id
626: FROM csf_r_resource_results rr, csf_r_spares_options so
627: WHERE rr.request_task_id = p_request_task_id
628: AND rr.resource_id = p_resource_id
629: AND rr.resource_type = p_resource_type