eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_ES_WHTAX dependencies on FND_DATE

Line 739: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

735: AND not exists ( select 1
736: from ap_invoice_distributions dist1
737: where dist1.invoice_id = inv.invoice_id
738: and dist1.parent_reversal_id = dist.invoice_distribution_id
739: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
740: and fnd_date.canonical_to_date(P_Date_To)
741: )
742: -- bug 8496890
743: AND trunc(dist.accounting_date,'DD')

Line 740: and fnd_date.canonical_to_date(P_Date_To)

736: from ap_invoice_distributions dist1
737: where dist1.invoice_id = inv.invoice_id
738: and dist1.parent_reversal_id = dist.invoice_distribution_id
739: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
740: and fnd_date.canonical_to_date(P_Date_To)
741: )
742: -- bug 8496890
743: AND trunc(dist.accounting_date,'DD')
744: between fnd_date.canonical_to_date(P_Date_From)

Line 744: between fnd_date.canonical_to_date(P_Date_From)

740: and fnd_date.canonical_to_date(P_Date_To)
741: )
742: -- bug 8496890
743: AND trunc(dist.accounting_date,'DD')
744: between fnd_date.canonical_to_date(P_Date_From)
745: AND fnd_date.canonical_to_date(P_Date_To)
746: AND ((dist.line_type_lookup_code = 'AWT')
747: OR
748: (dist.awt_group_id is not NULL))

Line 745: AND fnd_date.canonical_to_date(P_Date_To)

741: )
742: -- bug 8496890
743: AND trunc(dist.accounting_date,'DD')
744: between fnd_date.canonical_to_date(P_Date_From)
745: AND fnd_date.canonical_to_date(P_Date_To)
746: AND ((dist.line_type_lookup_code = 'AWT')
747: OR
748: (dist.awt_group_id is not NULL))
749: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

Line 860: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

856: */
857: AND not exists (select 1 from ap_invoice_distributions dist1
858: where dist1.invoice_id = inv.invoice_id
859: and dist.parent_reversal_id = dist1.invoice_distribution_id
860: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
861: and fnd_date.canonical_to_date(P_Date_To))
862: -- bug 8496890
863: AND trunc(dist.accounting_date,'DD')
864: between fnd_date.canonical_to_date(P_Date_From)

Line 861: and fnd_date.canonical_to_date(P_Date_To))

857: AND not exists (select 1 from ap_invoice_distributions dist1
858: where dist1.invoice_id = inv.invoice_id
859: and dist.parent_reversal_id = dist1.invoice_distribution_id
860: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
861: and fnd_date.canonical_to_date(P_Date_To))
862: -- bug 8496890
863: AND trunc(dist.accounting_date,'DD')
864: between fnd_date.canonical_to_date(P_Date_From)
865: AND fnd_date.canonical_to_date(P_Date_To)

Line 864: between fnd_date.canonical_to_date(P_Date_From)

860: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
861: and fnd_date.canonical_to_date(P_Date_To))
862: -- bug 8496890
863: AND trunc(dist.accounting_date,'DD')
864: between fnd_date.canonical_to_date(P_Date_From)
865: AND fnd_date.canonical_to_date(P_Date_To)
866: AND ((dist.line_type_lookup_code = 'AWT')
867: OR
868: (dist.awt_group_id is not NULL))

Line 865: AND fnd_date.canonical_to_date(P_Date_To)

861: and fnd_date.canonical_to_date(P_Date_To))
862: -- bug 8496890
863: AND trunc(dist.accounting_date,'DD')
864: between fnd_date.canonical_to_date(P_Date_From)
865: AND fnd_date.canonical_to_date(P_Date_To)
866: AND ((dist.line_type_lookup_code = 'AWT')
867: OR
868: (dist.awt_group_id is not NULL))
869: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

Line 992: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

988: AND not exists ( select 1
989: from ap_invoice_distributions dist1
990: where dist1.invoice_id = inv.invoice_id
991: and dist1.parent_reversal_id = dist.invoice_distribution_id
992: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
993: and fnd_date.canonical_to_date(P_Date_To)
994: )
995: -- bug 8496890
996:

Line 993: and fnd_date.canonical_to_date(P_Date_To)

