APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_CUS_ADDRESSES

Line 1801: FROM JAI_CMN_CUS_ADDRESSES

1797: slno = p_previous_serial_no;
1798:
1799: CURSOR range_division_cur IS
1800: SELECT excise_duty_range,excise_duty_division
1801: FROM JAI_CMN_CUS_ADDRESSES
1802: WHERE customer_id = p_customer_id
1803: AND address_id = (SELECT cust_acct_site_id -- address_id
1804: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
1805: WHERE A.site_use_id = p_customer_site_id);

Line 2299: FROM JAI_CMN_CUS_ADDRESSES

2295: fin_year = p_fin_year AND
2296: inventory_item_id = p_inventory_item_id;
2297: CURSOR range_division_cur IS
2298: SELECT excise_duty_range,excise_duty_division
2299: FROM JAI_CMN_CUS_ADDRESSES
2300: WHERE customer_id = p_customer_id
2301: AND address_id = (SELECT cust_acct_site_id -- address_id
2302: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for BUg# 4434287
2303: WHERE A.site_use_id = p_customer_site_id);

Line 2454: FROM JAI_CMN_CUS_ADDRESSES

2450: register_type = p_register_type;
2451:
2452: CURSOR range_division_cur IS
2453: SELECT excise_duty_range, excise_duty_division
2454: FROM JAI_CMN_CUS_ADDRESSES
2455: WHERE customer_id = p_customer_id
2456: AND address_id = (SELECT cust_acct_site_id -- address_id
2457: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2458: WHERE A.site_use_id = p_customer_site_id);

Line 2867: FROM JAI_CMN_CUS_ADDRESSES

2863: location_id = p_location_id;
2864:
2865: CURSOR range_division_cur IS
2866: SELECT excise_duty_range, excise_duty_division
2867: FROM JAI_CMN_CUS_ADDRESSES
2868: WHERE customer_id = p_customer_id
2869: AND address_id = (SELECT cust_acct_site_id -- address_id
2870: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for Bug# 4434287
2871: WHERE A.site_use_id = p_customer_site_id);