APPS.AHL_APPROVALS_PVT dependencies on AHL_APPROVAL_RULES_VL

Line 594: FROM Ahl_Approval_Rules_vl

590: CURSOR c_id_exists (x_id IN NUMBER) IS
591: SELECT 1
592: FROM dual
593: WHERE EXISTS (SELECT 1
594: FROM Ahl_Approval_Rules_vl
595: WHERE Approval_Rule_id = x_id);
596: CURSOR c_operating IS
597: SELECT ORGANIZATION_ID
598: FROM HR_OPERATING_UNITS

Line 1516: FROM Ahl_Approval_Rules_VL

1512:
1513: IS
1514: CURSOR c_Approval_Rules IS
1515: SELECT *
1516: FROM Ahl_Approval_Rules_VL
1517: WHERE Approval_Rule_id = p_Approval_Rule_id;
1518: --
1519: -- This is the only exception for using %ROWTYPE.
1520: -- We are selecting from the VL view, which may

Line 1995: FROM Ahl_Approval_Rules_vl

1991: IF l_Approval_Rules_rec.active_end_Date IS NOT NULL THEN
1992:
1993: BEGIN
1994: SELECT 1 INTO l_count
1995: FROM Ahl_Approval_Rules_vl
1996: WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
1997: AND approval_rule_name = l_Approval_Rules_rec.approval_rule_name
1998: AND active_start_date = l_Approval_Rules_rec.active_start_date
1999: AND active_end_date = l_Approval_Rules_rec.active_end_Date

Line 2008: FROM Ahl_Approval_Rules_vl

2004: END;
2005: ELSE -- for end date
2006: BEGIN
2007: SELECT 1 INTO l_count
2008: FROM Ahl_Approval_Rules_vl
2009: WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
2010: AND approval_rule_name = l_Approval_Rules_rec.approval_rule_name
2011: AND active_start_date = l_Approval_Rules_rec.active_start_date
2012: AND status_code = l_Approval_Rules_rec.status_code;

Line 2021: FROM Ahl_Approval_Rules_vl

2017: END IF; -- for end date
2018: ELSE
2019: BEGIN
2020: SELECT 1 INTO l_count
2021: FROM Ahl_Approval_Rules_vl
2022: WHERE Approval_Rule_id = l_Approval_Rules_rec.Approval_Rule_id
2023: AND approval_rule_name = l_Approval_Rules_rec.approval_rule_name
2024: AND status_code = l_Approval_Rules_rec.status_code;
2025: EXCEPTION

Line 2240: 'Ahl_Approval_Rules_vl',

2236: ' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||
2237: ''' AND active_start_date LIKE ''%' || p_Approval_Rules_rec.active_start_date || '%''', 'N' );
2238: ELSIF l_approval_priority_code IS NOT NULL AND l_OPERATING_UNIT_ID IS NULL THEN
2239: l_valid_flag := Check_Rules_Uniqueness (
2240: 'Ahl_Approval_Rules_vl',
2241: 'approval_object_code = ''' || p_Approval_Rules_rec.approval_object_code ||
2242: ''' AND approval_type_code = '''|| p_Approval_Rules_rec.approval_type_code ||
2243: ''' AND approval_priority_code = ''' || p_Approval_Rules_rec.approval_priority_code ||
2244: ''' AND application_usg_code = ''' || p_Approval_Rules_rec.application_usg_code ||