APPS.ARP_STAX_MINUS99 dependencies on AR_LOCATION_COMBINATIONS

Line 233: from ar_location_combinations struct

229: struct.location_id_segment_7,
230: struct.location_id_segment_8,
231: struct.location_id_segment_9,
232: struct.location_id_segment_10
233: from ar_location_combinations struct
234: where LOCATION_ID_SEGMENT_1 = location_segment_id
235: or LOCATION_ID_SEGMENT_2 = location_segment_id
236: or LOCATION_ID_SEGMENT_3 = location_segment_id; -- PL/SQL Flexfield Pre-Processor
237: -- Refer to token file: token.pls

Line 423: from ar_location_combinations struct,

419: struct.location_id_segment_7,
420: struct.location_id_segment_8,
421: struct.location_id_segment_9,
422: struct.location_id_segment_10
423: from ar_location_combinations struct,
424: hz_party_sites party_site,
425: hz_loc_assignments loc_assign,
426: hz_locations loc,
427: hz_cust_acct_sites acct_site

Line 589: | the tables: AR_LOCATION_VALUES and AR_LOCATION_COMBINATIONS |

585: | Location_ID column to the Code Combinations ID applicable to this |
586: | address. |
587: | |
588: | In order to do this, it may be necessary to insert new items into |
589: | the tables: AR_LOCATION_VALUES and AR_LOCATION_COMBINATIONS |
590: | |
591: | REQUIRES |
592: | Location_CCID Location ID for ths entry in Sales Tax |
593: | location_id_segments 1 .. 10, Location_segment_id for each segment |

Line 943: update ar_location_combinations

939: IF PG_DEBUG = 'Y' THEN
940: arp_util_tax.debug( '>> PROPOGATE_SALES_TAX' );
941: END IF;
942:
943: update ar_location_combinations
944: set last_update_date = sysdate ,
945: last_updated_by = arp_standard.profile.user_id,
946: program_id = arp_standard.profile.program_id,
947: program_application_id = arp_standard.profile.program_application_id

Line 1313: ar_location_combinations c

1309: hz_cust_acct_sites a,
1310: hz_party_sites p,
1311: hz_loc_assignments la,
1312: ra_tax_exemptions x,
1313: ar_location_combinations c
1314: WHERE la.loc_id = c.location_id(+)
1315: and a.party_site_id = p.party_site_id
1316: and p.location_id = la.location_id
1317: and nvl(a.org_id, -99) = nvl(la.org_id, -99)

Line 1385: from ar_location_combinations c,

1381: c.location_id_segment_7,
1382: c.location_id_segment_8,
1383: c.location_id_segment_9,
1384: c.location_id_segment_10
1385: from ar_location_combinations c,
1386: hz_cust_acct_sites acct_site,
1387: hz_loc_assignments loc_assign,
1388: hz_locations loc,
1389: hz_party_sites party_site,

Line 1951: AR_LOCATION_COMBINATIONS ccid

1947: 'Y'
1948: from ar_location_rates r1,
1949: ar_location_rates r2,
1950: ar_location_rates r3,
1951: AR_LOCATION_COMBINATIONS ccid
1952: where ccid.LOCATION_ID_SEGMENT_1 = r1.location_segment_id and
1953: ccid.LOCATION_ID_SEGMENT_2 = r2.location_segment_id and
1954: ccid.LOCATION_ID_SEGMENT_3 = r3.location_segment_id
1955: and greatest( r1.from_postal_code,