[Home] [Help]
1161: CURSOR l_position_sets_csr is
1162: SELECT aps.name,
1163: effective_start_date,
1164: effective_end_date
1165: FROM psb_set_relations rels, psb_account_position_sets aps
1166: WHERE rels.account_position_set_id = aps.account_position_set_id
1167: AND aps.data_extract_id = p_source_data_extract_id
1168: AND rels.position_set_group_id = l_source_set_group_id;
1169:
1168: AND rels.position_set_group_id = l_source_set_group_id;
1169:
1170: CURSOR l_account_sets_csr is
1171: SELECT account_position_set_id
1172: FROM psb_account_position_sets
1173: WHERE name = l_set_name
1174: AND data_extract_id = p_target_data_extract_id;
1175:
1176: CURSOR l_account_distr_csr is