APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 236: FROM ar_receivable_applications_all

232: WHERE invoice_payment_id = pn_source_document_id;
233:
234: CURSOR get_receipt_date_cur IS
235: SELECT gl_date
236: FROM ar_receivable_applications_all
237: WHERE receivable_application_id = pn_source_document_id;
238:
239: CURSOR get_dist_date_cur IS
240: SELECT accounting_date

Line 1698: FROM AR_RECEIVABLE_APPLICATIONS_ALL araa,jai_rgm_trx_records jrtr

1694: (SELECT line_amount
1695: FROM jai_ar_trxs
1696: WHERE customer_trx_id = cp_customer_trx_id
1697: )))
1698: FROM AR_RECEIVABLE_APPLICATIONS_ALL araa,jai_rgm_trx_records jrtr
1699: WHERE araa.APPLIED_CUSTOMER_TRX_ID = cp_customer_trx_id
1700: /*Added by Qinglei for bug#13741544 begin*/
1701: AND araa.receivable_application_id = jrtr.source_document_id
1702: AND jrtr.repository_id = p_repository_id

Line 1954: from ar_receivable_applications_all araa,

1950: ,acra.exchange_rate receipt_exchange_rate
1951: ,acra.exchange_rate_type receipt_exchange_rate_type
1952: ,acra.set_of_books_id
1953: /*Added by Qinglei on 05-Jan-2012 for bug#13556198 end*/
1954: from ar_receivable_applications_all araa,
1955: ar_cash_receipts_all acra,
1956: jai_ar_cash_receipts_all jacr,
1957: hz_parties hzp,
1958: hz_cust_accounts hca

Line 1983: AND jrec.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'

1979: FROM jai_rgm_trx_refs jref,
1980: jai_rgm_trx_records jrec
1981: WHERE jrec.source_document_id = p_document_id
1982: AND jref.reference_id = jrec.reference_id
1983: AND jrec.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'
1984: AND jrec.source = 'AR'
1985: AND jrec.source_trx_type = p_source_trx_type
1986: AND jrec.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
1987:

Line 2069: AND jrec.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'

2065: WHERE jref.invoice_id = p_document_id
2066: AND jref.reference_id = jrec.reference_id
2067: AND jref.item_line_id = p_document_line_id
2068: --AND jrec.source_document_id = p_trx_repo_extract.document_line_num
2069: AND jrec.source_table_name = 'AR_RECEIVABLE_APPLICATIONS_ALL'
2070: AND jrec.source = 'AR_CLAIM'
2071: AND jrec.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
2072: /* Bug 13430127 */
2073: CURSOR c_get_line_item(p_organization_id number,p_inventory_item_id number) IS