APPS.JL_ZZ_FA_DEPRN_ADJ_PKG dependencies on JL_ZZ_FA_RETIREMNT_JES

Line 1185: INSERT INTO jl_zz_fa_retiremnt_jes

1181:
1182: FOR fa_adjst_rec IN fa_adjst
1183: LOOP
1184:
1185: INSERT INTO jl_zz_fa_retiremnt_jes
1186: (je_line_id, book_type_code, period_counter,
1187: code_combination_id, set_of_books_id, request_id,
1188: currency_code, adjustment_amount, debit_credit_flag,
1189: posting_flag, last_update_date, last_updated_by,

Line 1193: jl_zz_fa_retiremnt_jes_s.nextval,

1189: posting_flag, last_update_date, last_updated_by,
1190: creation_date, created_by, last_update_login)
1191:
1192: VALUES (
1193: jl_zz_fa_retiremnt_jes_s.nextval,
1194: p_book_type_code,
1195: g_period_counter1,
1196: fa_adjst_rec.ccid,
1197: g_set_of_books_id,

Line 1211: SET je_line_id = jl_zz_fa_retiremnt_jes_s.currval,

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
1215: FROM fa_distribution_history b,

Line 1251: FROM jl_zz_fa_retiremnt_jes

1247: --
1248: CURSOR jes_lines IS
1249: SELECT set_of_books_id,currency_code,adjustment_amount,
1250: code_combination_id,je_line_id,debit_credit_flag flag
1251: FROM jl_zz_fa_retiremnt_jes
1252: WHERE request_id = x_request_id
1253: FOR UPDATE OF posting_flag;
1254:
1255: l_group_id GL_INTERFACE.GROUP_ID%TYPE;

Line 1317: UPDATE jl_zz_fa_retiremnt_jes

1313: l_group_id);
1314:
1315: END LOOP;
1316:
1317: UPDATE jl_zz_fa_retiremnt_jes
1318: SET posting_flag = 'Y'
1319: WHERE request_id = x_request_id;
1320:
1321: g_step := '';