989: from ap_invoice_distributions dist1
990: where dist1.invoice_id = inv.invoice_id
991: and dist1.parent_reversal_id = dist.invoice_distribution_id
992: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
993: and fnd_date.canonical_to_date(P_Date_To)
994: )
995: -- bug 8496890
996:
997: AND inv.invoice_id = invpay.invoice_id

Line 1005: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)

1001: AND invpay.check_id = checks.check_id
1002: AND checks.void_date is null
1003: AND trunc(invpay.accounting_date,'DD')
1004: between
1005: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1006: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1007: AND (dist.line_type_lookup_code = 'AWT')
1008: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1009: DIST.ACCRUAL_POSTED_FLAG,

Line 1006: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)

1002: AND checks.void_date is null
1003: AND trunc(invpay.accounting_date,'DD')
1004: between
1005: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1006: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1007: AND (dist.line_type_lookup_code = 'AWT')
1008: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1009: DIST.ACCRUAL_POSTED_FLAG,
1010: DIST.CASH_POSTED_FLAG,

Line 1189: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

1185: */
1186: AND not exists (select 1 from ap_invoice_distributions dist1
1187: where dist1.invoice_id = inv.invoice_id
1188: and dist.parent_reversal_id = dist1.invoice_distribution_id
1189: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1190: and fnd_date.canonical_to_date(P_Date_To))
1191: -- bug 8496890
1192: AND inv.invoice_id = invpay.invoice_id
1193: AND ( invpay.posted_flag in ('Y','P')

Line 1190: and fnd_date.canonical_to_date(P_Date_To))

1186: AND not exists (select 1 from ap_invoice_distributions dist1
1187: where dist1.invoice_id = inv.invoice_id
1188: and dist.parent_reversal_id = dist1.invoice_distribution_id
1189: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1190: and fnd_date.canonical_to_date(P_Date_To))
1191: -- bug 8496890
1192: AND inv.invoice_id = invpay.invoice_id
1193: AND ( invpay.posted_flag in ('Y','P')
1194: or invpay.cash_posted_flag in ('Y','P')

Line 1200: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)

1196: AND invpay.check_id = checks.check_id
1197: AND checks.void_date is null
1198: AND trunc(invpay.accounting_date,'DD')
1199: between
1200: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1201: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1202: AND (dist.line_type_lookup_code = 'AWT')
1203: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1204: DIST.ACCRUAL_POSTED_FLAG,

Line 1201: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)

1197: AND checks.void_date is null
1198: AND trunc(invpay.accounting_date,'DD')
1199: between
1200: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1201: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1202: AND (dist.line_type_lookup_code = 'AWT')
1203: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1204: DIST.ACCRUAL_POSTED_FLAG,
1205: DIST.CASH_POSTED_FLAG,

Line 1362: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

1358: AND not exists ( select 1
1359: from ap_invoice_distributions dist1
1360: where dist1.invoice_id = inv.invoice_id
1361: and dist1.parent_reversal_id = dist.invoice_distribution_id
1362: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1363: and fnd_date.canonical_to_date(P_Date_To)
1364: )
1365: -- bug 8496890
1366: AND inv.invoice_id = invpay.invoice_id

Line 1363: and fnd_date.canonical_to_date(P_Date_To)

1359: from ap_invoice_distributions dist1
1360: where dist1.invoice_id = inv.invoice_id
1361: and dist1.parent_reversal_id = dist.invoice_distribution_id
1362: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1363: and fnd_date.canonical_to_date(P_Date_To)
1364: )
1365: -- bug 8496890
1366: AND inv.invoice_id = invpay.invoice_id
1367: AND ( invpay.posted_flag in ('Y','P')

Line 1374: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)

1370: AND invpay.check_id = checks.check_id
1371: AND checks.void_date is null
1372: AND trunc(invpay.accounting_date,'DD')
1373: between
1374: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1375: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1376: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1377: AND (dist.line_type_lookup_code = 'AWT')
1378: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

Line 1375: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)

1371: AND checks.void_date is null
1372: AND trunc(invpay.accounting_date,'DD')
1373: between
1374: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1375: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1376: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1377: AND (dist.line_type_lookup_code = 'AWT')
1378: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1379: DIST.ACCRUAL_POSTED_FLAG,

Line 1557: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

