APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_CMN_DOCUMENT_TAXES

Line 999: cursor c_get_pa_inv_line_tax (cp_line_id jai_cmn_document_taxes.source_doc_line_id%type )

995: --and jtc.tax_type = 'Service'
996: group by service_type_code;
997:
998: -- Bug 5876390, 6012570
999: cursor c_get_pa_inv_line_tax (cp_line_id jai_cmn_document_taxes.source_doc_line_id%type )
1000: is
1001: select sum(tax_amt) service_tax_amount
1002: from jai_cmn_document_taxes jcdt
1003: , jai_cmn_taxes_all jtc

Line 1002: from jai_cmn_document_taxes jcdt

998: -- Bug 5876390, 6012570
999: cursor c_get_pa_inv_line_tax (cp_line_id jai_cmn_document_taxes.source_doc_line_id%type )
1000: is
1001: select sum(tax_amt) service_tax_amount
1002: from jai_cmn_document_taxes jcdt
1003: , jai_cmn_taxes_all jtc
1004: where jcdt.source_doc_line_id = cp_line_id
1005: and jcdt.source_doc_type = jai_constants.PA_DRAFT_INVOICE
1006: and jcdt.tax_id = jtc.tax_id

Line 1017: ( lp_line_id jai_cmn_document_taxes.source_doc_line_id%TYPE) IS

1013: -- Added by Bill Shi for standalone invoice on 2007/09/27
1014: -- Get the service tax amount in AP standalone invoice
1015: --------------------------------------------------------------------------
1016: CURSOR l_get_si_tax_amt_csr
1017: ( lp_line_id jai_cmn_document_taxes.source_doc_line_id%TYPE) IS
1018: SELECT
1019: jasl.service_type_code
1020: , SUM (jcdt.tax_amt)
1021: FROM

Line 1023: , jai_cmn_document_taxes jcdt

1019: jasl.service_type_code
1020: , SUM (jcdt.tax_amt)
1021: FROM
1022: jai_ap_invoice_lines jasl
1023: , jai_cmn_document_taxes jcdt
1024: , jai_cmn_taxes_all jcta
1025: WHERE jasl.invoice_id = jcdt.source_doc_id
1026: AND jasl.invoice_line_number = jcdt.source_doc_line_id
1027: AND jcdt.source_doc_line_id = lp_line_id

Line 1038: ( lp_line_id jai_cmn_document_taxes.source_doc_line_id%TYPE)

1034:
1035: --Added by Lion for bug#6911533 on 2008/04/22
1036: --------------------------------------------------------------------------
1037: CURSOR l_get_si_tax_amt_csr
1038: ( lp_line_id jai_cmn_document_taxes.source_doc_line_id%TYPE)
1039: IS
1040: SELECT
1041: SUM (jcdt.tax_amt)
1042: FROM

Line 1044: , jai_cmn_document_taxes jcdt

1040: SELECT
1041: SUM (jcdt.tax_amt)
1042: FROM
1043: jai_ap_invoice_lines jasl
1044: , jai_cmn_document_taxes jcdt
1045: , jai_cmn_taxes_all jcta
1046: WHERE jasl.invoice_id = p_document_id
1047: AND jasl.parent_invoice_line_number = lp_line_id
1048: AND jasl.invoice_id = jcdt.source_doc_id

Line 1056: ( lp_line_id jai_cmn_document_taxes.source_doc_line_id%TYPE) IS

1052:
1053: GROUP BY jasl.service_type_code;
1054:
1055: CURSOR l_get_si_service_type_csr
1056: ( lp_line_id jai_cmn_document_taxes.source_doc_line_id%TYPE) IS
1057: SELECT
1058: jasl.service_type_code
1059: FROM
1060: jai_ap_invoice_lines jasl