APPS.AD_PA_DELETE_CRITERIASET dependencies on AD_PA_CRITERIA
Line 10: DELETE from AD_PA_CRITERIA_PRODUCTS
6:
7: BEGIN
8:
9: begin 10: DELETE from AD_PA_CRITERIA_PRODUCTS 11: where advisor_criteria_id = p_advisor_criteria_id;
12:
13: DELETE from AD_PA_CRITERIA
14: where advisor_criteria_id = p_advisor_criteria_id;
Line 13: DELETE from AD_PA_CRITERIA
9: begin
10: DELETE from AD_PA_CRITERIA_PRODUCTS
11: where advisor_criteria_id = p_advisor_criteria_id;
12: 13: DELETE from AD_PA_CRITERIA 14: where advisor_criteria_id = p_advisor_criteria_id;
15:
16: exception
17: when no_data_found then