1553: */
1554: AND not exists (select 1 from ap_invoice_distributions dist1
1555: where dist1.invoice_id = inv.invoice_id
1556: and dist.parent_reversal_id = dist1.invoice_distribution_id
1557: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1558: and fnd_date.canonical_to_date(P_Date_To))
1559: -- bug 8496890
1560: AND inv.invoice_id = invpay.invoice_id
1561: AND ( invpay.posted_flag in ('Y','P')

Line 1558: and fnd_date.canonical_to_date(P_Date_To))

1554: AND not exists (select 1 from ap_invoice_distributions dist1
1555: where dist1.invoice_id = inv.invoice_id
1556: and dist.parent_reversal_id = dist1.invoice_distribution_id
1557: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1558: and fnd_date.canonical_to_date(P_Date_To))
1559: -- bug 8496890
1560: AND inv.invoice_id = invpay.invoice_id
1561: AND ( invpay.posted_flag in ('Y','P')
1562: or invpay.cash_posted_flag in ('Y','P')

Line 1568: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)

1564: AND invpay.check_id = checks.check_id
1565: AND checks.void_date is null
1566: AND trunc(invpay.accounting_date,'DD')
1567: between
1568: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1569: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1570: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1571: AND (dist.line_type_lookup_code = 'AWT')
1572: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

Line 1569: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)

1565: AND checks.void_date is null
1566: AND trunc(invpay.accounting_date,'DD')
1567: between
1568: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1569: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1570: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1571: AND (dist.line_type_lookup_code = 'AWT')
1572: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1573: DIST.ACCRUAL_POSTED_FLAG,

Line 1727: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

1723: AND not exists ( select 1
1724: from ap_invoice_distributions dist1
1725: where dist1.invoice_id = inv.invoice_id
1726: and dist1.parent_reversal_id = dist.invoice_distribution_id
1727: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1728: and fnd_date.canonical_to_date(P_Date_To)
1729: )
1730: -- bug 8496890
1731: AND inv.invoice_id = invpay.invoice_id

Line 1728: and fnd_date.canonical_to_date(P_Date_To)

1724: from ap_invoice_distributions dist1
1725: where dist1.invoice_id = inv.invoice_id
1726: and dist1.parent_reversal_id = dist.invoice_distribution_id
1727: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1728: and fnd_date.canonical_to_date(P_Date_To)
1729: )
1730: -- bug 8496890
1731: AND inv.invoice_id = invpay.invoice_id
1732: AND ( invpay.posted_flag in ('Y','P')

Line 1739: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)

1735: AND invpay.check_id = checks.check_id
1736: AND checks.void_date is null
1737: AND trunc(invpay.accounting_date,'DD')
1738: between
1739: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1740: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1741: AND (dist.line_type_lookup_code = 'AWT')
1742: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1743: DIST.ACCRUAL_POSTED_FLAG,

Line 1740: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)

1736: AND checks.void_date is null
1737: AND trunc(invpay.accounting_date,'DD')
1738: between
1739: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1740: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1741: AND (dist.line_type_lookup_code = 'AWT')
1742: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1743: DIST.ACCRUAL_POSTED_FLAG,
1744: DIST.CASH_POSTED_FLAG,

Line 1920: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

1916: */
1917: AND not exists (select 1 from ap_invoice_distributions dist1
1918: where dist1.invoice_id = inv.invoice_id
1919: and dist.parent_reversal_id = dist1.invoice_distribution_id
1920: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1921: and fnd_date.canonical_to_date(P_Date_To))
1922: -- bug 8496890
1923: AND inv.invoice_id = invpay.invoice_id
1924: AND ( invpay.posted_flag in ('Y','P')

Line 1921: and fnd_date.canonical_to_date(P_Date_To))

1917: AND not exists (select 1 from ap_invoice_distributions dist1
1918: where dist1.invoice_id = inv.invoice_id
1919: and dist.parent_reversal_id = dist1.invoice_distribution_id
1920: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
1921: and fnd_date.canonical_to_date(P_Date_To))
1922: -- bug 8496890
1923: AND inv.invoice_id = invpay.invoice_id
1924: AND ( invpay.posted_flag in ('Y','P')
1925: or invpay.cash_posted_flag in ('Y','P')

Line 1931: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)

1927: AND invpay.check_id = checks.check_id
1928: AND checks.void_date is null
1929: AND trunc(invpay.accounting_date,'DD')
1930: between
1931: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1932: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1933: AND (dist.line_type_lookup_code = 'AWT')
1934: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1935: DIST.ACCRUAL_POSTED_FLAG,

