APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_EXRATE_OPTIONS_ALL

Line 1186: FROM AP_POL_EXRATE_OPTIONS_ALL ex,

1182: SELECT ex.EXCHANGE_RATE_ID,
1183: ex.ORG_ID,
1184: pc.user_id,
1185: pc.selected_org_id
1186: FROM AP_POL_EXRATE_OPTIONS_ALL ex,
1187: AP_POL_CONTEXT pc
1188: WHERE ex.org_id(+) = pc.selected_org_id
1189: AND pc.user_id = p_user_id;
1190:

Line 1194: INSERT INTO ap_pol_exrate_options_all

1190:
1191: BEGIN
1192: FOR user_exrate_options_rec IN user_exrate_options_c LOOP
1193: IF user_exrate_options_rec.exchange_rate_id is null THEN
1194: INSERT INTO ap_pol_exrate_options_all
1195: (exchange_rate_id,
1196: enabled,
1197: default_exchange_rates,
1198: exchange_rate_type,