APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 4965: FROM HZ_CUST_SITE_USES_ALL A /* Removed ra_site_uses_all for Bug# 4434287 */

4961: WHERE customer_trx_id = v_header_id;
4962:
4963: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
4964: SELECT cust_acct_site_id address_id
4965: FROM HZ_CUST_SITE_USES_ALL A /* Removed ra_site_uses_all for Bug# 4434287 */
4966: WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
4967:
4968: CURSOR excise_cal_cur IS
4969: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type

Line 5929: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287*/

5925: WHERE A.tax_category_id = p_tax_category_id
5926: ORDER BY line_no;
5927:
5928: /* to get address_id */
5929: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287*/
5930: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
5931: SELECT cust_acct_site_id address_id
5932: FROM hz_cust_site_uses_all A
5933: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */

Line 5932: FROM hz_cust_site_uses_all A

5928: /* to get address_id */
5929: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287*/
5930: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
5931: SELECT cust_acct_site_id address_id
5932: FROM hz_cust_site_uses_all A
5933: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */
5934: -- WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
5935:
5936: CURSOR excise_cal_cur IS

Line 6719: FROM hz_cust_site_uses_all hzcsu ,

6715: ln_address_id NUMBER;
6716:
6717: CURSOR c_get_address IS
6718: SELECT hzcas.cust_acct_site_id
6719: FROM hz_cust_site_uses_all hzcsu ,
6720: hz_cust_acct_sites_all hzcas
6721: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
6722: AND hzcsu.site_use_id = pn_party_site_id
6723: AND hzcas.cust_account_id = pn_party_id ;