APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_AR_TRX_LINES

Line 955: cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%type)

951: and jpollt.tax_type IN (jai_constants.tax_type_service,jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)
952: --and jpollt.tax_type = 'Service'
953: group by service_type_code;
954:
955: cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%type)
956: is
957: select service_type_code, sum(jrcttl.tax_amount) service_tax_amount
958: from JAI_AR_TRX_LINES jrctl
959: ,JAI_AR_TRX_TAX_LINES jrcttl

Line 958: from JAI_AR_TRX_LINES jrctl

954:
955: cursor c_get_ra_line_srvtyp (cp_customer_trx_line_id jai_ar_trx_lines.customer_trx_line_id%type)
956: is
957: select service_type_code, sum(jrcttl.tax_amount) service_tax_amount
958: from JAI_AR_TRX_LINES jrctl
959: ,JAI_AR_TRX_TAX_LINES jrcttl
960: ,jai_cmn_taxes_all jtc
961: where jrctl.customer_trx_line_id = cp_customer_trx_line_id
962: and jrcttl.link_to_cust_trx_line_id = jrctl.customer_trx_line_id

Line 1775: update JAI_AR_TRX_LINES set service_type_code = rec.service_type_code

1771: and line_id = rec.document_line_id;
1772:
1773: elsif rec.transaction_source = 'RECEIVABLES' then
1774:
1775: update JAI_AR_TRX_LINES set service_type_code = rec.service_type_code
1776: , last_update_date = sysdate
1777: , last_updated_by = lv_user_id
1778: , last_update_login = lv_login_id
1779: where customer_trx_id = rec.document_id

Line 1849: update jai_ar_trx_lines

1845: -- Bug 5876390, 6012570
1846:
1847: if rec.transaction_source in ('PROJECTS','ORDER MANAGEMENT') then
1848: -- In case of project and order invoices the invoice also should be updated
1849: update jai_ar_trx_lines
1850: set service_type_code = rec.service_type_code
1851: , last_update_date = sysdate
1852: , last_updated_by = lv_user_id
1853: , last_update_login = lv_login_id