APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on HZ_CUST_SITE_USES_ALL

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

6341: WHERE customer_trx_id = v_header_id;
6342:
6343: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
6344: SELECT cust_acct_site_id address_id
6345: FROM HZ_CUST_SITE_USES_ALL A /* Removed ra_site_uses_all for Bug# 4434287 */
6346: WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
6347:
6348: CURSOR excise_cal_cur IS
6349: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt,b.tax_type t_type

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

7383: WHERE A.tax_category_id = p_tax_category_id
7384: ORDER BY line_no;
7385:
7386: /* to get address_id */
7387: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287*/
7388: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
7389: SELECT cust_acct_site_id address_id
7390: FROM hz_cust_site_uses_all A
7391: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */

Line 7390: FROM hz_cust_site_uses_all A

7386: /* to get address_id */
7387: /* Removed ra_site_uses_all and used hz_cust_site_uses_all for Bug# 4434287*/
7388: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
7389: SELECT cust_acct_site_id address_id
7390: FROM hz_cust_site_uses_all A
7391: WHERE A.site_use_id = p_ship_to_site_use_id; /* Modified by Ramananda for removal of SQL LITERALs */
7392: -- WHERE A.site_use_id = NVL(p_ship_to_site_use_id,0);
7393:
7394: CURSOR excise_cal_cur IS

Line 8216: FROM hz_cust_site_uses_all hzcsu ,

8212: ln_address_id NUMBER;
8213:
8214: CURSOR c_get_address IS
8215: SELECT hzcas.cust_acct_site_id
8216: FROM hz_cust_site_uses_all hzcsu ,
8217: hz_cust_acct_sites_all hzcas
8218: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
8219: AND hzcsu.site_use_id = pn_party_site_id
8220: AND hzcas.cust_account_id = pn_party_id ;