36: FROM
37: pa_resource_lists_all_bg
38: WHERE resource_list_id = x_resource_list_id;
39:
40: --This sets the value for resource_list_id of pa_resource_lists_all_bg fro pa_resource_lists_s sequence
41: CURSOR c_res_list_seq_csr IS
42: SELECT pa_resource_lists_s.NEXTVAL
43: FROM
44: SYS.DUAL;
38: WHERE resource_list_id = x_resource_list_id;
39:
40: --This sets the value for resource_list_id of pa_resource_lists_all_bg fro pa_resource_lists_s sequence
41: CURSOR c_res_list_seq_csr IS
42: SELECT pa_resource_lists_s.NEXTVAL
43: FROM
44: SYS.DUAL;
45:
46: BEGIN