APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on JL_ZZ_FA_RETIREMNT_ADJS

Line 649: INSERT INTO jl_zz_fa_retiremnt_adjs

645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
646: END IF;
647:
648:
649: INSERT INTO jl_zz_fa_retiremnt_adjs
650: (retirement_id,
651: period_counter,
652: distribution_id,
653: book_type_code,

Line 831: FROM jl_zz_fa_retiremnt_adjs

827: SELECT nvl(sum(period_adjustment_amount) * -1,0),
828: max(original_ytd_depreciation) ,
829: max(total_adjustment_amount) - sum(period_adjustment_amount)
830: INTO l_deprn_amount,l_ytd_deprn,l_total_amount
831: FROM jl_zz_fa_retiremnt_adjs
832: WHERE retirement_id = fa_ret_rec.retirement_id
833: AND distribution_id = fa_cat_rec.distribution_id;
834:
835: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 842: INSERT INTO jl_zz_fa_retiremnt_adjs

838: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
839: END IF;
840:
841:
842: INSERT INTO jl_zz_fa_retiremnt_adjs
843: (retirement_id, period_counter, distribution_id,
844: book_type_code, asset_id, transaction_header_id,
845: je_line_id, original_ytd_depreciation, total_adjustment_amount,
846: period_adjustment_amount, status, retire_reinst_flag,

Line 933: FROM jl_zz_fa_retiremnt_adjs a,

929: a.total_adjustment_amount accum_deprn,
930: a.period_adjustment_amount adjst_amount,
931: b.asset_category_id asset_category,
932: rpad(b.asset_number||'-'||substr(b.description,1,30),45,' ') asset_desc
933: FROM jl_zz_fa_retiremnt_adjs a,
934: fa_additions b
935: WHERE a.book_type_code = p_book_type_code
936: AND a.period_counter = g_previous_period_counter
937: AND a.asset_id = b.asset_id

Line 939: FROM jl_zz_fa_retiremnt_adjs c

935: WHERE a.book_type_code = p_book_type_code
936: AND a.period_counter = g_previous_period_counter
937: AND a.asset_id = b.asset_id
938: AND NOT EXISTS (SELECT 1
939: FROM jl_zz_fa_retiremnt_adjs c
940: WHERE c.retirement_id = a.retirement_id
941: AND c.period_counter = g_period_counter1
942: AND c.retire_reinst_flag = 'REI')
943:

Line 1053: INSERT INTO jl_zz_fa_retiremnt_adjs

1049: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, x_char);
1050: END IF;
1051:
1052:
1053: INSERT INTO jl_zz_fa_retiremnt_adjs
1054: (retirement_id,
1055: period_counter,
1056: distribution_id,
1057: book_type_code,

Line 1141: jl_zz_fa_retiremnt_adjs a

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'
1145: AND a.distribution_id = b.distribution_id

Line 1152: jl_zz_fa_retiremnt_adjs a

1148: SELECT nvl(sum(a.period_adjustment_amount),0) adjst_amount,
1149: c.reval_reserve_account_ccid ccid, 2 ident
1150: FROM fa_category_books c,
1151: fa_additions b,
1152: jl_zz_fa_retiremnt_adjs a
1153: WHERE a.book_type_code = p_book_type_code
1154: AND a.period_counter = g_period_counter1
1155: AND a.status = 'N'
1156: AND b.asset_id = a.asset_id

Line 1210: UPDATE jl_zz_fa_retiremnt_adjs

1206: x_sysdate,
1207: x_last_updated_by,
1208: x_last_update_login);
1209:
1210: UPDATE jl_zz_fa_retiremnt_adjs
1211: SET je_line_id = jl_zz_fa_retiremnt_jes_s.currval,
1212: status = 'Y'
1213: WHERE rowid in (
1214: SELECT a.rowid

Line 1216: jl_zz_fa_retiremnt_adjs a

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'
1220: AND a.distribution_id = b.distribution_id