APPS.ASO_APR_WF_PVT dependencies on ASO_APR_RULES

Line 2728: FROM aso_apr_rules

2724: CURSOR get_existing_rules (
2725: c_object_approval_id NUMBER
2726: ) IS
2727: SELECT oam_rule_id
2728: FROM aso_apr_rules
2729: WHERE object_approval_id = c_object_approval_id
2730: ORDER BY rule_id;
2731:
2732: CURSOR get_rule_count (

Line 2738: FROM aso_apr_rules

2734: ) IS
2735: SELECT COUNT (
2736: *
2737: )
2738: FROM aso_apr_rules
2739: WHERE object_approval_id = c_object_approval_id;
2740:
2741: cursor get_employee_id(l_user_id NUMBER) IS
2742: select employee_id

Line 3296: DELETE FROM aso_apr_rules

3292:
3293: IF l_rules_changed_flag = 'Y'
3294: THEN
3295: -- delete the existing rules
3296: DELETE FROM aso_apr_rules
3297: WHERE object_approval_id = p_object_approval_id;
3298:
3299: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
3300: aso_debug_pub.ADD (

Line 4800: FROM aso_apr_rules

4796: CURSOR get_rule_details (
4797: c_approval_id NUMBER
4798: ) IS
4799: SELECT oam_rule_id
4800: FROM aso_apr_rules
4801: WHERE object_approval_id = c_approval_id;
4802: BEGIN
4803: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4804: aso_debug_pub.ADD (