APPS.JAI_EXCISE_SCRIPTS_PKG dependencies on JAI_CMN_RG_OTH_BALANCES

Line 699: UPDATE JAI_CMN_RG_OTH_BALANCES

695: ln_prev_balance := ln_closing_balance;
696:
697: END LOOP;
698:
699: UPDATE JAI_CMN_RG_OTH_BALANCES
700: SET balance = ln_prev_balance,
701: last_updated_by = p_last_updated_by,
702: last_update_date = sysdate
703: WHERE org_unit_id = ( SELECT org_unit_id

Line 728: UPDATE JAI_CMN_RG_OTH_BALANCES

724: ln_prev_balance := ln_closing_balance;
725:
726: END LOOP;
727:
728: UPDATE JAI_CMN_RG_OTH_BALANCES
729: SET balance = ln_prev_balance,
730: last_updated_by = p_last_updated_by,
731: last_update_date = sysdate
732: WHERE org_unit_id = ( SELECT org_unit_id

Line 794: UPDATE JAI_CMN_RG_OTH_BALANCES

790: AND balance <> p_closing_balance ;
791:
792: ELSE
793:
794: UPDATE JAI_CMN_RG_OTH_BALANCES
795: SET balance = p_closing_balance
796: WHERE org_unit_id = ( SELECT org_unit_id
797: FROM JAI_CMN_INVENTORY_ORGS
798: WHERE organization_id = p_organization_id

Line 976: FROM JAI_CMN_RG_OTH_BALANCES

972: AND slno = nvl(cp_slno,1) );
973:
974: CURSOR cur_get_final_bal(cp_tax_type VARCHAR2) IS
975: SELECT balance
976: FROM JAI_CMN_RG_OTH_BALANCES
977: WHERE org_unit_id = ( SELECT org_unit_id
978: FROM JAI_CMN_INVENTORY_ORGS
979: WHERE organization_id = p_organization_id
980: AND location_id = p_location_id )

Line 2472: FROM JAI_CMN_RG_OTH_BALANCES

2468: CURSOR cur_get_final_cess_bal(cp_organization_id NUMBER,
2469: cp_location_id NUMBER,
2470: cp_tax_type VARCHAR2) IS
2471: SELECT balance
2472: FROM JAI_CMN_RG_OTH_BALANCES
2473: WHERE org_unit_id = ( SELECT org_unit_id
2474: FROM JAI_CMN_INVENTORY_ORGS
2475: WHERE organization_id = cp_organization_id
2476: AND location_id = cp_location_id )

Line 2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;

2557: gn_exists := null ;
2558:
2559: if p_action = 3 and nvl(p_backup,'N') = 'N' then
2560: raise_application_error(-20054, ' Pls take a backup of the following tables from JA before you
2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;
2562: end if ;
2563:
2564: open c_check_addl_cvd ;
2565: fetch c_check_addl_cvd into gn_exists ;