APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 256: l_status ar_cash_receipt_history_all.status%TYPE;

252: l_orig_amount ja_cn_cfs_activities_all.original_amount%type;
253: l_detailed_item_desc varchar2(240);
254: l_period_name gl_periods.period_name%TYPE;
255: l_application_source fnd_application.application_short_name%TYPE;
256: l_status ar_cash_receipt_history_all.status%TYPE;
257: l_je_header_id gl_je_lines.je_header_id%type;
258: l_je_line_num gl_je_lines.je_line_num%type;
259: BEGIN
260: --Get the application short name for source

Line 279: from ar_cash_receipt_history_all ach,

275: THEN
276: begin
277: select ach.status
278: into l_status
279: from ar_cash_receipt_history_all ach,
280: xla_ae_headers ah
281: where ah.ae_header_id = p_cash_ae_header_id
282: ----- choli add this line to fix bug 11777168
283: -- choli change the condition as follow to fix bug 12639420

Line 288: from ar_cash_receipt_history_all

284: --and ach.account_code_combination_id = p_ccid
285:
286: and ach.cash_receipt_history_id =
287: (select max(cash_receipt_history_id)
288: from ar_cash_receipt_history_all
289: where event_id = ah.event_id)
290:
291: -----
292: and ah.event_id = ach.event_id;