APPS.JAI_CMN_RG_TRANSFER_PKG dependencies on JAI_CMN_RG_BALANCES

Line 56: from JAI_CMN_RG_BALANCES

52: lv_credit jai_cmn_rg_others.credit%TYPE ; --rchandan for bug#4428980
53:
54: CURSOR c_rg_balances(p_organization_id NUMBER, p_location_id NUMBER) IS
55: select nvl(rg23a_balance,0), nvl(rg23c_balance,0), nvl(pla_balance,0)
56: from JAI_CMN_RG_BALANCES
57: where organization_id = p_organization_id
58: and location_id = p_location_id;
59:
60: --Added by Sanjikum for cess for Bug #4136939

Line 93: from JAI_CMN_RG_BALANCES

89: AND a.tax_type = NVL(p_tax_type,a.tax_type);
90: /*Bug 5989740 bduvarag end*/
91: CURSOR balances_to_exist IS
92: select count(1)
93: from JAI_CMN_RG_BALANCES
94: where organization_id = p_to_organization_id
95: and location_id = p_to_location_id;
96:
97: CURSOR balance_cur(p_serial_no IN NUMBER, p_org_id NUMBER, p_location_id NUMBER,

Line 196: FROM JAI_CMN_RG_BALANCES_v

192: lv_reference_num jai_cmn_rg_23ac_ii_trxs.reference_num%TYPE ;--rchandan for bug#4428980
193: /*Bug 4543171 bduvarag start*/
194: CURSOR currency_cur IS
195: SELECT currency_code
196: FROM JAI_CMN_RG_BALANCES_v
197: WHERE organization_id = p_Organization_ID and Location_ID = p_Location_ID;
198:
199: /* Added by Ramananda for bug#4404994, start */
200:

Line 813: UPDATE JAI_CMN_RG_BALANCES

809: RAISE_APPLICATION_ERROR(-20119, 'Balances does not exist for From Organization:' ||
810: to_char(p_organization_id) || ' and location:' ||to_char(p_location_id));
811: END IF;
812:
813: UPDATE JAI_CMN_RG_BALANCES
814: SET pla_balance = v_pla_bal,
815: rg23a_balance = v_rg23a_bal,
816: rg23c_balance = v_rg23c_bal
817: WHERE organization_id = p_organization_id

Line 820: UPDATE JAI_CMN_RG_BALANCES

816: rg23c_balance = v_rg23c_bal
817: WHERE organization_id = p_organization_id
818: and location_id = p_location_id;
819:
820: UPDATE JAI_CMN_RG_BALANCES
821: SET pla_balance = v_to_pla_bal,
822: rg23a_balance = v_to_rg23a_bal,
823: rg23c_balance = v_to_rg23c_bal
824: where organization_id = p_to_organization_id