APPS.OZF_CLAIM_TYPE_PVT dependencies on OZF_CLAIM_TYPES_VL

Line 50: FROM ozf_claim_types_VL

46:
47: -- Cursor to validate the uniqueness of the claim_type_id
48: CURSOR c_claim_count(cv_claim_type_id IN NUMBER) IS
49: SELECT 'ANYTHING'
50: FROM ozf_claim_types_VL
51: WHERE claim_type_id = cv_claim_type_id;
52:
53: BEGIN
54:

Line 268: FROM ozf_claim_types_VL

264: l_claim_using_check NUMBER;
265: -- Cursor to validate the existing of the record to be deleted
266: CURSOR c_claim_count(cv_claim_type_id IN NUMBER, cv_obj_ver_num IN NUMBER) IS
267: SELECT COUNT(claim_type_id)
268: FROM ozf_claim_types_VL
269: WHERE claim_type_id = cv_claim_type_id
270: AND object_version_number = cv_obj_ver_num;
271:
272: CURSOR c_claim_using(cv_claim_type_id IN NUMBER) IS

Line 493: FROM ozf_claim_types_VL

489: l_claim_check VARCHAR2(10);
490: -- Cursor to validate the existing of the record to be updated
491: CURSOR c_claim_count(cv_claim_type_id IN NUMBER, cv_obj_ver_num IN NUMBER) IS
492: SELECT COUNT(claim_type_id)
493: FROM ozf_claim_types_VL
494: WHERE claim_type_id = cv_claim_type_id
495: AND object_version_number = cv_obj_ver_num;
496:
497: BEGIN

Line 946: 'ozf_claim_types_VL',

942: IF p_validation_mode = JTF_PLSQL_API.g_create
943: AND p_claim_rec.claim_type_id IS NOT NULL
944: THEN
945: IF OZF_Utility_PVT.check_uniqueness(
946: 'ozf_claim_types_VL',
947: 'claim_type_id = ' || p_claim_rec.claim_type_id
948: ) = FND_API.g_false
949: THEN
950: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 1236: FROM ozf_claim_types_VL

1232: IS
1233:
1234: CURSOR c_claim IS
1235: SELECT *
1236: FROM ozf_claim_types_VL
1237: WHERE claim_type_id = p_claim_rec.claim_type_id;
1238:
1239: l_claim_rec c_claim%ROWTYPE;
1240: