APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 552: FROM fa_distribution_history

548: ORDER BY c.asset_number;
549:
550: CURSOR fa_cat(l_asset_id in number) IS
551: SELECT distribution_id,code_combination_id
552: FROM fa_distribution_history
553: WHERE book_type_code = g_distribution_source_book
554: AND asset_id = l_asset_id
555: AND transaction_header_id_out is null;
556:

Line 559: l_dist_ccid fa_distribution_history.code_combination_id%TYPE;

555: AND transaction_header_id_out is null;
556:
557:
558: l_accum_deprn fa_deprn_summary.deprn_reserve%TYPE := 0;
559: l_dist_ccid fa_distribution_history.code_combination_id%TYPE;
560: l_deprn_amount fa_deprn_summary.deprn_amount%TYPE := 0;
561: l_amount_out VARCHAR2(20);
562: l_api_name CONSTANT VARCHAR2(30) := 'CURRENT_PERIOD_RETIREMENTS';
563:

Line 754: FROM fa_distribution_history b, fa_distribution_history a

750: ORDER BY c.asset_number;
751:
752: CURSOR fa_cat(l_asset_id in number) IS
753: SELECT b.distribution_id,b.code_combination_id
754: FROM fa_distribution_history b, fa_distribution_history a
755: WHERE a.book_type_code = g_distribution_source_book
756: AND a.asset_id = l_asset_id
757: AND a.transaction_header_id_out is null
758: AND b.book_type_code = a.book_type_code

Line 763: l_dist_ccid fa_distribution_history.code_combination_id%TYPE;

759: AND b.asset_id = a.asset_id
760: AND b.transaction_header_id_out = a.transaction_header_id_in;
761:
762: l_accum_deprn fa_deprn_summary.deprn_reserve%TYPE;
763: l_dist_ccid fa_distribution_history.code_combination_id%TYPE;
764: l_deprn_amount fa_deprn_summary.deprn_amount%TYPE;
765: l_ytd_deprn fa_deprn_summary.deprn_amount%TYPE;
766: l_total_amount fa_deprn_summary.deprn_amount%TYPE;
767: l_amount_out VARCHAR2(20);

Line 917: l_dist_ccid fa_distribution_history.code_combination_id%TYPE;

913: l_period_adj_amount NUMBER :=0;
914: l_adj_accum_deprn NUMBER :=0;
915: l_deprn_ccid NUMBER(15);
916: l_adjustment_rate NUMBER :=0;
917: l_dist_ccid fa_distribution_history.code_combination_id%TYPE;
918: l_amount_out VARCHAR2(20);
919: l_api_name CONSTANT VARCHAR2(30) := 'ADJUST_PREVIOUS_RETIREMENTS';
920:
921:

Line 1098: FROM fa_distribution_history

1094: -- Get account concatenated segments --
1095: ------------------------------------------------------------
1096: SELECT code_combination_id
1097: INTO l_dist_ccid
1098: FROM fa_distribution_history
1099: WHERE distribution_id = fa_adjst_rec.distribution_id;
1100:
1101: get_segs(l_dist_ccid);
1102:

Line 1140: FROM fa_distribution_history b,

1136:
1137: CURSOR fa_adjst IS
1138: SELECT nvl(sum(a.period_adjustment_amount),0) adjst_amount,
1139: b.code_combination_id ccid, 1 ident
1140: FROM fa_distribution_history b,
1141: jl_zz_fa_retiremnt_adjs a
1142: WHERE a.book_type_code = p_book_type_code
1143: AND a.period_counter = g_period_counter1
1144: AND a.status = 'N'

Line 1215: FROM fa_distribution_history b,

1211: SET je_line_id = jl_zz_fa_retiremnt_jes_s.currval,
1212: status = 'Y'
1213: WHERE rowid in (
1214: SELECT a.rowid
1215: FROM fa_distribution_history b,
1216: jl_zz_fa_retiremnt_adjs a
1217: WHERE a.book_type_code = p_book_type_code
1218: AND a.period_counter = g_period_counter1
1219: AND a.status = 'N'