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.OE_PC_CONSTRAINTS_ADMIN_PVT dependencies on OE_PC_EXCLUSIONS

Line 1538: FROM OE_PC_EXCLUSIONS e

1534: AND ( a.application_id = p_application_id
1535: OR a.application_id IS NULL )
1536: AND NOT EXISTS (
1537: SELECT 'EXISTS'
1538: FROM OE_PC_EXCLUSIONS e
1539: WHERE e.responsibility_id = p_responsibility_id
1540: AND e.assignment_id = a.assignment_id
1541: AND e.application_id = p_application_id
1542: )

Line 2077: FROM OE_PC_EXCLUSIONS e

2073: AND ( a.application_id = p_application_id
2074: OR a.application_id IS NULL)
2075: AND NOT EXISTS (
2076: SELECT 'EXISTS'
2077: FROM OE_PC_EXCLUSIONS e
2078: WHERE e.responsibility_id = p_responsibility_id
2079: AND e.assignment_id = a.assignment_id
2080: AND e.application_id = p_application_id
2081: )

Line 2125: FROM OE_PC_EXCLUSIONS e

2121: AND ( a.application_id =p_application_id --added for bug3631547
2122: OR a.application_id IS NULL )
2123: AND NOT EXISTS (
2124: SELECT 'EXISTS'
2125: FROM OE_PC_EXCLUSIONS e
2126: WHERE e.responsibility_id = p_responsibility_id
2127: AND e.assignment_id = a.assignment_id
2128: AND e.application_id = p_application_id
2129: )

Line 2151: FROM OE_PC_EXCLUSIONS e

2147: AND c.constrained_operation = p_operation
2148: AND (a.application_id = p_application_id OR a.application_id IS NULL) --added for bug3631547
2149: AND NOT EXISTS (
2150: SELECT 'EXISTS'
2151: FROM OE_PC_EXCLUSIONS e
2152: WHERE e.responsibility_id = p_responsibility_id
2153: AND e.assignment_id = a.assignment_id
2154: AND e.application_id = p_application_id
2155: )