APPS.JAI_AR_TRX_LINES_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 532: FROM HZ_CUST_SITE_USES_ALL A

528: WHERE customer_trx_id = v_header_id;
529:
530: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
531: SELECT cust_acct_site_id address_id
532: FROM HZ_CUST_SITE_USES_ALL A
533: WHERE A.site_use_id = NVL(p_ship_to_site_use_id, 0);
534:
535: CURSOR excise_cal_cur IS
536: SELECT A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type

Line 987: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas

983: ln_address_id NUMBER;
984:
985: CURSOR c_get_address IS
986: SELECT hzcas.cust_acct_site_id
987: FROM hz_cust_site_uses_all hzcsu, hz_cust_acct_sites_all hzcas
988: WHERE hzcas.cust_acct_site_id = hzcsu.cust_acct_site_id
989: AND hzcsu.site_use_id = pn_party_site_id
990: AND hzcas.cust_account_id = pn_party_id;
991:

Line 1476: FROM hz_cust_site_uses_all A

1472: ORDER BY line_no;
1473:
1474: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
1475: SELECT cust_acct_site_id address_id
1476: FROM hz_cust_site_uses_all A
1477: WHERE A.site_use_id = p_ship_to_site_use_id;
1478:
1479: CURSOR excise_cal_cur IS
1480: select A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type