APPS.FA_SORP_UPG_PKG dependencies on FA_SORP_UPG_CAT

Line 622: FROM fa_sorp_upg_cat

618: CURSOR c_final_cur
619: IS
620: SELECT category_id, capital_adj_acct, capital_adj_account_ccid,
621: general_fund_acct, general_fund_account_ccid
622: FROM fa_sorp_upg_cat
623: WHERE book_type_code = p_book AND validation_flag <> 'I';
624:
625: v_final_cur c_final_cur%ROWTYPE;
626: l_cat_struct NUMBER;

Line 645: DELETE FROM fa_sorp_upg_cat;

641: get_account_seg (p_acct_flex_struct, v_general_fund_ccid);
642: --Get category flex structure
643: l_cat_struct := get_flex_struct ('CAT');
644:
645: DELETE FROM fa_sorp_upg_cat;
646:
647: COMMIT;
648:
649: OPEN c_category_cur;

Line 669: INSERT INTO fa_sorp_upg_cat

665:
666: IF v_category_tab (i).impair_expense_acct IS NULL
667: OR v_category_tab (i).impair_reserve_acct IS NULL
668: THEN
669: INSERT INTO fa_sorp_upg_cat
670: (book_type_code,
671: category_id,
672: reval_amortization_acct,
673: reval_amort_account_ccid,

Line 704: INSERT INTO fa_sorp_upg_cat

700: v_capital_adj_ccid
701: )
702: )
703: THEN
704: INSERT INTO fa_sorp_upg_cat
705: (book_type_code,
706: category_id,
707: reval_amortization_acct,
708: reval_amort_account_ccid,

Line 732: INSERT INTO fa_sorp_upg_cat

728: l_reval_amort_acct_chk_flag, l_category_name,
729: p_run_mode, SYSDATE
730: );
731: ELSE
732: INSERT INTO fa_sorp_upg_cat
733: (book_type_code,
734: category_id,
735: reval_amortization_acct,
736: reval_amort_account_ccid,