APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_AR_TRXS

Line 888: ,jai_ar_trxs jrct

884: ,jrct.organization_id organization_id
885: ,jrct.location_id location_id
886: from ra_customer_trx_all rct
887: ,ra_customer_trx_lines_all rctl
888: ,jai_ar_trxs jrct
889: ,hz_parties hzp
890: ,hz_cust_accounts hzca
891: ,mtl_system_items msi
892: where rct.customer_trx_id = p_document_id

Line 1970: cursor c_get_loc_from_invoice (cp_customer_trx_id jai_ar_trxs.customer_trx_id%type)

1966: AND jail.invoice_line_number = aida.invoice_line_number
1967: AND jail.invoice_id = lp_invoice_id
1968: AND aida.invoice_line_number = lp_invoice_line_number; -- Modified by Lion for bug#6977917
1969: --------------------------------------------------------------------------
1970: cursor c_get_loc_from_invoice (cp_customer_trx_id jai_ar_trxs.customer_trx_id%type)
1971: is
1972: select location_id
1973: from jai_ar_trxs
1974: where customer_trx_id = cp_customer_trx_id ;

Line 1973: from jai_ar_trxs

1969: --------------------------------------------------------------------------
1970: cursor c_get_loc_from_invoice (cp_customer_trx_id jai_ar_trxs.customer_trx_id%type)
1971: is
1972: select location_id
1973: from jai_ar_trxs
1974: where customer_trx_id = cp_customer_trx_id ;
1975:
1976: -- Begin 5876390, 6012570
1977: cursor c_get_jai_pa_details (cp_project_number pa_projects_all.segment1%type