APPS.AHL_GENERIC_APRV_PVT dependencies on AHL_APPROVAL_RULES_B

Line 1473: FROM ahl_approval_rules_b

1469: -- Approval type (BUDGET .. ) is mandatory
1470:
1471: CURSOR c_approval_rule_id IS
1472: SELECT approval_rule_id, seeded_flag
1473: FROM ahl_approval_rules_b
1474: WHERE nvl(operating_unit_id,l_operating_unit_id) = l_operating_unit_id
1475: AND approval_object_code = p_object
1476: AND nvl(approval_type_code, l_approval_type_code) = l_approval_type_code
1477: AND nvl(approval_priority_code,l_priority) = l_priority

Line 1488: FROM ahl_approval_rules_b

1484:
1485: -- If the there are no matching records it takes the default Rule
1486: CURSOR c_default_rule IS
1487: SELECT approval_rule_id, seeded_flag
1488: FROM ahl_approval_rules_b
1489: WHERE seeded_flag = 'Y'
1490: AND nvl(application_usg_code, l_application_usg_code) = l_application_usg_code;
1491:
1492: -- Takes Min Approver Sequence From Ahl_approvers Once matching records are

Line 1493: -- Found form ahl_approval_rules_b

1489: WHERE seeded_flag = 'Y'
1490: AND nvl(application_usg_code, l_application_usg_code) = l_application_usg_code;
1491:
1492: -- Takes Min Approver Sequence From Ahl_approvers Once matching records are
1493: -- Found form ahl_approval_rules_b
1494: CURSOR c_approver_seq IS
1495: SELECT min(approver_sequence)
1496: FROM ahl_approvers
1497: WHERE approval_rule_id = x_approval_rule_id;