APPS.JA_AU_FA_BAL_CHG dependencies on JA_AU_BAL_CHG_SOURCE_S

Line 477: from ja_au_bal_chg_source s

473: /* Only depreciable assets */
474:
475: CURSOR C_Bal_Chg_Retirements (C_Retirement_ID NUMBER )IS
476: select nvl(s.bal_chg_applied,0)
477: from ja_au_bal_chg_source s
478: where s.retirement_id = C_retirement_id;
479:
480: CURSOR C_Bal_Chg_Enabled (C_Book_Type_code VARCHAR2) IS
481: SELECT BAL_CHARGE_ENABLED

Line 541: select ja_au_bal_chg_source_s.nextval

537:
538: -- There is no pre existing balancing charge source record therefore create one
539: FND_FILE.Put_Line (V_Log_Out,'...Created New Balancing Charge Source of '||to_Char(v_recoupment));
540:
541: select ja_au_bal_chg_source_s.nextval
542: into v_bal_chg_id
543: from sys.dual;
544:
545:

Line 588: DELETE FROM ja_au_bal_chg_source s

584: -- No balancing charge applications so delete it
585: FND_FILE.Put_Line (V_Log_Out,'...Deleted Balancing Charge Source ');
586:
587: -- Remove the Records
588: DELETE FROM ja_au_bal_chg_source s
589: WHERE s.retirement_id = C_Retirements_REC.retirement_id;
590:
591: -- Update the couter
592: v_reinstatements := v_reinstatements + 1;

Line 604: update ja_au_bal_chg_source s

600: -- reinstatement then this program must have been run
601: -- twice, so the Source record is simply updated to
602: -- the same value.
603:
604: update ja_au_bal_chg_source s
605: set bal_chg_amount = v_recoupment,
606: bal_chg_status =
607: decode(sign(v_recoupment - v_bal_chg_applied),
608: +1,