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.AMW_CONSTRAINT_PVT dependencies on AMW_CONSTRAINT_WAIVERS_B

Line 1544: ||' from amw_constraint_waivers_b '

1540: ||' and asgn.start_date = start_date '
1541: ||' and rownum=1 '
1542: ||' ) created_by, '
1543: ||' DECODE((select count(*) '
1544: ||' from amw_constraint_waivers_b '
1545: ||' where constraint_rev_id= :1 '
1546: ||' and object_type=''RESP'' '
1547: ||' and pk1 = ur.role_orig_system_id '
1548: ||' and pk2 = appl.application_id '

Line 1598: ||' from amw_constraint_waivers_b '

1594: ||' and asgn.start_date = start_date '
1595: ||' and rownum=1 '
1596: ||' ) created_by, '
1597: ||' DECODE((select count(*) '
1598: ||' from amw_constraint_waivers_b '
1599: ||' where constraint_rev_id= :3 '
1600: ||' and object_type=''RESP'' '
1601: ||' and pk1 = ur.role_orig_system_id '
1602: ||' and pk2 = appl.application_id '

Line 2336: ||' from amw_constraint_waivers_b '

2332: ||' and asgn.start_date = start_date '
2333: ||' and rownum=1 '
2334: ||' ) created_by, '
2335: ||' DECODE((select count(*) '
2336: ||' from amw_constraint_waivers_b '
2337: ||' where constraint_rev_id= :1 '
2338: ||' and object_type=''RESP'' '
2339: ||' and pk1 = ur.role_orig_system_id '
2340: ||' and pk2 = appl.application_id '

Line 2393: ||' from amw_constraint_waivers_b '

2389: ||' and asgn.start_date = start_date '
2390: ||' and rownum=1 '
2391: ||' ) created_by, '
2392: ||' DECODE((select count(*) '
2393: ||' from amw_constraint_waivers_b '
2394: ||' where constraint_rev_id= :4 '
2395: ||' and object_type=''RESP'' '
2396: ||' and pk1 = ur.role_orig_system_id '
2397: ||' and pk2 = appl.application_id '

Line 4508: FROM amw_constraint_waivers_b

4504: -- bug : 6722113 : Added below cursor to get waived of responsibilities in
4505: -- this constraint
4506: CURSOR c_resp_waived (l_constraint_rev_id IN NUMBER) IS
4507: SELECT PK1,PK2
4508: FROM amw_constraint_waivers_b
4509: WHERE constraint_rev_id = l_constraint_rev_id
4510: AND object_type = 'RESP'
4511: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
4512:

Line 4858: FROM amw_constraint_waivers_b

4854: FROM dual;
4855:
4856: CURSOR c_resp_waived (l_constraint_rev_id IN NUMBER) IS
4857: SELECT PK1,PK2
4858: FROM amw_constraint_waivers_b
4859: WHERE constraint_rev_id = l_constraint_rev_id
4860: AND object_type = 'RESP'
4861: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
4862:

Line 5317: FROM amw_constraint_waivers_b

5313: FROM dual;
5314:
5315: CURSOR c_resp_waived (l_constraint_rev_id IN NUMBER) IS
5316: SELECT PK1,PK2
5317: FROM amw_constraint_waivers_b
5318: WHERE constraint_rev_id = l_constraint_rev_id
5319: AND object_type = 'RESP'
5320: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5321:

Line 5660: FROM amw_constraint_waivers_b

5656: WHERE constraint_rev_id=l_constraint_rev_id;
5657:
5658: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
5659: SELECT PK1
5660: FROM amw_constraint_waivers_b
5661: WHERE constraint_rev_id = l_constraint_rev_id
5662: AND object_type = 'USER'
5663: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5664:

Line 5828: FROM amw_constraint_waivers_b

5824: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
5825:
5826: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
5827: SELECT PK1
5828: FROM amw_constraint_waivers_b
5829: WHERE constraint_rev_id = l_constraint_rev_id
5830: AND object_type = 'USER'
5831: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5832:

Line 5992: FROM amw_constraint_waivers_b

5988: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
5989:
5990: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
5991: SELECT PK1
5992: FROM amw_constraint_waivers_b
5993: WHERE constraint_rev_id = l_constraint_rev_id
5994: AND object_type = 'USER'
5995: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
5996:

Line 6170: FROM amw_constraint_waivers_b

6166: WHERE constraint_rev_id=l_constraint_rev_id;
6167:
6168: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
6169: SELECT PK1
6170: FROM amw_constraint_waivers_b
6171: WHERE constraint_rev_id = l_constraint_rev_id
6172: AND object_type = 'USER'
6173: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
6174:

Line 6300: FROM amw_constraint_waivers_b

6296: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
6297:
6298: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
6299: SELECT PK1
6300: FROM amw_constraint_waivers_b
6301: WHERE constraint_rev_id = l_constraint_rev_id
6302: AND object_type = 'USER'
6303: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
6304:

Line 6436: FROM amw_constraint_waivers_b

6432: listkey VARCHAR2(30) := NULL;
6433:
6434: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER) IS
6435: SELECT PK1
6436: FROM amw_constraint_waivers_b
6437: WHERE constraint_rev_id = l_constraint_rev_id
6438: AND object_type = 'USER'
6439: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);
6440: