1446: --FOR postal_code.city.county.state
1447:
1448: CURSOR C IS
1449: SELECT 'X'
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
1447:
1448: CURSOR C IS
1449: SELECT 'X'
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
1448: CURSOR C IS
1449: SELECT 'X'
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
1449: SELECT 'X'
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)
1472: --For city.county.state structure
1473:
1474: CURSOR C1 IS
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
1473:
1474: CURSOR C1 IS
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
1474: CURSOR C1 IS
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)
1495: --For city.province and city.state structure
1496:
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
1496:
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)
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