DBA Data[Home] [Help]

APPS.CSF_REQUESTS_PVT dependencies on CSF_R_PLAN_OPTIONS_S1

Line 266: , csf_r_plan_options_s1.NEXTVAL plan_option_id

262: , p_spares_cost NUMBER
263: ) IS
264: SELECT rr.resource_result_id
265: , so.spares_option_id
266: , csf_r_plan_options_s1.NEXTVAL plan_option_id
267: FROM csf_r_resource_results rr, csf_r_spares_options so
268: WHERE rr.request_task_id = p_request_task_id
269: AND rr.resource_id = p_resource_id
270: AND rr.resource_type = p_resource_type

Line 655: , csf_r_plan_options_s1.NEXTVAL plan_option_id

651: , p_spares_cost NUMBER
652: ) IS
653: SELECT rr.resource_result_id
654: , so.spares_option_id
655: , csf_r_plan_options_s1.NEXTVAL plan_option_id
656: FROM csf_r_resource_results rr, csf_r_spares_options so
657: WHERE rr.request_task_id = p_request_task_id
658: AND rr.resource_id = p_resource_id
659: AND rr.resource_type = p_resource_type