APPS.AHL_REPORT_UTILS_PVT dependencies on AHL_MR_HEADERS_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 347: AHL_MR_HEADERS_B MRHB

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 (
351: Select parameter_value