eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on XLA_AE_HEADERS

Line 280: xla_ae_headers ah

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
284: --and ach.account_code_combination_id = p_ccid

Line 557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan

553: l_cash_amount_cr xla_ae_lines.accounted_cr%TYPE;
554: l_cash_amount_dr xla_ae_lines.accounted_dr%TYPE;
555: l_cash_app_id xla_ae_lines.application_id%TYPE; -- Fix bug 12542469 Added by shujuan
556:
557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan
558: l_cash_ae_header_id xla_ae_lines.ae_header_id%TYPE;
559: l_cash_ae_line_num xla_ae_lines.ae_line_num%TYPE;
560: l_header_description xla_ae_headers.description%TYPE; --Added by Jar.Wang for Fixing bug 14664279
561: -- dynatical cursor

Line 560: l_header_description xla_ae_headers.description%TYPE; --Added by Jar.Wang for Fixing bug 14664279

556:
557: l_event_type_code xla_ae_headers.event_type_code%TYPE; -- Bug fixing Added by Shujan
558: l_cash_ae_header_id xla_ae_lines.ae_header_id%TYPE;
559: l_cash_ae_line_num xla_ae_lines.ae_line_num%TYPE;
560: l_header_description xla_ae_headers.description%TYPE; --Added by Jar.Wang for Fixing bug 14664279
561: -- dynatical cursor
562: TYPE SLACurTyp IS REF CURSOR;
563: c_sla_lines SLACurTyp;
564: c_cash_lines SLACurTyp;

Line 593: ,xla_ae_headers ah

589: ala.amb_context_code,
590: ala.ac1,
591: al.code_combination_id
592: FROM xla_ae_lines al
593: ,xla_ae_headers ah
594: ,xla_ae_line_acs ala
595: ,fnd_segment_attribute_values fsav
596: ,gl_code_combinations gcc
597: ,ja_cn_ledger_le_bsv_gt glsv

Line 645: ,xla_ae_headers ah

641: ,ah.ae_header_id
642: ,al.ae_line_num
643: ,al.application_id
644: FROM xla_ae_lines al
645: ,xla_ae_headers ah
646: ,xla_ae_line_acs ala
647: ,fnd_segment_attribute_values fsav
648: ,fnd_segment_attribute_values fsav1
649: ,gl_code_combinations gcc

Line 900: FROM XLA_TRANSACTION_ENTITIES xte, xla_ae_headers xah

896: --Get org id of the current sla ae line
897: begin
898: Select xte.SECURITY_ID_INT_1
899: Into l_line_org_id
900: FROM XLA_TRANSACTION_ENTITIES xte, xla_ae_headers xah
901: Where xte.entity_id = xah.entity_id
902: And xte.application_id = xah.application_id
903: And xah.ae_header_id = l_ae_header_id
904: AND xah.application_id = l_application_id;