APPS.HZ_CUSTOMER_INT dependencies on AR_LOCATION_RATES

Line 1454: ar_location_rates r

1450: FROM ar_location_values v,
1451: ar_location_values pv,
1452: ar_location_values gv,
1453: ar_location_values ggv,
1454: ar_location_rates r
1455: WHERE v.location_structure_id = p_location_structure_id
1456: AND v.location_segment_id = r.location_segment_id
1457: AND v.location_segment_value = UPPER(p_postal_code)
1458: AND v.location_segment_qualifier = 'POSTAL_CODE'

Line 1479: ar_location_rates r

1475: SELECT 'X'
1476: FROM ar_location_values v,
1477: ar_location_values pv,
1478: ar_location_values gv,
1479: ar_location_rates r
1480: WHERE v.location_structure_id = p_location_structure_id
1481: AND v.location_segment_id = r.location_segment_id
1482: AND v.location_segment_value = UPPER(p_city)
1483: AND v.location_segment_qualifier = 'CITY'

Line 1501: ar_location_rates r

1497: CURSOR C2(p_child VARCHAR2,p_parent_value VARCHAR2,p_child_value VARCHAR2) IS
1498: SELECT 'X'
1499: FROM ar_location_values v,
1500: ar_location_values gv,
1501: ar_location_rates r
1502: WHERE v.location_structure_id = p_location_structure_id
1503: AND v.location_segment_id = r.location_segment_id
1504: AND v.location_segment_value = UPPER(p_child_value)
1505: AND v.location_segment_qualifier = p_child

Line 1518: FROM ar_location_values v, ar_location_rates r

1514: --For city and province Structure
1515:
1516: CURSOR C3(p_segment VARCHAR2,p_value VARCHAR2) IS
1517: SELECT 'X'
1518: FROM ar_location_values v, ar_location_rates r
1519: WHERE v.location_structure_id = p_location_structure_id
1520: AND v.location_segment_id = r.location_segment_id
1521: AND v.location_segment_value = UPPER(p_value)
1522: AND v.location_segment_qualifier = p_segment