APPS.JAI_RCV_RND_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 178: FROM JAI_CMN_INVENTORY_ORGS

174: AND fin_active_flag = 'Y';
175:
176: CURSOR c_rg_rounding_account(p_organization_id IN NUMBER) IS
177: SELECT rg_rounding_account_id
178: FROM JAI_CMN_INVENTORY_ORGS
179: WHERE organization_id = p_organization_id
180: AND ( location_id IS NULL OR location_id = 0);
181:
182: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS

Line 184: FROM JAI_CMN_INVENTORY_ORGS

180: AND ( location_id IS NULL OR location_id = 0);
181:
182: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
183: SELECT modvat_rm_account_id, modvat_cg_account_id
184: FROM JAI_CMN_INVENTORY_ORGS
185: WHERE organization_id = p_organization_id
186: AND location_id = p_location_id;
187:
188: ln_receive_qty NUMBER;

Line 2046: FROM JAI_CMN_INVENTORY_ORGS

2042: AND fin_active_flag = 'Y';
2043:
2044: CURSOR c_rg_rounding_account(p_organization_id IN NUMBER) IS
2045: SELECT rg_rounding_account_id
2046: FROM JAI_CMN_INVENTORY_ORGS
2047: WHERE organization_id = p_organization_id
2048: AND ( location_id IS NULL OR location_id = 0);
2049:
2050: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS

Line 2052: FROM JAI_CMN_INVENTORY_ORGS

2048: AND ( location_id IS NULL OR location_id = 0);
2049:
2050: CURSOR c_rg_modvat_account(p_organization_id IN NUMBER, p_location_id IN NUMBER) IS
2051: SELECT modvat_rm_account_id, modvat_cg_account_id, modvat_pla_account_id
2052: FROM JAI_CMN_INVENTORY_ORGS
2053: WHERE organization_id = p_organization_id
2054: AND location_id = p_location_id;
2055:
2056: ln_receive_qty NUMBER;