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