APPS.AHL_COMPLEX_MX_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 112: FROM AHL_UNIT_EFFECTIVITIES_B UMP,

108: AND tmp.name = ii.counter_template_name
109: ) AMI_II_COUNTER_ID,
110: UMP.counter_id UMPCounter_ID,
111: UMP.due_counter_value
112: FROM AHL_UNIT_EFFECTIVITIES_B UMP,
113: AHL_MR_HEADERS_B MRH,
114: AHL_MR_INTERVALS AMI
115: WHERE
116: --Table joins

Line 160: FROM AHL_UNIT_EFFECTIVITIES_B UMP,

156: AND tmp.name = ii.counter_template_name
157: ) AMI_II_COUNTER_ID,
158: UMP.counter_id UMPCounter_ID,
159: UMP.due_counter_value
160: FROM AHL_UNIT_EFFECTIVITIES_B UMP,
161: AHL_MR_HEADERS_B MRH,
162: AHL_MR_INTERVALS AMI
163: WHERE
164: --Table joins

Line 577: FROM ahl_unit_effectivities_b ue,

573: l_removal_nr_due DATE;
574:
575: CURSOR get_removal_nr_due_date(c_instance_id NUMBER) IS
576: SELECT NVL(ue.earliest_due_date,ue.due_date)
577: FROM ahl_unit_effectivities_b ue,
578: CS_INCIDENTS_ALL_B nr
579: WHERE ue.csi_item_instance_id =c_instance_id
580: AND ue.cs_incident_id =nr.incident_id
581: AND nr.incident_type_id =fnd_profile.value('AHL_REMOVAL_NON_ROUTINE') -- Removal NR type Id

Line 615: FROM ahl_unit_effectivities_b B,

611: l_assm_due DATE;
612:
613: CURSOR get_assm_due_date(c_instance_id NUMBER) IS
614: SELECT MIN(NVL(earliest_due_date,due_date))
615: FROM ahl_unit_effectivities_b B,
616: ahl_mr_headers_b mr
617: WHERE B.mr_header_id =mr.mr_header_id
618: AND NVL(mr.service_type_code,'ASR') = 'ASR'
619: AND B.object_type ='MR'