DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 2183: FROM JAI_CMN_INVENTORY_ORGS

2179:
2180:
2181: CURSOR c_pla_account(cp_inv_orgn_id number , cp_locn_id number) IS
2182: SELECT modvat_pla_account_id
2183: FROM JAI_CMN_INVENTORY_ORGS
2184: WHERE organization_id = cp_inv_orgn_id
2185: AND location_id = cp_locn_id;
2186:
2187: /*

Line 2194: FROM JAI_CMN_INVENTORY_ORGS

2190: */
2191: CURSOR c_rg23a_account (cp_inv_orgn_id number , cp_locn_id number)
2192: IS
2193: SELECT modvat_rm_account_id
2194: FROM JAI_CMN_INVENTORY_ORGS
2195: WHERE organization_id = cp_inv_orgn_id
2196: AND location_id = cp_locn_id;
2197:
2198: --start additions for bug#8873924

Line 2202: FROM JAI_CMN_INVENTORY_ORGS

2198: --start additions for bug#8873924
2199: CURSOR c_rg23c_account (cp_inv_orgn_id number , cp_locn_id number)
2200: IS
2201: SELECT modvat_cg_account_id
2202: FROM JAI_CMN_INVENTORY_ORGS
2203: WHERE organization_id = cp_inv_orgn_id
2204: AND location_id = cp_locn_id;
2205:
2206: --start additions for bug#8873924

Line 2210: FROM JAI_CMN_INVENTORY_ORGS

2206: --start additions for bug#8873924
2207:
2208: CURSOR pref_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
2209: SELECT pref_rg23a, pref_rg23c
2210: FROM JAI_CMN_INVENTORY_ORGS
2211: WHERE organization_id = p_organization_id
2212: AND location_id = p_location_id ;
2213:
2214: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS