eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_APPROVALS_PVT dependencies on AHL_APPROVAL_RULES_B

Line 8: -- AHL_Approval_Rules_B AND AHL_Approval_Rules_TL:

4: -- PACKAGE
5: -- AHL_Approval_Rules_PVT
6: --
7: -- PROCEDURES
8: -- AHL_Approval_Rules_B AND AHL_Approval_Rules_TL:
9: -- Check_Approval_Rules_Req_Items
10: -- Check_Approval_Rules_UK_Items
11: -- AHL_Approvers:
12: -- Check_Approvers_Req_Items

Line 587: SELECT Ahl_Approval_Rules_B_S.NEXTVAL

583: l_status VARCHAR2(30) := 'DRAFT';
584: l_seed VARCHAR2(1) := 'N';
585:
586: CURSOR c_seq IS
587: SELECT Ahl_Approval_Rules_B_S.NEXTVAL
588: FROM dual;
589:
590: CURSOR c_id_exists (x_id IN NUMBER) IS
591: SELECT 1

Line 857: FROM Ahl_approval_rules_b

853: WHERE NAME = l_Approval_Rules_rec.OPERATING_NAME;
854:
855: CURSOR CUR_STATUS IS
856: SELECT Status_code
857: FROM Ahl_approval_rules_b
858: WHERE Approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
859:
860: CURSOR CUR_SEED IS
861: SELECT Seeded_Flag

Line 862: FROM Ahl_approval_rules_b

858: WHERE Approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
859:
860: CURSOR CUR_SEED IS
861: SELECT Seeded_Flag
862: FROM Ahl_approval_rules_b
863: WHERE Approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
864:
865: CURSOR c_appl_usg IS
866: SELECT LOOKUP_CODE

Line 1166: SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;

1162: SELECT 1 FROM ahl_approvers
1163: WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
1164:
1165: CURSOR chk_STATUS IS
1166: SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
1167: BEGIN
1168: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1169: OPEN chk_STATUS;
1170: FETCH chk_STATUS INTO l_status;

Line 1258: SELECT 1 FROM ahl_approval_rules_b

1254: l_count4 NUMBER;
1255: l_count5 NUMBER;
1256:
1257: CURSOR check_active1 IS
1258: SELECT 1 FROM ahl_approval_rules_b
1259: WHERE UPPER(status_code) = 'ACTIVE'
1260: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1261: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1262: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

Line 1262: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1258: SELECT 1 FROM ahl_approval_rules_b
1259: WHERE UPPER(status_code) = 'ACTIVE'
1260: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1261: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1262: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1263: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1264: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1265: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1266:

Line 1263: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1259: WHERE UPPER(status_code) = 'ACTIVE'
1260: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1261: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1262: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1263: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1264: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1265: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1266:
1267: CURSOR check_active2 IS

Line 1264: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1260: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1261: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1262: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1263: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1264: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1265: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1266:
1267: CURSOR check_active2 IS
1268: SELECT 1 FROM ahl_approval_rules_b

Line 1268: SELECT 1 FROM ahl_approval_rules_b

1264: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1265: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1266:
1267: CURSOR check_active2 IS
1268: SELECT 1 FROM ahl_approval_rules_b
1269: WHERE UPPER(status_code) = 'ACTIVE'
1270: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1271: AND approval_priority_code IS NULL
1272: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

Line 1272: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1268: SELECT 1 FROM ahl_approval_rules_b
1269: WHERE UPPER(status_code) = 'ACTIVE'
1270: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1271: AND approval_priority_code IS NULL
1272: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1273: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1274: AND approval_type_code IS NULL
1275: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1276:

Line 1273: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1269: WHERE UPPER(status_code) = 'ACTIVE'
1270: AND operating_unit_id = (SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME)
1271: AND approval_priority_code IS NULL
1272: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1273: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1274: AND approval_type_code IS NULL
1275: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1276:
1277: CURSOR check_active3 IS

Line 1278: SELECT 1 FROM ahl_approval_rules_b

1274: AND approval_type_code IS NULL
1275: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1276:
1277: CURSOR check_active3 IS
1278: SELECT 1 FROM ahl_approval_rules_b
1279: WHERE UPPER(status_code) = 'ACTIVE'
1280: AND operating_unit_id IS NULL
1281: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1282: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

Line 1282: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1278: SELECT 1 FROM ahl_approval_rules_b
1279: WHERE UPPER(status_code) = 'ACTIVE'
1280: AND operating_unit_id IS NULL
1281: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1282: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1283: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1284: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1285: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1286:

Line 1283: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1279: WHERE UPPER(status_code) = 'ACTIVE'
1280: AND operating_unit_id IS NULL
1281: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1282: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1283: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1284: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1285: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1286:
1287: CURSOR check_active4 IS

Line 1284: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1280: AND operating_unit_id IS NULL
1281: AND approval_priority_code = p_Approval_Rules_rec.approval_priority_code
1282: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1283: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1284: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1285: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1286:
1287: CURSOR check_active4 IS
1288: SELECT 1 FROM ahl_approval_rules_b

Line 1288: SELECT 1 FROM ahl_approval_rules_b

1284: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1285: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1286:
1287: CURSOR check_active4 IS
1288: SELECT 1 FROM ahl_approval_rules_b
1289: WHERE UPPER(status_code) = 'ACTIVE'
1290: AND operating_unit_id IS NULL
1291: AND approval_priority_code IS NULL
1292: AND application_usg_code =(SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

Line 1292: AND application_usg_code =(SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1288: SELECT 1 FROM ahl_approval_rules_b
1289: WHERE UPPER(status_code) = 'ACTIVE'
1290: AND operating_unit_id IS NULL
1291: AND approval_priority_code IS NULL
1292: AND application_usg_code =(SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1293: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1294: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1295: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1296: CURSOR check_active5 IS

Line 1293: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1289: WHERE UPPER(status_code) = 'ACTIVE'
1290: AND operating_unit_id IS NULL
1291: AND approval_priority_code IS NULL
1292: AND application_usg_code =(SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1293: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1294: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1295: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1296: CURSOR check_active5 IS
1297: SELECT 1 FROM ahl_approval_rules_b

Line 1294: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1290: AND operating_unit_id IS NULL
1291: AND approval_priority_code IS NULL
1292: AND application_usg_code =(SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1293: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1294: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1295: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1296: CURSOR check_active5 IS
1297: SELECT 1 FROM ahl_approval_rules_b
1298: WHERE UPPER(status_code) = 'ACTIVE'

Line 1297: SELECT 1 FROM ahl_approval_rules_b

1293: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1294: AND approval_type_code = (SELECT approval_type_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1295: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1296: CURSOR check_active5 IS
1297: SELECT 1 FROM ahl_approval_rules_b
1298: WHERE UPPER(status_code) = 'ACTIVE'
1299: AND operating_unit_id IS NULL
1300: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1301: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

Line 1300: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1296: CURSOR check_active5 IS
1297: SELECT 1 FROM ahl_approval_rules_b
1298: WHERE UPPER(status_code) = 'ACTIVE'
1299: AND operating_unit_id IS NULL
1300: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1301: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1302: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1303: BEGIN
1304: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1301: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)

1297: SELECT 1 FROM ahl_approval_rules_b
1298: WHERE UPPER(status_code) = 'ACTIVE'
1299: AND operating_unit_id IS NULL
1300: AND application_usg_code = (SELECT application_usg_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1301: AND approval_object_code = (SELECT approval_object_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id)
1302: AND approval_rule_id <> p_Approval_Rules_rec.approval_rule_id;
1303: BEGIN
1304: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1305:

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:

Line 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);

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:
1469: CURSOR CUR_STATUS IS
1470: SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
1471:

Line 1470: SELECT status_code FROM ahl_approval_rules_b WHERE 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:
1469: CURSOR CUR_STATUS IS
1470: SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
1471:
1472: BEGIN
1473: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1474: OPEN CUR_STATUS;

Line 1580: DELETE FROM Ahl_Approval_Rules_b

1576: END IF;
1577: RAISE Fnd_Api.g_exc_error;
1578: END IF;
1579:
1580: DELETE FROM Ahl_Approval_Rules_b
1581: WHERE Approval_Rule_id = p_Approval_Rule_id;*/
1582:
1583: UPDATE Ahl_Approval_Rules_B
1584: SET Status_Code = 'OBSOLETE'

Line 1583: UPDATE Ahl_Approval_Rules_B

1579:
1580: DELETE FROM Ahl_Approval_Rules_b
1581: WHERE Approval_Rule_id = p_Approval_Rule_id;*/
1582:
1583: UPDATE Ahl_Approval_Rules_B
1584: SET Status_Code = 'OBSOLETE'
1585: WHERE Approval_Rule_id = p_Approval_Rule_id;
1586: IF (SQL%NOTFOUND) THEN
1587: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error)

Line 2143: SELECT approval_object_code FROM ahl_approval_rules_b

2139: SELECT ORGANIZATION_ID FROM HR_OPERATING_UNITS
2140: WHERE NAME = p_Approval_Rules_rec.OPERATING_NAME;
2141:
2142: CURSOR c_object IS
2143: SELECT approval_object_code FROM ahl_approval_rules_b
2144: WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
2145:
2146: CURSOR c_type IS
2147: SELECT approval_type_code FROM ahl_approval_rules_b

Line 2147: SELECT approval_type_code FROM ahl_approval_rules_b

2143: SELECT approval_object_code FROM ahl_approval_rules_b
2144: WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
2145:
2146: CURSOR c_type IS
2147: SELECT approval_type_code FROM ahl_approval_rules_b
2148: WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
2149:
2150: CURSOR c_appl_usg IS
2151: SELECT application_usg_code

Line 2152: FROM ahl_approval_rules_b

2148: WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
2149:
2150: CURSOR c_appl_usg IS
2151: SELECT application_usg_code
2152: FROM ahl_approval_rules_b
2153: WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
2154:
2155: BEGIN
2156: x_return_status := Fnd_Api.g_ret_sts_success;

Line 2826: SELECT status_code FROM Ahl_Approval_rules_b

2822: WHERE Approval_Rule_Id IN
2823: (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);
2824:
2825: CURSOR check_appr_status IS
2826: SELECT status_code FROM Ahl_Approval_rules_b
2827: WHERE Approval_Rule_Id IN
2828: (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);
2829:
2830: /* End Code for checking approvals by shbhanda Mar'08---*/