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.PAAPIMP_PKG dependencies on PER_ASSIGNMENTS_F

Line 1925: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where

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
1929: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 1975: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
1979: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2002: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where

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
2006: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2056: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2060: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2109: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2113: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))))

Line 2160: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2164: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2205: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2209: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2260: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2264: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2286: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where

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
2290: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2335: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2339: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2361: PER_ASSIGNMENTS_F ASGN ,PER_PERSON_TYPES PTYPE where

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
2365: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2412: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2416: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2463: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2467: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2515: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2519: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))

Line 2557: PER_ASSIGNMENTS_f ASGN ,PER_PERSON_TYPES PTYPE where

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
2561: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))