APPS.AMW_VIOLATION_PUB dependencies on AMW_CONSTRAINT_WAIVERS_VL

Line 382: FROM amw_constraint_waivers_vl

378: -- get valid user waiver
379: l_valid_user_waiver_count NUMBER;
380: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER, l_user_id IN NUMBER) IS
381: SELECT count(*)
382: FROM amw_constraint_waivers_vl
383: WHERE constraint_rev_id = l_constraint_rev_id
384: AND object_type = 'USER'
385: AND PK1 = l_user_id
386: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);

Line 842: FROM amw_constraint_waivers_vl

838: -- get valid user waiver
839: l_valid_user_waiver_count NUMBER;
840: CURSOR c_valid_user_waivers (l_constraint_rev_id IN NUMBER, l_user_id IN NUMBER) IS
841: SELECT count(*)
842: FROM amw_constraint_waivers_vl
843: WHERE constraint_rev_id = l_constraint_rev_id
844: AND object_type = 'USER'
845: AND PK1 = l_user_id
846: AND start_date <= sysdate AND (end_date >= sysdate or end_date is null);

Line 1918: FROM amw_constraint_waivers_vl

1914:
1915: l_valid_resp_waiver_count NUMBER;
1916: CURSOR c_valid_resp_waivers (l_constraint_rev_id IN NUMBER, l_resp_id IN NUMBER, l_appl_id IN NUMBER) IS
1917: SELECT count(*)
1918: FROM amw_constraint_waivers_vl
1919: WHERE constraint_rev_id = l_constraint_rev_id
1920: AND object_type = 'RESP'
1921: AND PK1 = l_resp_id
1922: AND PK2 = l_appl_id