APPS.POR_TAX_PVT dependencies on HZ_PARTY_SITES

Line 38: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;

34: l_non_recov_tax NUMBER;
35: l_progress PLS_INTEGER;
36:
37: -- Bug 7526131
38: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
39: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
40: l_ship_from_party_site_id NUMBER;
41: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
42: SELECT hzps.location_id

Line 39: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;

35: l_progress PLS_INTEGER;
36:
37: -- Bug 7526131
38: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
39: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
40: l_ship_from_party_site_id NUMBER;
41: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
42: SELECT hzps.location_id
43: FROM hz_party_sites hzps

Line 43: FROM hz_party_sites hzps

39: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
40: l_ship_from_party_site_id NUMBER;
41: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
42: SELECT hzps.location_id
43: FROM hz_party_sites hzps
44: WHERE hzps.party_site_id = ship_from_party_site_id;
45:
46: -- Logging Infra
47: l_procedure_name CONSTANT VARCHAR2(30) := 'calculate_tax';

Line 514: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;

510: l_product_type VARCHAR2(240);
511: l_assessable_value NUMBER;
512:
513: -- Bug 7526131
514: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
515: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
516: l_ship_from_party_site_id NUMBER;
517: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
518: SELECT hzps.location_id

Line 515: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;

511: l_assessable_value NUMBER;
512:
513: -- Bug 7526131
514: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
515: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
516: l_ship_from_party_site_id NUMBER;
517: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
518: SELECT hzps.location_id
519: FROM hz_party_sites hzps

Line 519: FROM hz_party_sites hzps

515: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
516: l_ship_from_party_site_id NUMBER;
517: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
518: SELECT hzps.location_id
519: FROM hz_party_sites hzps
520: WHERE hzps.party_site_id = ship_from_party_site_id;
521:
522: -- Logging Infra
523: l_procedure_name CONSTANT VARCHAR2(30) := 'get_default_tax_attributes';

Line 1019: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;

1015: l_return_status VARCHAR2(60);
1016: l_msg_data VARCHAR2(480);
1017: l_progress PLS_INTEGER;
1018: -- Bug 7526131
1019: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
1020: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
1021: l_ship_from_party_site_id NUMBER;
1022: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
1023: SELECT hzps.location_id

Line 1020: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;

1016: l_msg_data VARCHAR2(480);
1017: l_progress PLS_INTEGER;
1018: -- Bug 7526131
1019: ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
1020: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
1021: l_ship_from_party_site_id NUMBER;
1022: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
1023: SELECT hzps.location_id
1024: FROM hz_party_sites hzps

Line 1024: FROM hz_party_sites hzps

1020: l_ship_from_location_id HZ_PARTY_SITES.LOCATION_ID%TYPE;
1021: l_ship_from_party_site_id NUMBER;
1022: CURSOR get_sfli (ship_from_party_site_id IN NUMBER) IS
1023: SELECT hzps.location_id
1024: FROM hz_party_sites hzps
1025: WHERE hzps.party_site_id = ship_from_party_site_id;
1026:
1027: -- Logging Infra
1028: l_procedure_name CONSTANT VARCHAR2(30) := 'insert_line_det_attr';