APPS.JAI_RCV_RND_PKG dependencies on JAI_CMN_RG_BALANCES

Line 1470: UPDATE JAI_CMN_RG_BALANCES

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

Line 1476: UPDATE JAI_CMN_RG_BALANCES

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

Line 3157: UPDATE JAI_CMN_RG_BALANCES

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

Line 3163: UPDATE JAI_CMN_RG_BALANCES

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