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.

[Home] [Help]

APPS.PAAPIMP_PKG dependencies on PER_PEOPLE

Line 1897: select 1 from PER_PEOPLE PPL,

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 (
1897: select 1 from PER_PEOPLE PPL,
1898: PER_ASSIGNMENTS ASGN ,PER_PERSON_TYPES PTYPE where
1899: ASGN.VENDOR_ID = vend.VENDOR_ID
1900: and PPL.PERSON_ID = ASGN.PERSON_ID
1901: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 1924: select 1 from PER_PEOPLE_F PPL,

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 (
1924: select 1 from PER_PEOPLE_F PPL,
1925: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where
1926: ASGN.VENDOR_ID = vend1.VENDOR_ID
1927: and PPL.PERSON_ID = ASGN.PERSON_ID
1928: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 1974: select 1 from PER_PEOPLE_F PPL,

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 (
1974: select 1 from PER_PEOPLE_F PPL,
1975: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
1976: ASGN.VENDOR_ID = vend.VENDOR_ID
1977: and PPL.PERSON_ID = ASGN.PERSON_ID
1978: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2001: select 1 from PER_PEOPLE_F PPL,

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 (
2001: select 1 from PER_PEOPLE_F PPL,
2002: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where
2003: ASGN.VENDOR_ID = vend1.VENDOR_ID
2004: and PPL.PERSON_ID = ASGN.PERSON_ID
2005: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2055: select 1 from PER_PEOPLE_F PPL,

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 (
2055: select 1 from PER_PEOPLE_F PPL,
2056: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2057: ASGN.VENDOR_ID = vend.VENDOR_ID
2058: and PPL.PERSON_ID = ASGN.PERSON_ID
2059: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2108: select 1 from PER_PEOPLE_F PPL,

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 (
2108: select 1 from PER_PEOPLE_F PPL,
2109: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2110: ASGN.VENDOR_ID = vend.VENDOR_ID
2111: and PPL.PERSON_ID = ASGN.PERSON_ID
2112: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2159: select 1 from PER_PEOPLE_F PPL,

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 (
2159: select 1 from PER_PEOPLE_F PPL,
2160: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2161: ASGN.VENDOR_ID = vend.VENDOR_ID
2162: and PPL.PERSON_ID = ASGN.PERSON_ID
2163: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2204: select 1 from PER_PEOPLE_F PPL,

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 (
2204: select 1 from PER_PEOPLE_F PPL,
2205: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2206: ASGN.VENDOR_ID = vend.VENDOR_ID
2207: and PPL.PERSON_ID = ASGN.PERSON_ID
2208: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2259: select 1 from PER_PEOPLE_F PPL,

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 (
2259: select 1 from PER_PEOPLE_F PPL,
2260: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2261: ASGN.VENDOR_ID = vend.VENDOR_ID
2262: and PPL.PERSON_ID = ASGN.PERSON_ID
2263: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2285: select 1 from PER_PEOPLE_F PPL,

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 (
2285: select 1 from PER_PEOPLE_F PPL,
2286: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where
2287: ASGN.VENDOR_ID = vend1.VENDOR_ID
2288: and PPL.PERSON_ID = ASGN.PERSON_ID
2289: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2334: select 1 from PER_PEOPLE_F PPL,

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 (
2334: select 1 from PER_PEOPLE_F PPL,
2335: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2336: ASGN.VENDOR_ID = vend.VENDOR_ID
2337: and PPL.PERSON_ID = ASGN.PERSON_ID
2338: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2360: select 1 from PER_PEOPLE_F PPL,

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 (
2360: select 1 from PER_PEOPLE_F PPL,
2361: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where
2362: ASGN.VENDOR_ID = vend1.VENDOR_ID
2363: and PPL.PERSON_ID = ASGN.PERSON_ID
2364: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2411: select 1 from PER_PEOPLE_F PPL,

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 (
2411: select 1 from PER_PEOPLE_F PPL,
2412: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2413: ASGN.VENDOR_ID = vend.VENDOR_ID
2414: and PPL.PERSON_ID = ASGN.PERSON_ID
2415: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2462: select 1 from PER_PEOPLE_F PPL,

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,
2463: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2464: ASGN.VENDOR_ID = vend.VENDOR_ID
2465: and PPL.PERSON_ID = ASGN.PERSON_ID
2466: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2514: select 1 from PER_PEOPLE_F PPL,

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 (
2514: select 1 from PER_PEOPLE_F PPL,
2515: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2516: ASGN.VENDOR_ID = vend.VENDOR_ID
2517: and PPL.PERSON_ID = ASGN.PERSON_ID
2518: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID

Line 2556: select 1 from PER_PEOPLE_F PPL,

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 (
2556: select 1 from PER_PEOPLE_F PPL,
2557: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where
2558: ASGN.VENDOR_ID = vend.VENDOR_ID
2559: and PPL.PERSON_ID = ASGN.PERSON_ID
2560: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID