APPS.JE_ES_WHTAX dependencies on FND_DATE

Line 717: between fnd_date.canonical_to_date(P_Date_From)

713: and gl.ledger_id = dist1.set_of_books_id
714: and dist.accounting_date between gl.start_date and gl.end_date
715: and dist1.accounting_date <= gl.end_date )
716: AND trunc(dist.accounting_date,'DD')
717: between fnd_date.canonical_to_date(P_Date_From)
718: AND fnd_date.canonical_to_date(P_Date_To)
719: AND ((dist.line_type_lookup_code = 'AWT')
720: OR
721: (dist.awt_group_id is not NULL))

Line 718: AND fnd_date.canonical_to_date(P_Date_To)

714: and dist.accounting_date between gl.start_date and gl.end_date
715: and dist1.accounting_date <= gl.end_date )
716: AND trunc(dist.accounting_date,'DD')
717: between fnd_date.canonical_to_date(P_Date_From)
718: AND fnd_date.canonical_to_date(P_Date_To)
719: AND ((dist.line_type_lookup_code = 'AWT')
720: OR
721: (dist.awt_group_id is not NULL))
722: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

Line 821: between fnd_date.canonical_to_date(P_Date_From)

817: and dist.parent_reversal_id = dist1.invoice_distribution_id
818: and gl.ledger_id = dist1.set_of_books_id
819: and dist1.accounting_date between gl.start_date and gl.end_date)
820: AND trunc(dist.accounting_date,'DD')
821: between fnd_date.canonical_to_date(P_Date_From)
822: AND fnd_date.canonical_to_date(P_Date_To)
823: AND ((dist.line_type_lookup_code = 'AWT')
824: OR
825: (dist.awt_group_id is not NULL))

Line 822: AND fnd_date.canonical_to_date(P_Date_To)

818: and gl.ledger_id = dist1.set_of_books_id
819: and dist1.accounting_date between gl.start_date and gl.end_date)
820: AND trunc(dist.accounting_date,'DD')
821: between fnd_date.canonical_to_date(P_Date_From)
822: AND fnd_date.canonical_to_date(P_Date_To)
823: AND ((dist.line_type_lookup_code = 'AWT')
824: OR
825: (dist.awt_group_id is not NULL))
826: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

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

933: AND invpay.check_id = checks.check_id
934: AND checks.void_date is null
935: AND trunc(invpay.accounting_date,'DD')
936: between
937: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
938: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
939: AND (dist.line_type_lookup_code = 'AWT')
940: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
941: DIST.ACCRUAL_POSTED_FLAG,

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

934: AND checks.void_date is null
935: AND trunc(invpay.accounting_date,'DD')
936: between
937: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
938: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
939: AND (dist.line_type_lookup_code = 'AWT')
940: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
941: DIST.ACCRUAL_POSTED_FLAG,
942: DIST.CASH_POSTED_FLAG,

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

1100: AND invpay.check_id = checks.check_id
1101: AND checks.void_date is null
1102: AND trunc(invpay.accounting_date,'DD')
1103: between
1104: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1105: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1106: AND (dist.line_type_lookup_code = 'AWT')
1107: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1108: DIST.ACCRUAL_POSTED_FLAG,

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

1101: AND checks.void_date is null
1102: AND trunc(invpay.accounting_date,'DD')
1103: between
1104: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1105: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1106: AND (dist.line_type_lookup_code = 'AWT')
1107: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1108: DIST.ACCRUAL_POSTED_FLAG,
1109: DIST.CASH_POSTED_FLAG,

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

1242: AND invpay.check_id = checks.check_id
1243: AND checks.void_date is null
1244: AND trunc(invpay.accounting_date,'DD')
1245: between
1246: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1247: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1248: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1249: AND (dist.line_type_lookup_code = 'AWT')
1250: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

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

1243: AND checks.void_date is null
1244: AND trunc(invpay.accounting_date,'DD')
1245: between
1246: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1247: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1248: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1249: AND (dist.line_type_lookup_code = 'AWT')
1250: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1251: DIST.ACCRUAL_POSTED_FLAG,

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

