APPS.AHL_REPORT_UTILS_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 36: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

32:
33: CURSOR c_get_ue_id(c_instance_id NUMBER,
34: c_mr_pgm_sub_type VARCHAR2) IS
35: SELECT ue.unit_effectivity_id
36: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
37: WHERE ue.object_type = 'MR'
38: AND ue.MANUALLY_PLANNED_FLAG = 'N'
39: AND ue.csi_item_instance_id = C_INSTANCE_ID
40: AND ue.due_date >= sysdate

Line 93: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

89: l_get_ue_id NUMBER;
90:
91: CURSOR c_get_ue_id(c_instance_id NUMBER) IS
92: SELECT ue.unit_effectivity_id
93: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
94: WHERE ue.object_type = 'MR'
95: AND ue.manually_planned_flag = 'N'
96: AND ue.csi_item_instance_id = c_instance_id
97: AND ue.due_date >= sysdate

Line 166: FROM AHL_MR_INTERVALS AMI, AHL_UNIT_EFFECTIVITIES_B UE

162:
163:
164: CURSOR c_get_due_val(c_ue_id NUMBER, c_counter_id VARCHAR2) IS
165: SELECT UE.DUE_COUNTER_VALUE, UE.CSI_ITEM_INSTANCE_ID
166: FROM AHL_MR_INTERVALS AMI, AHL_UNIT_EFFECTIVITIES_B UE
167: WHERE AMI.COUNTER_ID = c_counter_id
168: AND AMI.MR_INTERVAL_ID = UE.MR_INTERVAL_ID
169: AND UE.unit_effectivity_id = c_ue_id;
170:

Line 261: AHL_UNIT_EFFECTIVITIES_B AUEB

257: ) IS
258: SELECT AMIV.interval_value
259:
260: FROM AHL_MR_INTERVALS_V AMIV,
261: AHL_UNIT_EFFECTIVITIES_B AUEB
262:
263: WHERE AMIV.mr_interval_id = AUEB.mr_interval_id
264: AND AUEB.unit_effectivity_id = c_ue_id
265: AND AMIV.counter_id = c_counter_id;

Line 346: FROM AHL_UNIT_EFFECTIVITIES_B AUEB,

342:
343: CURSOR c_get_accomplished_UE(c_instance_id NUMBER) IS
344: SELECT * FROM (
345: SELECT AUEB.UNIT_EFFECTIVITY_ID,AUEB.ACCOMPLISHED_DATE
346: FROM AHL_UNIT_EFFECTIVITIES_B AUEB,
347: AHL_MR_HEADERS_B MRHB
348: WHERE AUEB.STATUS_CODE = 'MR-TERMINATE'
349: AND AUEB.CSI_ITEM_INSTANCE_ID = c_instance_id
350: AND MRHB.PROGRAM_SUBTYPE_CODE IN (

Line 366: AHL_UNIT_EFFECTIVITIES_B AUEB,

362:
363: CURSOR c_get_accomplished_reading( c_ue_id NUMBER, c_counter_id VARCHAR2) IS
364: SELECT AUA.COUNTER_VALUE
365: FROM AHL_UNIT_ACCOMPLISHMNTS AUA,
366: AHL_UNIT_EFFECTIVITIES_B AUEB,
367: AHL_MR_INTERVALS AMI
368: WHERE AMI.COUNTER_ID = c_counter_id
369: AND AUEB.UNIT_EFFECTIVITY_ID = c_ue_id
370: AND AUEB.MR_INTERVAL_ID = AMI.MR_INTERVAL_ID