APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 295: FROM jai_ar_cash_receipts_all

291: --Added by Wenqiong begin
292: CURSOR get_cash_receipt_gl_date_cur IS
293: SELECT
294: GL_DATE
295: FROM jai_ar_cash_receipts_all
296: WHERE cash_receipt_id = pn_document_id;
297: --Added by Wenqiong end
298:
299: --Added by Qiong for bug13555753 begin

Line 303: FROM ar_cash_receipts_all acra,

299: --Added by Qiong for bug13555753 begin
300: --------------------------------------
301: CURSOR get_rev_receipt_gl_date_cur IS
302: SELECT acrh.gl_date gl_date
303: FROM ar_cash_receipts_all acra,
304: ar_cash_receipt_history_all acrh
305: WHERE acra.cash_receipt_id = pn_document_id
306: AND acrh.cash_receipt_id = acra.cash_receipt_id
307: AND acrh.status = 'REVERSED';

Line 1922: from ar_cash_receipts_all acra,

1918: ,jacr.organization_id organization_id
1919: ,jacr.location_id location_id
1920: ,jacr.service_type_code service_type_code
1921: ,acra.reversal_date reversal_date --Added by Qiong for bug13555753
1922: from ar_cash_receipts_all acra,
1923: jai_ar_cash_receipts_all jacr,
1924: hz_parties hzp,
1925: hz_cust_accounts hca
1926: WHERE acra.cash_receipt_id = jacr.cash_receipt_id

Line 1923: jai_ar_cash_receipts_all jacr,

1919: ,jacr.location_id location_id
1920: ,jacr.service_type_code service_type_code
1921: ,acra.reversal_date reversal_date --Added by Qiong for bug13555753
1922: from ar_cash_receipts_all acra,
1923: jai_ar_cash_receipts_all jacr,
1924: hz_parties hzp,
1925: hz_cust_accounts hca
1926: WHERE acra.cash_receipt_id = jacr.cash_receipt_id
1927: AND jacr.document_type = 'Service'

Line 1955: ar_cash_receipts_all acra,

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
1959: WHERE araa.cash_receipt_id = acra.cash_receipt_id

Line 1956: jai_ar_cash_receipts_all jacr,

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
1959: WHERE araa.cash_receipt_id = acra.cash_receipt_id
1960: AND acra.cash_receipt_id = jacr.cash_receipt_id

Line 1972: AND jrec.source_table_name = 'AR_CASH_RECEIPTS_ALL'

1968: FROM jai_rgm_trx_refs jref,
1969: jai_rgm_trx_records jrec
1970: WHERE jrec.source_document_id = p_document_id
1971: AND jref.reference_id = jrec.reference_id
1972: AND jrec.source_table_name = 'AR_CASH_RECEIPTS_ALL'
1973: AND jrec.source = 'AR'
1974: AND jrec.source_trx_type = p_source_trx_type
1975: AND jrec.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
1976: