1157: SELECT ex.EXCHANGE_RATE_ID,
1158: ex.ORG_ID,
1159: pc.user_id,
1160: pc.selected_org_id
1161: FROM AP_POL_EXRATE_OPTIONS_ALL ex,
1162: AP_POL_CONTEXT pc
1163: WHERE ex.org_id(+) = pc.selected_org_id
1164: AND pc.user_id = p_user_id;
1165:
1165:
1166: BEGIN
1167: FOR user_exrate_options_rec IN user_exrate_options_c LOOP
1168: IF user_exrate_options_rec.exchange_rate_id is null THEN
1169: INSERT INTO ap_pol_exrate_options_all
1170: (exchange_rate_id,
1171: enabled,
1172: default_exchange_rates,
1173: exchange_rate_type,