APPS.PAAPIMP_PKG dependencies on STANDARD

Line 1583: -- : R12.PJ:XB6:QA:APL: STANDARD INVOICES / PREPAYMENTS NOT SHOWN AS COMMITTMENT

1579: WHERE invoice_distribution_id = p_prepay_dist_id;
1580:
1581: -- ==================================================================================
1582: -- Bug: 5393523
1583: -- : R12.PJ:XB6:QA:APL: STANDARD INVOICES / PREPAYMENTS NOT SHOWN AS COMMITTMENT
1584: -- Unpaid prepayments invoice has NULL prepay_amount_remaining and it should not
1585: -- mislead as fully applied prepayment.
1586: -- ==================================================================================
1587: IF l_prepay_rem_amt is NULL THEN

Line 1673: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')

1669: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1670: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1671: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1672: OR
1673: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
1674: AND inv.source in ('CREDIT CARD','Both Pay')
1675: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1676: OR
1677: (EXISTS ( SELECT NULL

Line 1691: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')

1687: AND ((inv1.invoice_type_lookup_code = G_INVOICE_TYPE
1688: AND inv1.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1689: AND (vend1.employee_id IS NOT NULL or nvl(inv1.paid_on_behalf_employee_id,0) > 0))
1690: OR
1691: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
1692: AND inv1.source in ('CREDIT CARD','Both Pay')
1693: AND nvl(inv1.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1694: )
1695: AND DIST.project_id = G_PROJECT_ID

Line 1735: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

1731: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1732: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1733: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1734: OR
1735: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
1736: AND inv.source in ('CREDIT CARD','Both Pay')
1737: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)))
1738: AND exists(SELECT inv.invoice_id
1739: FROM AP_INVOICES inv,

Line 1778: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

1774: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1775: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1776: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1777: OR
1778: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
1779: AND inv.source in ('CREDIT CARD','Both Pay')
1780: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)))
1781: AND DIST.project_id = G_PROJECT_ID
1782: AND trunc(DIST.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,DIST.expenditure_item_date)) /*GSCC*//* added trunc for the bug 6623163 */

Line 1823: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

1819: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1820: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1821: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1822: OR
1823: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
1824: AND inv.source in ('CREDIT CARD','Both Pay')
1825: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1826: OR
1827: (EXISTS ( SELECT NULL

Line 1840: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

1836: AND ((inv1.invoice_type_lookup_code = G_INVOICE_TYPE
1837: AND inv1.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1838: AND (vend1.employee_id IS NOT NULL or nvl(inv1.paid_on_behalf_employee_id,0) > 0))
1839: OR
1840: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
1841: AND inv1.source in ('CREDIT CARD','Both Pay')
1842: AND nvl(inv1.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0))))
1843: )
1844: AND trunc(DIST.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,DIST.expenditure_item_date)) /*GSCC*/

Line 1881: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

1877: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1878: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1879: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1880: OR
1881: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
1882: AND inv.source in ('CREDIT CARD','Both Pay')
1883: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)))
1884: AND exists(SELECT inv.invoice_id
1885: FROM AP_INVOICES_ALL inv,

Line 1924: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*//*Bug 4099522*/

1920: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1921: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1922: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1923: OR
1924: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*//*Bug 4099522*/
1925: AND inv.source in ('CREDIT CARD','Both Pay')
1926: AND nvl(inv.paid_on_behalf_employee_id,0) > 0)))
1927: AND trunc(DIST.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,DIST.expenditure_item_date)) /*GSCC*//* added trunc for the bug 6623163 */
1928: AND trunc(DIST.accounting_date) <= trunc(nvl(G_GL_DATE,DIST.accounting_date)); /*GSCC*/

Line 8932: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

8928: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2,
8929: G_INVOICE_SOURCE3)
8930: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
8931: OR
8932: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
8933: AND inv.source in ('CREDIT CARD','Both Pay')
8934: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
8935:
8936: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;

Line 8977: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

8973: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
8974: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
8975: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
8976: OR
8977: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
8978: AND inv.source in ('CREDIT CARD','Both Pay')
8979: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
8980:
8981: G_PAY_DISTRIBUTIONS_MARKED := nvl(G_PAY_DISTRIBUTIONS_MARKED,0) + SQL%ROWCOUNT;

Line 9023: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

9019: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2,
9020: G_INVOICE_SOURCE3)
9021: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
9022: OR
9023: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
9024: AND inv.source in ('CREDIT CARD','Both Pay')
9025: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
9026:
9027: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;

Line 9068: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/

9064: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
9065: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
9066: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
9067: OR
9068: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
9069: AND inv.source in ('CREDIT CARD','Both Pay')
9070: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
9071:
9072: G_PAY_DISTRIBUTIONS_MARKED := nvl(G_PAY_DISTRIBUTIONS_MARKED,0) + SQL%ROWCOUNT;