Line 1932: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)

1928: AND checks.void_date is null
1929: AND trunc(invpay.accounting_date,'DD')
1930: between
1931: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1932: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1933: AND (dist.line_type_lookup_code = 'AWT')
1934: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1935: DIST.ACCRUAL_POSTED_FLAG,
1936: DIST.CASH_POSTED_FLAG,

Line 2079: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

2075: AND not exists ( select 1
2076: from ap_invoice_distributions dist1
2077: where dist1.invoice_id = inv.invoice_id
2078: and dist1.parent_reversal_id = dist.invoice_distribution_id
2079: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2080: and fnd_date.canonical_to_date(P_Date_To)
2081: )
2082: -- bug 8496890
2083: AND trunc(dist.accounting_date,'DD')

Line 2080: and fnd_date.canonical_to_date(P_Date_To)

2076: from ap_invoice_distributions dist1
2077: where dist1.invoice_id = inv.invoice_id
2078: and dist1.parent_reversal_id = dist.invoice_distribution_id
2079: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2080: and fnd_date.canonical_to_date(P_Date_To)
2081: )
2082: -- bug 8496890
2083: AND trunc(dist.accounting_date,'DD')
2084: between fnd_date.canonical_to_date(P_Date_From)

Line 2084: between fnd_date.canonical_to_date(P_Date_From)

2080: and fnd_date.canonical_to_date(P_Date_To)
2081: )
2082: -- bug 8496890
2083: AND trunc(dist.accounting_date,'DD')
2084: between fnd_date.canonical_to_date(P_Date_From)
2085: and fnd_date.canonical_to_date(P_Date_To)
2086: AND dist.line_type_lookup_code = 'AWT'
2087: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
2088: DIST.ACCRUAL_POSTED_FLAG,

Line 2085: and fnd_date.canonical_to_date(P_Date_To)

2081: )
2082: -- bug 8496890
2083: AND trunc(dist.accounting_date,'DD')
2084: between fnd_date.canonical_to_date(P_Date_From)
2085: and fnd_date.canonical_to_date(P_Date_To)
2086: AND dist.line_type_lookup_code = 'AWT'
2087: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
2088: DIST.ACCRUAL_POSTED_FLAG,
2089: DIST.CASH_POSTED_FLAG,

Line 2233: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

2229: */
2230: AND not exists (select 1 from ap_invoice_distributions dist1
2231: where dist1.invoice_id = inv.invoice_id
2232: and dist.parent_reversal_id = dist1.invoice_distribution_id
2233: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2234: and fnd_date.canonical_to_date(P_Date_To))
2235: -- bug 8496890
2236: AND trunc(dist.accounting_date,'DD')
2237: between fnd_date.canonical_to_date(P_Date_From)

Line 2234: and fnd_date.canonical_to_date(P_Date_To))

2230: AND not exists (select 1 from ap_invoice_distributions dist1
2231: where dist1.invoice_id = inv.invoice_id
2232: and dist.parent_reversal_id = dist1.invoice_distribution_id
2233: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2234: and fnd_date.canonical_to_date(P_Date_To))
2235: -- bug 8496890
2236: AND trunc(dist.accounting_date,'DD')
2237: between fnd_date.canonical_to_date(P_Date_From)
2238: and fnd_date.canonical_to_date(P_Date_To)

Line 2237: between fnd_date.canonical_to_date(P_Date_From)

2233: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2234: and fnd_date.canonical_to_date(P_Date_To))
2235: -- bug 8496890
2236: AND trunc(dist.accounting_date,'DD')
2237: between fnd_date.canonical_to_date(P_Date_From)
2238: and fnd_date.canonical_to_date(P_Date_To)
2239: AND dist.line_type_lookup_code = 'AWT'
2240: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
2241: DIST.ACCRUAL_POSTED_FLAG,

Line 2238: and fnd_date.canonical_to_date(P_Date_To)

2234: and fnd_date.canonical_to_date(P_Date_To))
2235: -- bug 8496890
2236: AND trunc(dist.accounting_date,'DD')
2237: between fnd_date.canonical_to_date(P_Date_From)
2238: and fnd_date.canonical_to_date(P_Date_To)
2239: AND dist.line_type_lookup_code = 'AWT'
2240: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
2241: DIST.ACCRUAL_POSTED_FLAG,
2242: DIST.CASH_POSTED_FLAG,

