DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_EXRATE_OPTIONS_ALL

Line 1161: FROM AP_POL_EXRATE_OPTIONS_ALL ex,

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:

Line 1169: INSERT INTO ap_pol_exrate_options_all

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,