APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 1545: FROM ahl_unit_deferrals_b

1541:
1542: -- validate deferral ID
1543: CURSOR l_unit_deferral_csr (p_unit_deferral_id IN NUMBER) IS
1544: SELECT 'x'
1545: FROM ahl_unit_deferrals_b
1546: WHERE unit_deferral_id = p_unit_deferral_id
1547: AND unit_deferral_type = 'INIT-DUE';
1548:
1549: -- For bug# 4172783.

Line 2073: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

2069: WHERE UNIT_THRESHOLD_ID = p_threshold_id;
2070:
2071: CURSOR l_ue_id_check_csr(p_threshold_id IN NUMBER, p_ue_id IN NUMBER) IS
2072: SELECT 'x'
2073: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
2074: WHERE UTH.unit_deferral_id = UDF.unit_deferral_ID AND
2075: UTH.UNIT_THRESHOLD_ID = p_threshold_id AND
2076: UDF.UNIT_EFFECTIVITY_ID = p_ue_id AND
2077: UDF.Unit_deferral_type = 'INIT-DUE';

Line 2508: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

2504: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS
2505:
2506: CURSOR l_threshold_exists_csr(p_ue_id IN NUMBER) IS
2507: SELECT 'x'
2508: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF
2509: WHERE UTH.unit_deferral_id = UDF.unit_deferral_id
2510: AND UDF.unit_deferral_type = 'INIT-DUE'
2511: AND UDF.unit_effectivity_id = p_ue_id;
2512:

Line 3258: FROM AHL_UNIT_DEFERRALS_B UDF

3254: UTH.COUNTER_ID = p_counter_id;
3255:
3256: CURSOR l_get_def_csr(p_ue_id IN NUMBER) IS
3257: SELECT unit_deferral_id
3258: FROM AHL_UNIT_DEFERRALS_B UDF
3259: WHERE UDF.UNIT_EFFECTIVITY_ID = p_ue_id AND
3260: UDF.UNIT_DEFERRAL_TYPE = 'INIT-DUE';
3261:
3262: l_threshold_details l_get_unit_threshold_csr%ROWTYPE;

Line 4403: SELECT unit_deferral_id from ahl_unit_deferrals_b

4399: l_copy_record BOOLEAN;
4400: l_copy_ud_record BOOLEAN;
4401:
4402: CURSOR unit_deferral_id_csr(p_unit_effectivity_id IN NUMBER) IS
4403: SELECT unit_deferral_id from ahl_unit_deferrals_b
4404: where UNIT_EFFECTIVITY_ID = p_unit_effectivity_id
4405: AND UNIT_DEFERRAL_TYPE = 'INIT-DUE';
4406:
4407: l_unit_deferral_id NUMBER;

Line 5054: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,

5050: X_LAST_UPDATE_DATE => sysdate,
5051: X_LAST_UPDATED_BY => fnd_global.user_id,
5052: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
5053: IF(l_copy_ud_record)THEN
5054: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
5055: last_update_date = sysdate,
5056: object_version_number = object_version_number + 1,
5057: LAST_UPDATED_BY = fnd_global.user_id,
5058: LAST_UPDATE_LOGIN = fnd_global.login_id