APPS.JAI_AP_RPT_APCR_PKG dependencies on AP_AE_LINES_ALL

Line 59: ap_ae_lines_all table.

55: 4. 16/01/2003 Aparajita for bug # 2545466. Version# 615.4
56:
57: Broke the GAIN/LOSS query in the cursor into 4 queries to take care of the
58: 4 different source from which the gain loss record gets populated into
59: ap_ae_lines_all table.
60:
61: Also removed the old code that was earlier commented at the end of this code.
62:
63: There was inconsistancy between the logic followed in the report and this

Line 159: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS

155: -- Bug 4997569. Added by Lakshmi Gopalsami
156: lv_inv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
157: lv_pay_entity_code CONSTANT varchar2(30) := 'AP_PAYMENTS';
158:
159: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS
160: -- query 1
161: SELECT api.invoice_type_lookup_code,
162: DECODE(api.invoice_type_lookup_code,
163: 'CREDIT',

Line 509: gets populated into ap_ae_lines_all table.

505: 4. 16/01/2003 Aparajita for bug # 2545466. Version # 615.4
506:
507: Broke the GAIN/LOSS query in the cursor into 4 queries to take
508: care of the 4 different source from which the gain loss record
509: gets populated into ap_ae_lines_all table.
510:
511: Also removed the old code that was earlier commented at the end
512: of this code.
513:

Line 606: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS --rchandan for bug#4428980

602: lv_inv_entity_code CONSTANT varchar2(30) := 'AP_INVOICES';
603: lv_pay_entity_code CONSTANT varchar2(30) := 'AP_PAYMENTS';
604:
605:
606: CURSOR C_invoices( p_gain ap_ae_lines_all.ae_line_type_code%TYPE,p_loss ap_ae_lines_all.ae_line_type_code%TYPE ) IS --rchandan for bug#4428980
607: -- query 1
608: SELECT api.invoice_type_lookup_code,
609: DECODE(api.invoice_type_lookup_code,
610: 'CREDIT',