APPS.PAAPIMP_PKG dependencies on STANDARD

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

1798: WHERE invoice_distribution_id = p_prepay_dist_id;
1799: end if;
1800: -- ==================================================================================
1801: -- Bug: 5393523
1802: -- : R12.PJ:XB6:QA:APL: STANDARD INVOICES / PREPAYMENTS NOT SHOWN AS COMMITTMENT
1803: -- Unpaid prepayments invoice has NULL prepay_amount_remaining and it should not
1804: -- mislead as fully applied prepayment.
1805: -- ==================================================================================
1806: IF l_prepay_rem_amt is NULL THEN

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

1888: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1889: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1890: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1891: OR
1892: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
1893: AND inv.source in ('CREDIT CARD','Both Pay')
1894: /* AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0 commented for bug#8977795 */)
1895: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT'
1896: and exists (

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

1915: AND ((inv1.invoice_type_lookup_code = G_INVOICE_TYPE
1916: AND inv1.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1917: AND (vend1.employee_id IS NOT NULL or nvl(inv1.paid_on_behalf_employee_id,0) > 0))
1918: OR
1919: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
1920: AND inv1.source in ('CREDIT CARD','Both Pay')
1921: /* AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0 commented for bug#8977795 */)
1922: OR (INV1.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
1923: and exists (

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

1965: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
1966: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1967: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
1968: OR
1969: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
1970: AND inv.source in ('CREDIT CARD','Both Pay')
1971: )
1972: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
1973: and exists (

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

1992: AND ((inv1.invoice_type_lookup_code = G_INVOICE_TYPE
1993: AND inv1.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
1994: AND (vend1.employee_id IS NOT NULL or nvl(inv1.paid_on_behalf_employee_id,0) > 0))
1995: OR
1996: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
1997: and INV1.source in ('CREDIT CARD','Both Pay')
1998: )
1999: OR (INV1.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2000: and exists (

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

2046: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2047: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2048: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2049: OR
2050: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
2051: AND inv.source in ('CREDIT CARD','Both Pay')
2052: /* AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0 commented for bug#8977795 */ )
2053: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2054: and exists (

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

2099: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2100: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2101: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2102: OR
2103: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
2104: AND inv.source in ('CREDIT CARD','Both Pay')
2105: )
2106: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2107: and exists (

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

2150: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2151: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2152: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2153: OR
2154: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
2155: AND inv.source in ('CREDIT CARD','Both Pay')
2156: /* AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0 commented for bug#8977795 */)
2157: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2158: and exists (

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

2195: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2196: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2197: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2198: OR
2199: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
2200: AND inv.source in ('CREDIT CARD','Both Pay')
2201: )
2202: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2203: and exists (

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

2250: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2251: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2252: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2253: OR
2254: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
2255: AND inv.source in ('CREDIT CARD','Both Pay')
2256: /* AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0 commented for bug#8977795 */)
2257: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2258: and exists (

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

2276: AND ((inv1.invoice_type_lookup_code = G_INVOICE_TYPE
2277: AND inv1.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2278: AND (vend1.employee_id IS NOT NULL or nvl(inv1.paid_on_behalf_employee_id,0) > 0))
2279: OR
2280: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
2281: AND inv1.source in ('CREDIT CARD','Both Pay')
2282: /* AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0 commented for bug#8977795 */)
2283: OR (INV1.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2284: and exists (

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

2325: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2326: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2327: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2328: OR
2329: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
2330: AND inv.source in ('CREDIT CARD','Both Pay')
2331: )
2332: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2333: and exists (

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

2351: AND ((inv1.invoice_type_lookup_code = G_INVOICE_TYPE
2352: AND inv1.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2353: AND (vend1.employee_id IS NOT NULL or nvl(inv1.paid_on_behalf_employee_id,0) > 0))
2354: OR
2355: (inv1.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
2356: AND inv1.source in ('CREDIT CARD','Both Pay')
2357: )
2358: OR (INV1.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2359: and exists (

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

2402: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2403: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2404: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2405: OR
2406: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
2407: AND inv.source in ('CREDIT CARD','Both Pay')
2408: /* AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0 commented for bug#8977795 */)
2409: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2410: and exists (

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

2454: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2455: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2456: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2457: OR
2458: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
2459: AND inv.source in ('CREDIT CARD','Both Pay'))
2460: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2461: and exists (
2462: select 1 from PER_PEOPLE_F PPL,

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

2505: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2506: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2507: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2508: OR
2509: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*//*Bug 4099522*/
2510: AND inv.source in ('CREDIT CARD','Both Pay')
2511: /* AND nvl(inv.paid_on_behalf_employee_id,0) > 0 commented for bug#8977795 */ )
2512: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2513: and exists (

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

2547: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
2548: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
2549: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
2550: OR
2551: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED')
2552: AND inv.source in ('CREDIT CARD','Both Pay')
2553: )
2554: OR (INV.INVOICE_TYPE_LOOKUP_CODE = 'EXPENSE REPORT' /*code changes for bug 14769043*/
2555: and exists (

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

10646: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2,
10647: G_INVOICE_SOURCE3)
10648: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
10649: OR
10650: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
10651: AND inv.source in ('CREDIT CARD','Both Pay')
10652: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
10653:
10654: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;

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

10691: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
10692: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
10693: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
10694: OR
10695: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
10696: AND inv.source in ('CREDIT CARD','Both Pay')
10697: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
10698:
10699: G_PAY_DISTRIBUTIONS_MARKED := nvl(G_PAY_DISTRIBUTIONS_MARKED,0) + SQL%ROWCOUNT;

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

10737: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2,
10738: G_INVOICE_SOURCE3)
10739: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
10740: OR
10741: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
10742: AND inv.source in ('CREDIT CARD','Both Pay')
10743: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
10744:
10745: G_PAY_DISTRIBUTIONS_MARKED := SQL%ROWCOUNT;

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

10782: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE
10783: AND inv.source IN (G_INVOICE_SOURCE1, G_INVOICE_SOURCE2, G_INVOICE_SOURCE3)
10784: AND (vend.employee_id IS NOT NULL or nvl(inv.paid_on_behalf_employee_id,0) > 0))
10785: OR
10786: (inv.invoice_type_lookup_code in ('STANDARD','CREDIT','MIXED') /*Bug# 3373933*/ /*Bug 4099522*/
10787: AND inv.source in ('CREDIT CARD','Both Pay')
10788: AND nvl(inv.PAID_ON_BEHALF_EMPLOYEE_ID,0) > 0)));
10789:
10790: G_PAY_DISTRIBUTIONS_MARKED := nvl(G_PAY_DISTRIBUTIONS_MARKED,0) + SQL%ROWCOUNT;