Line 2327: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

2323: and not exists ( select 1 -- Bug 12616975
2324: from ap_invoice_distributions dist1
2325: where dist1.invoice_id = p_fetch_invoice_id
2326: and dist1.parent_reversal_id = dist.invoice_distribution_id
2327: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2328: and fnd_date.canonical_to_date(P_Date_To)
2329: )
2330: group by withholding_tax_code_id
2331: having (sum(decode(dist.line_type_lookup_code,'AWT',

Line 2328: and fnd_date.canonical_to_date(P_Date_To)

2324: from ap_invoice_distributions dist1
2325: where dist1.invoice_id = p_fetch_invoice_id
2326: and dist1.parent_reversal_id = dist.invoice_distribution_id
2327: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2328: and fnd_date.canonical_to_date(P_Date_To)
2329: )
2330: group by withholding_tax_code_id
2331: having (sum(decode(dist.line_type_lookup_code,'AWT',
2332: nvl(dist.base_amount,dist.amount),0)) = p_fetch_wht_amount);

Line 2351: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

2347: and not exists ( select 1
2348: from ap_invoice_distributions dist1
2349: where dist1.invoice_id = p_fetch_invoice_id
2350: and dist1.parent_reversal_id = dist.invoice_distribution_id
2351: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2352: and fnd_date.canonical_to_date(P_Date_To)
2353: )
2354: group by withholding_tax_code_id
2355: having /*((mod(count(dist.withholding_tax_code_id),2) = 1) and*/ --Bug 3930217

Line 2352: and fnd_date.canonical_to_date(P_Date_To)

2348: from ap_invoice_distributions dist1
2349: where dist1.invoice_id = p_fetch_invoice_id
2350: and dist1.parent_reversal_id = dist.invoice_distribution_id
2351: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2352: and fnd_date.canonical_to_date(P_Date_To)
2353: )
2354: group by withholding_tax_code_id
2355: having /*((mod(count(dist.withholding_tax_code_id),2) = 1) and*/ --Bug 3930217
2356: (sum(decode(dist.line_type_lookup_code,'AWT',

Line 2372: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)

2368: and not exists ( select 1 -- Bug 12616975
2369: from ap_invoice_distributions dist1
2370: where dist1.invoice_id = p_fetch_invoice_id
2371: and dist1.parent_reversal_id = dist.invoice_distribution_id
2372: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2373: and fnd_date.canonical_to_date(P_Date_To)
2374: )
2375: -- Bug 5207771
2376: -- and accounting_date = date_paid1 -- Bug 3930217 : Spanugan 23/12/2004

Line 2373: and fnd_date.canonical_to_date(P_Date_To)

2369: from ap_invoice_distributions dist1
2370: where dist1.invoice_id = p_fetch_invoice_id
2371: and dist1.parent_reversal_id = dist.invoice_distribution_id
2372: and dist1.accounting_date between fnd_date.canonical_to_date(P_Date_From)
2373: and fnd_date.canonical_to_date(P_Date_To)
2374: )
2375: -- Bug 5207771
2376: -- and accounting_date = date_paid1 -- Bug 3930217 : Spanugan 23/12/2004
2377: group by withholding_tax_code_id

Line 2431: date_from := fnd_date.canonical_to_date(P_DATE_FROM); --bug1411547

2427: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || p_legal_entity_id );
2428: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );
2429: fnd_file.put_line( fnd_file.log,' ');
2430:
2431: date_from := fnd_date.canonical_to_date(P_DATE_FROM); --bug1411547
2432: date_to := fnd_date.canonical_to_date(P_DATE_TO); --bug1411547
2433:
2434:
2435: -- Added for bug 5277700.

Line 2432: date_to := fnd_date.canonical_to_date(P_DATE_TO); --bug1411547

2428: fnd_file.put_line( fnd_file.log,'Organization id : ' || p_org_id );
2429: fnd_file.put_line( fnd_file.log,' ');
2430:
2431: date_from := fnd_date.canonical_to_date(P_DATE_FROM); --bug1411547
2432: date_to := fnd_date.canonical_to_date(P_DATE_TO); --bug1411547
2433:
2434:
2435: -- Added for bug 5277700.
2436: SELECT COUNT(*)