1376: AND invpay.check_id = checks.check_id
1377: AND checks.void_date is null
1378: AND trunc(invpay.accounting_date,'DD')
1379: between
1380: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1381: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1382: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1383: AND (dist.line_type_lookup_code = 'AWT')
1384: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(

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

1377: AND checks.void_date is null
1378: AND trunc(invpay.accounting_date,'DD')
1379: between
1380: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1381: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1382: AND dist.awt_invoice_payment_id = invpay.invoice_payment_id
1383: AND (dist.line_type_lookup_code = 'AWT')
1384: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1385: DIST.ACCRUAL_POSTED_FLAG,

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

1486: AND invpay.check_id = checks.check_id
1487: AND checks.void_date is null
1488: AND trunc(invpay.accounting_date,'DD')
1489: between
1490: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1491: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1492: AND (dist.line_type_lookup_code = 'AWT')
1493: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1494: DIST.ACCRUAL_POSTED_FLAG,

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

1487: AND checks.void_date is null
1488: AND trunc(invpay.accounting_date,'DD')
1489: between
1490: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1491: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1492: AND (dist.line_type_lookup_code = 'AWT')
1493: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1494: DIST.ACCRUAL_POSTED_FLAG,
1495: DIST.CASH_POSTED_FLAG,

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

1650: AND invpay.check_id = checks.check_id
1651: AND checks.void_date is null
1652: AND trunc(invpay.accounting_date,'DD')
1653: between
1654: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1655: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1656: AND (dist.line_type_lookup_code = 'AWT')
1657: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1658: DIST.ACCRUAL_POSTED_FLAG,

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

1651: AND checks.void_date is null
1652: AND trunc(invpay.accounting_date,'DD')
1653: between
1654: nvl(fnd_date.canonical_to_date(P_Date_From),invpay.accounting_date)
1655: and nvl(fnd_date.canonical_to_date(P_Date_To),invpay.accounting_date)
1656: AND (dist.line_type_lookup_code = 'AWT')
1657: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1658: DIST.ACCRUAL_POSTED_FLAG,
1659: DIST.CASH_POSTED_FLAG,

Line 1777: between fnd_date.canonical_to_date(P_Date_From)

1773: and gl.ledger_id = dist1.set_of_books_id
1774: and dist.accounting_date between gl.start_date and gl.end_date
1775: and dist1.accounting_date <= gl.end_date )
1776: AND trunc(dist.accounting_date,'DD')
1777: between fnd_date.canonical_to_date(P_Date_From)
1778: and fnd_date.canonical_to_date(P_Date_To)
1779: AND dist.line_type_lookup_code = 'AWT'
1780: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1781: DIST.ACCRUAL_POSTED_FLAG,

Line 1778: and fnd_date.canonical_to_date(P_Date_To)

1774: and dist.accounting_date between gl.start_date and gl.end_date
1775: and dist1.accounting_date <= gl.end_date )
1776: AND trunc(dist.accounting_date,'DD')
1777: between fnd_date.canonical_to_date(P_Date_From)
1778: and fnd_date.canonical_to_date(P_Date_To)
1779: AND dist.line_type_lookup_code = 'AWT'
1780: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1781: DIST.ACCRUAL_POSTED_FLAG,
1782: DIST.CASH_POSTED_FLAG,

Line 1902: between fnd_date.canonical_to_date(P_Date_From)

1898: and dist.parent_reversal_id = dist1.invoice_distribution_id
1899: and gl.ledger_id = dist1.set_of_books_id
1900: and dist1.accounting_date between gl.start_date and gl.end_date)
1901: AND trunc(dist.accounting_date,'DD')
1902: between fnd_date.canonical_to_date(P_Date_From)
1903: and fnd_date.canonical_to_date(P_Date_To)
1904: AND dist.line_type_lookup_code = 'AWT'
1905: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1906: DIST.ACCRUAL_POSTED_FLAG,

Line 1903: and fnd_date.canonical_to_date(P_Date_To)

1899: and gl.ledger_id = dist1.set_of_books_id
1900: and dist1.accounting_date between gl.start_date and gl.end_date)
1901: AND trunc(dist.accounting_date,'DD')
1902: between fnd_date.canonical_to_date(P_Date_From)
1903: and fnd_date.canonical_to_date(P_Date_To)
1904: AND dist.line_type_lookup_code = 'AWT'
1905: AND AP_INVOICE_DISTRIBUTIONS_PKG.GET_POSTED_STATUS(
1906: DIST.ACCRUAL_POSTED_FLAG,
1907: DIST.CASH_POSTED_FLAG,