APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on JAI_AR_TRX_TAX_LINES

Line 503: JAI_AR_TRX_TAX_LINES jtrxtl ,

499: ra_customer_trx_all trx ,
500: JAI_AR_TRXS jtrx ,
501: ra_cust_trx_types_all trx_types ,
502: JAI_AR_TRX_LINES jtrxl ,
503: JAI_AR_TRX_TAX_LINES jtrxtl ,
504: JAI_CMN_TAXES_ALL jtc
505: WHERE
506: trx.org_id = nvl(p_org_id,trx.org_id) AND
507: trx.complete_flag ='Y' AND

Line 1148: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;

1144: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1145: lv_source_trx_type VARCHAR2(50) ;
1146: ln_eff_cm_tottax_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1147: ln_tot_effcm_rb_amt JAI_RGM_TRX_REFS.RECOVERABLE_AMOUNT%TYPE ;
1148: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
1149: ln_sign_of_credit_memo NUMBER ;
1150: ln_cm_ref_ratio NUMBER ;
1151: ln_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
1152: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE := -1 ;

Line 1259: JAI_AR_TRX_TAX_LINES jrttl

1255: SELECT
1256: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1257: FROM
1258: JAI_AR_TRX_LINES jrtl ,
1259: JAI_AR_TRX_TAX_LINES jrttl
1260: WHERE
1261: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1262: jrtl.customer_trx_id = cp_inv_customer_trx_id ;
1263:

Line 1274: JAI_AR_TRX_TAX_LINES jrttl

1270: SELECT
1271: sign(nvl(sum(jrttl.tax_amount),0)) sign_of_credit_memo
1272: FROM
1273: JAI_AR_TRX_LINES jrtl ,
1274: JAI_AR_TRX_TAX_LINES jrttl
1275: WHERE
1276: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1277: jrtl.customer_trx_id = cp_cm_customer_trx_id;
1278:

Line 1290: , JAI_AR_TRX_TAX_LINES jrttl

1286: SELECT
1287: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1288: FROM
1289: JAI_AR_TRX_LINES jrtl
1290: , JAI_AR_TRX_TAX_LINES jrttl
1291: , jai_cmn_taxes_all tax
1292: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1293: AND jrtl.customer_trx_id = pn_cm_customer_trx_id
1294: AND jrttl.tax_id = tax.tax_id

Line 1863: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;

1859: ln_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ;
1860: ln_eff_cr_tax_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_APPLIED%TYPE ;
1861: ln_eff_cr_disc_amount AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ;
1862: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
1863: ln_inv_tot_tax_amt JAI_AR_TRX_TAX_LINES.TAX_AMOUNT%TYPE ;
1864: lv_process_flag VARCHAR2(2) ;
1865: lv_process_message VARCHAR2(1996) ;
1866: lv_source_trx_type VARCHAR2(50) ;
1867: lv_attribute_context VARCHAR2(50) ;

Line 1964: JAI_AR_TRX_TAX_LINES jrttl

1960: SELECT
1961: nvl(sum(jrttl.tax_amount),0) inv_tot_tax_amount
1962: FROM
1963: JAI_AR_TRX_LINES jrtl ,
1964: JAI_AR_TRX_TAX_LINES jrttl
1965: WHERE
1966: jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id AND
1967: jrtl.customer_trx_id = cp_inv_customer_trx_id ;
1968:

Line 1980: , JAI_AR_TRX_TAX_LINES jrttl

1976: SELECT
1977: nvl(sum(jrttl.tax_amount),0) inv_tot_inclusive_tax_amt
1978: FROM
1979: JAI_AR_TRX_LINES jrtl
1980: , JAI_AR_TRX_TAX_LINES jrttl
1981: , jai_cmn_taxes_all tax
1982: WHERE jrtl.customer_trx_line_id = jrttl.link_to_cust_trx_line_id
1983: AND jrtl.customer_trx_id = pn_inv_customer_trx_id
1984: AND jrttl.tax_id = tax.tax_id