APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 1354: FROM ahl_unit_deferrals_b

1350:
1351: -- validate deferral ID
1352: CURSOR l_unit_deferral_csr (p_unit_deferral_id IN NUMBER) IS
1353: SELECT 'x'
1354: FROM ahl_unit_deferrals_b
1355: WHERE unit_deferral_id = p_unit_deferral_id
1356: AND unit_deferral_type = 'INIT-DUE';
1357:
1358: -- For bug# 4172783.

Line 1814: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

1810: WHERE UNIT_THRESHOLD_ID = p_threshold_id;
1811:
1812: CURSOR l_ue_id_check_csr(p_threshold_id IN NUMBER, p_ue_id IN NUMBER) IS
1813: SELECT 'x'
1814: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
1815: WHERE UTH.unit_deferral_id = UDF.unit_deferral_ID AND
1816: UTH.UNIT_THRESHOLD_ID = p_threshold_id AND
1817: UDF.UNIT_EFFECTIVITY_ID = p_ue_id AND
1818: UDF.Unit_deferral_type = 'INIT-DUE';

Line 2199: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

2195: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS
2196:
2197: CURSOR l_threshold_exists_csr(p_ue_id IN NUMBER) IS
2198: SELECT 'x'
2199: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
2200: WHERE UTH.unit_deferral_id = UDF.unit_deferral_id
2201: AND UDF.unit_deferral_type = 'INIT-DUE'
2202: AND UDF.unit_effectivity_id = p_ue_id;
2203:

Line 2946: FROM AHL_UNIT_DEFERRALS_B UDF

2942: UTH.COUNTER_ID = p_counter_id;
2943:
2944: CURSOR l_get_def_csr(p_ue_id IN NUMBER) IS
2945: SELECT unit_deferral_id
2946: FROM AHL_UNIT_DEFERRALS_B UDF
2947: WHERE UDF.UNIT_EFFECTIVITY_ID = p_ue_id AND
2948: UDF.UNIT_DEFERRAL_TYPE = 'INIT-DUE';
2949:
2950: l_threshold_details l_get_unit_threshold_csr%ROWTYPE;

Line 4080: SELECT unit_deferral_id from ahl_unit_deferrals_b

4076: l_copy_record BOOLEAN;
4077: l_copy_ud_record BOOLEAN;
4078:
4079: CURSOR unit_deferral_id_csr(p_unit_effectivity_id IN NUMBER) IS
4080: SELECT unit_deferral_id from ahl_unit_deferrals_b
4081: where UNIT_EFFECTIVITY_ID = p_unit_effectivity_id
4082: AND UNIT_DEFERRAL_TYPE = 'INIT-DUE';
4083:
4084: l_unit_deferral_id NUMBER;

Line 4720: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,

4716: X_LAST_UPDATE_DATE => sysdate,
4717: X_LAST_UPDATED_BY => fnd_global.user_id,
4718: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
4719: IF(l_copy_ud_record)THEN
4720: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
4721: last_update_date = sysdate,
4722: object_version_number = object_version_number + 1,
4723: LAST_UPDATED_BY = fnd_global.user_id,
4724: LAST_UPDATE_LOGIN = fnd_global.login_id