APPS.ARP_TAX_INTERFACE dependencies on AR_LOCATION_RATES

Line 686: from ar_location_rates r

682: r.attribute12,
683: r.attribute13,
684: r.attribute14,
685: r.attribute15
686: from ar_location_rates r
687: where r.location_segment_id = p_location_segment_id
688: and ( p_from_postal_code between r.from_postal_code and r.to_postal_code
689: or p_to_postal_code between r.from_postal_code and r.to_postal_code
690: or (p_from_postal_code <= r.from_postal_code and

Line 943: | Populate table: AR_LOCATION_RATES |

939:
940: END IF; /* Segment Value has not changed, dont attempt to re-insert it */
941:
942: /*-----------------------------------------------------------------------+
943: | Populate table: AR_LOCATION_RATES |
944: *-----------------------------------------------------------------------*/
945:
946: if interface.status = 'IGNORED-NARROWER-ZIP' then
947: action := 'IGNORED-NARROWER-ZIP';

Line 1120: arp_util_tax.debug('Postal Code Range in AR_LOCATION_RATES is included in the one in Interface.');

1116: END IF; -- Checking Date Range
1117:
1118: ELSE
1119: if pg_debug='Y' then
1120: arp_util_tax.debug('Postal Code Range in AR_LOCATION_RATES is included in the one in Interface.');
1121: end if;
1122:
1123: /* Checking Date Range */
1124: IF trunc(rates.start_date) = trunc(interface.start_date) and

Line 1154: update ar_location_rates

1150:
1151: /* BUGFIX: 256136, Updating old records should affect the effective date values
1152: of the old record; no other columns should be touched */
1153:
1154: update ar_location_rates
1155: set start_date = rates.start_date,
1156: end_date = rates.end_date,
1157: program_id = arp_standard.profile.program_id,
1158: program_application_id = arp_standard.profile.program_application_id,

Line 1175: update ar_location_rates

1171: rates.start_date || '->' || rates.end_date ||
1172: ' = ' || rates.tax_rate );
1173: end if;
1174:
1175: update ar_location_rates
1176: set from_postal_code = rates.from_postal_code,
1177: to_postal_code = rates.to_postal_code,
1178: start_date = rates.start_date,
1179: end_date = rates.end_date,

Line 1224: update ar_location_rates

1220: rates.start_date || '->' || rates.end_date ||
1221: ' = ' || rates.tax_rate );
1222:
1223: end if;
1224: update ar_location_rates
1225: set end_date = start_date,
1226: program_id = arp_standard.profile.program_id,
1227: program_application_id = arp_standard.profile.program_application_id,
1228: program_update_date = sysdate,