APPS.JL_CO_FA_POST_PKG dependencies on JL_CO_FA_ADJUSTMENTS

Line 32: -- Use this procedure for posting from jl_co_fa_adjustments table to --

28: -- PROCEDURE --
29: -- purge_adjustment --
30: -- --
31: -- DESCRIPTION --
32: -- Use this procedure for posting from jl_co_fa_adjustments table to --
33: -- gl_interface table. --
34: -- PURPOSE: --
35: -- Oracle Applications Rel 11.0 --
36: -- --

Line 109: FROM jl_co_fa_adjustments

105: SELECT source_type_code,
106: debit_credit_flag,
107: code_combination_id,
108: sum(adjustment_amount) x_amount
109: FROM jl_co_fa_adjustments
110: WHERE book_type_code = p_book
111: AND period_counter_created = p_counter
112: AND je_category_name = p_je_category_name
113: AND NVL(posting_flag, 'E') <> 'C'

Line 401: -- Update jl_co_fa_adjustments --

397: END IF;
398:
399:
400: ---------------------------------------------------------
401: -- Update jl_co_fa_adjustments --
402: ---------------------------------------------------------
403:
404: UPDATE jl_co_fa_adjustments
405: SET sequence_line = jl_co_fa_adj_je_header_s.CURRVAL,

Line 404: UPDATE jl_co_fa_adjustments

400: ---------------------------------------------------------
401: -- Update jl_co_fa_adjustments --
402: ---------------------------------------------------------
403:
404: UPDATE jl_co_fa_adjustments
405: SET sequence_line = jl_co_fa_adj_je_header_s.CURRVAL,
406: posting_flag = 'C',
407: last_update_date = x_sysdate,
408: last_updated_by = x_last_updated_by,