APPS.AMW_VIOLATION_PUB dependencies on AMW_CONSTRAINTS_VL

Line 701: FROM amw_constraints_vl

697:
698: -- 05.23.2006 dliao: consider only Prevent Constraint Objective
699: CURSOR c_all_valid_constraints IS
700: SELECT constraint_rev_id, type_code, constraint_name
701: FROM amw_constraints_vl
702: WHERE start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate)
703: and objective_code = 'PR';
704: l_all_valid_constraints c_all_valid_constraints%ROWTYPE;
705:

Line 1894: from AMW_CONSTRAINTS_VL

1890:
1891:
1892: cursor CONSTRAINTS is
1893: select *
1894: from AMW_CONSTRAINTS_VL
1895: where
1896: (TYPE_CODE = 'ALL' or TYPE_CODE = 'ME' or TYPE_CODE = 'SET') and
1897: START_DATE <= sysdate and
1898: (END_DATE is null or END_DATE >= sysdate)

Line 2081: from AMW_CONSTRAINTS_VL

2077:
2078:
2079: cursor CONSTRAINTS is
2080: select *
2081: from AMW_CONSTRAINTS_VL
2082: where
2083: (TYPE_CODE = 'ALL' or TYPE_CODE = 'ME' or TYPE_CODE = 'SET') and
2084: START_DATE <= sysdate and
2085: (END_DATE is null or END_DATE >= sysdate)