[Home] [Help]
974: CURSOR taxable_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER, c_ledger_id NUMBER) IS
975: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
976: FROM zx_rec_nrec_dist zx_dist,
977: xla_distribution_links lnk,
978: xla_ae_headers aeh,
979: xla_ae_lines ael
980: WHERE zx_dist.trx_id = c_trx_id
981: AND lnk.application_id = 200
982: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
992: CURSOR tax_amount_hdr (c_trx_id NUMBER, c_ae_header_id NUMBER, c_event_id NUMBER,c_ledger_id NUMBER) IS
993: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
994: FROM zx_rec_nrec_dist zx_dist,
995: xla_distribution_links lnk,
996: xla_ae_headers aeh,
997: xla_ae_lines ael
998: WHERE zx_dist.trx_id = c_trx_id
999: AND lnk.application_id = 200
1000: AND lnk.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
1012: c_event_id NUMBER, c_ledger_id NUMBER) IS
1013: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1014: FROM zx_rec_nrec_dist zx_dist,
1015: xla_distribution_links lnk,
1016: xla_ae_headers aeh,
1017: xla_ae_lines ael
1018: WHERE zx_dist.trx_id = c_trx_id
1019: AND zx_dist.trx_line_id = c_trx_line_id
1020: AND lnk.application_id = 200
1031: c_event_id NUMBER, c_ledger_id NUMBER) IS
1032: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1033: FROM zx_rec_nrec_dist zx_dist,
1034: xla_distribution_links lnk,
1035: xla_ae_headers aeh,
1036: xla_ae_lines ael
1037: WHERE zx_dist.trx_id = c_trx_id
1038: AND zx_dist.tax_line_id = c_tax_line_id
1039: AND lnk.application_id = 200
1054: c_event_id NUMBER, c_ledger_id NUMBER) IS
1055: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1056: FROM zx_rec_nrec_dist zx_dist,
1057: xla_distribution_links lnk,
1058: xla_ae_headers aeh,
1059: xla_ae_lines ael
1060: WHERE zx_dist.trx_id = c_trx_id
1061: AND zx_dist.tax_line_id = c_tax_line_id
1062: AND zx_dist.rec_nrec_tax_dist_id = c_tax_dist_id
1074: c_event_id NUMBER, c_ledger_id NUMBER) IS
1075: SELECT sum(lnk.DOC_ROUNDING_ENTERED_AMT), sum(lnk.DOC_ROUNDING_ACCTD_AMT)
1076: FROM zx_rec_nrec_dist zx_dist,
1077: xla_distribution_links lnk,
1078: xla_ae_headers aeh,
1079: xla_ae_lines ael
1080: WHERE zx_dist.trx_id = c_trx_id
1081: AND zx_dist.trx_line_id = c_trx_line_id
1082: -- AND zx_dist.trx_line_dist_id = c_trx_line_dist_id