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 15720: | PARTY_SITE_USE_ID in hz_party_site_uses

15716: | Date Author Description of Changes
15717: | 08-APR-05 SECHAWLA Created
15718: | 12-DEC-05 SECHAWLA 4690074 - modified cursor l_get_location_id to map
15719: | Install site id of the assets to
15720: | PARTY_SITE_USE_ID in hz_party_site_uses
15721: |
15722: *=======================================================================*/
15723: PROCEDURE process_quoting_upfront_tax(
15724: p_api_version IN NUMBER,

Line 15914: FROM HZ_PARTY_SITES hzp, hz_party_site_uses hsu

15910: -- Cursor to get the corresponding hz_location id for the install location id
15911: CURSOR l_get_location_id(cp_party_site_id IN NUMBER) IS
15912: -- SECHAWLA 12-DEC-05 4690074
15913: SELECT hzp.location_id
15914: FROM HZ_PARTY_SITES hzp, hz_party_site_uses hsu
15915: WHERE hsu.PARTY_SITE_USE_ID = cp_party_site_id
15916: AND hzp.party_Site_id = hsu.party_site_id;
15917:
15918: -- Cursor to get the ship_to_site_use_id corresponding to the install_location_id of the asset