APPS.CSF_REQUESTS_PVT dependencies on CSF_R_RESOURCE_RESULTS

Line 181: INSERT INTO csf_r_resource_results

177: END IF;
178:
179: IF p_resource_tbl IS NOT NULL AND p_resource_tbl.COUNT > 0 THEN
180: FOR i IN 1 .. p_resource_tbl.LAST LOOP
181: INSERT INTO csf_r_resource_results
182: (
183: resource_result_id
184: , request_task_id
185: , resource_id

Line 197: csf_r_resource_results_s1.NEXTVAL

193: , skill_level
194: , resource_source
195: )
196: VALUES (
197: csf_r_resource_results_s1.NEXTVAL
198: , p_request_task_id
199: , p_resource_tbl(i).resource_id
200: , p_resource_tbl(i).resource_type
201: , NVL(p_resource_tbl(i).territory_rank, '1')

Line 267: FROM csf_r_resource_results rr, csf_r_spares_options so

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
271: AND so.resource_result_id(+) = rr.resource_result_id

Line 656: FROM csf_r_resource_results rr, csf_r_spares_options so

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
660: AND so.resource_result_id(+) = rr.resource_result_id