APPS.AMW_VIOLATION_PVT dependencies on AMW_CONSTRAINTS_VL

Line 3200: FROM AMW_CONSTRAINTS_VL

3196: LOOP
3197: -- The Constraint _id is associated to the control. So we get the
3198: --Constraint _id corresponding to the violated constraint_rev_id
3199: SELECT constraint_id into l_constraint_id
3200: FROM AMW_CONSTRAINTS_VL
3201: WHERE constraint_rev_id=violated_cst_rev_id_list(i);
3202:
3203: -- A constraint can be associate to many controls. So we get the all
3204: -- the constrols with source as the constraint.

Line 3289: from amw_constraints_vl

3285: emp_id_list G_NUMBER_TABLE;
3286:
3287: cursor c_constraint (l_constraint_rev_id NUMBER) is
3288: select constraint_name
3289: from amw_constraints_vl
3290: where constraint_rev_id = l_constraint_rev_id;
3291:
3292: cursor c_person (c_party_id NUMBER) is
3293: select employee_id

Line 3405: FROM amw_constraints_vl

3401:
3402: -- find all valid constraints
3403: CURSOR c_all_valid_constraints IS
3404: SELECT constraint_rev_id, type_code, constraint_name, objective_code
3405: FROM amw_constraints_vl
3406: WHERE start_date <= sysdate AND (end_date IS NULL OR end_date >= sysdate);
3407: l_all_valid_constraints c_all_valid_constraints%ROWTYPE;
3408:
3409: -- find the number of constraint entries(incompatible functions) by specified constraint_rev_id

Line 3806: from AMW_CONSTRAINTS_VL

3802: where MENU_ID = p_menu_id;
3803:
3804: cursor CONSTRAINTS is
3805: select *
3806: from AMW_CONSTRAINTS_VL
3807: where
3808: (TYPE_CODE = 'ALL' or TYPE_CODE = 'ME' or TYPE_CODE = 'SET') and
3809: START_DATE <= sysdate and
3810: (END_DATE is null or END_DATE >= sysdate);

Line 3985: from AMW_CONSTRAINTS_VL

3981: );
3982:
3983: cursor CONSTRAINTS is
3984: select *
3985: from AMW_CONSTRAINTS_VL
3986: where
3987: (TYPE_CODE = 'ALL' or TYPE_CODE = 'ME' or TYPE_CODE = 'SET') and
3988: START_DATE <= sysdate and
3989: (END_DATE is null or END_DATE >= sysdate);