499: l_business_group_id NUMBER;
500:
501: cursor c_extract is
502: select business_group_id
503: from PSB_DATA_EXTRACTS
504: where data_extract_id = p_src_data_extract_id;
505: /* Bug No 2579818 End */
506:
507: Cursor l_find_element_csr is
1259:
1260: -- get the set of books, business group for the target data extract
1261: FOR l_data_extract_rec IN (SELECT business_group_id,
1262: set_of_books_id
1263: FROM psb_data_extracts
1264: WHERE data_extract_id = p_data_extract_id)
1265: LOOP
1266: l_business_group_id := l_data_extract_rec.business_group_id;
1267: l_set_of_books_id := l_data_extract_rec.set_of_books_id;