APPS.JAI_RCV_RND_PKG dependencies on JAI_CMN_RG_BALANCES

Line 1471: UPDATE JAI_CMN_RG_BALANCES

1467:
1468: v_statement_no := '16';
1469:
1470: IF v_register_type = 'A' THEN
1471: UPDATE JAI_CMN_RG_BALANCES
1472: SET rg23a_balance = nvl(rg23a_balance, 0) + v_rounded_amount_rg23
1473: WHERE organization_id = p_organization_id
1474: AND location_id = r.location_id;
1475:

Line 1477: UPDATE JAI_CMN_RG_BALANCES

1473: WHERE organization_id = p_organization_id
1474: AND location_id = r.location_id;
1475:
1476: ELSIF v_register_type = 'C' THEN
1477: UPDATE JAI_CMN_RG_BALANCES
1478: SET rg23c_balance = nvl(rg23c_balance, 0) + v_rounded_amount_rg23
1479: WHERE organization_id = p_organization_id
1480: AND location_id = r.location_id;
1481:

Line 3160: UPDATE JAI_CMN_RG_BALANCES

3156:
3157: v_statement_no := '16';
3158:
3159: if v_register_type = 'A' then
3160: UPDATE JAI_CMN_RG_BALANCES
3161: SET rg23a_balance = nvl(rg23a_balance, 0) + v_rounded_amount_rg23
3162: WHERE organization_id = p_organization_id
3163: AND location_id = r.location_id;
3164:

Line 3166: UPDATE JAI_CMN_RG_BALANCES

3162: WHERE organization_id = p_organization_id
3163: AND location_id = r.location_id;
3164:
3165: elsif v_register_type = 'C' then
3166: UPDATE JAI_CMN_RG_BALANCES
3167: SET rg23c_balance = nvl(rg23c_balance, 0) + v_rounded_amount_rg23
3168: WHERE organization_id = p_organization_id
3169: AND location_id = r.location_id;
3170: