APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 1882: FROM JAI_CMN_CUS_ADDRESSES

1878: slno = p_previous_serial_no;
1879:
1880: CURSOR range_division_cur IS
1881: SELECT excise_duty_range,excise_duty_division
1882: FROM JAI_CMN_CUS_ADDRESSES
1883: WHERE customer_id = p_customer_id
1884: AND address_id = (SELECT cust_acct_site_id -- address_id
1885: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
1886: WHERE A.site_use_id = p_customer_site_id);

Line 2458: FROM JAI_CMN_CUS_ADDRESSES

2454: fin_year = p_fin_year AND
2455: inventory_item_id = p_inventory_item_id;
2456: CURSOR range_division_cur IS
2457: SELECT excise_duty_range,excise_duty_division
2458: FROM JAI_CMN_CUS_ADDRESSES
2459: WHERE customer_id = p_customer_id
2460: AND address_id = (SELECT cust_acct_site_id -- address_id
2461: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for BUg# 4434287
2462: WHERE A.site_use_id = p_customer_site_id);

Line 2619: FROM JAI_CMN_CUS_ADDRESSES

2615: register_type = p_register_type;
2616:
2617: CURSOR range_division_cur IS
2618: SELECT excise_duty_range, excise_duty_division
2619: FROM JAI_CMN_CUS_ADDRESSES
2620: WHERE customer_id = p_customer_id
2621: AND address_id = (SELECT cust_acct_site_id -- address_id
2622: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2623: WHERE A.site_use_id = p_customer_site_id);

Line 3099: FROM JAI_CMN_CUS_ADDRESSES

3095: location_id = p_location_id;
3096:
3097: CURSOR range_division_cur IS
3098: SELECT excise_duty_range, excise_duty_division
3099: FROM JAI_CMN_CUS_ADDRESSES
3100: WHERE customer_id = p_customer_id
3101: AND address_id = (SELECT cust_acct_site_id -- address_id
3102: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
3103: WHERE A.site_use_id = p_customer_site_id);