APPS.AHL_APPROVALS_PVT dependencies on AHL_STATUS_ORDER_RULES

Line 1451: -- Status match from Ahl_Status_Order_Rules for the Approval Rule

1447:
1448: --------------------------------------------------------------------
1449: -- PROCEDURE
1450: -- Check_Match_for_Status
1451: -- Status match from Ahl_Status_Order_Rules for the Approval Rule
1452: --------------------------------------------------------------------
1453:
1454: PROCEDURE Check_Match_for_Status (
1455: p_Approval_Rules_rec IN Approval_Rules_Rec_Type,

Line 1464: SELECT 1 FROM ahl_approval_rules_b t1, ahl_status_order_rules t2

1460: l_count NUMBER;
1461: l_status VARCHAR2(30);
1462:
1463: CURSOR check_status IS
1464: SELECT 1 FROM ahl_approval_rules_b t1, ahl_status_order_rules t2
1465: WHERE t1.approval_rule_id = p_Approval_Rules_rec.approval_rule_id
1466: AND t2.next_status_code = p_Approval_Rules_rec.status_code
1467: AND t2.current_status_code = (SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id);
1468: