APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on HZ_PARTY_SITE_USES

Line 88: FROM hz_party_site_uses

84:
85: -- get the party site id
86: CURSOR l_partysiteuses_csr(cp_party_site_use_id IN NUMBER) IS
87: SELECT party_site_id
88: FROM hz_party_site_uses
89: WHERE party_site_use_id = cp_party_site_use_id;
90:
91: --Cursor to get the corresponding hz_location id for the install location id
92: CURSOR l_get_location_id(cp_party_site_id IN NUMBER) IS

Line 101: HZ_PARTY_SITE_USES HZU

97: --Cursor to get the corresponding party_site_id FOR a location id
98: CURSOR l_get_party_site_id(cp_location_id IN NUMBER) IS
99: SELECT HZP.PARTY_SITE_ID
100: FROM HZ_PARTY_SITES HZP,
101: HZ_PARTY_SITE_USES HZU
102: WHERE HZP.LOCATION_ID = cp_location_id
103: AND HZP.party_site_id = HZU.PARTY_SITE_ID
104: AND HZU.SITE_USE_TYPE = 'INSTALL_AT' ;
105:

Line 15648: | PARTY_SITE_USE_ID in hz_party_site_uses

15644: | Date Author Description of Changes
15645: | 08-APR-05 SECHAWLA Created
15646: | 12-DEC-05 SECHAWLA 4690074 - modified cursor l_get_location_id to map
15647: | Install site id of the assets to
15648: | PARTY_SITE_USE_ID in hz_party_site_uses
15649: |
15650: *=======================================================================*/
15651: PROCEDURE process_quoting_upfront_tax(
15652: p_api_version IN NUMBER,

Line 15842: FROM HZ_PARTY_SITES hzp, hz_party_site_uses hsu

15838: -- Cursor to get the corresponding hz_location id for the install location id
15839: CURSOR l_get_location_id(cp_party_site_id IN NUMBER) IS
15840: -- SECHAWLA 12-DEC-05 4690074
15841: SELECT hzp.location_id
15842: FROM HZ_PARTY_SITES hzp, hz_party_site_uses hsu
15843: WHERE hsu.PARTY_SITE_USE_ID = cp_party_site_id
15844: AND hzp.party_Site_id = hsu.party_site_id;
15845:
15846: -- Cursor to get the ship_to_site_use_id corresponding to the install_location_id of the asset