APPS.AHL_MEL_CDL_APPROVALS_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 40: FROM ahl_unit_deferrals_b udf, ahl_unit_effectivities_b ue,

36: mtl.concatenated_segments item_number,
37: cs.incident_number,
38: cs.summary,
39: udf.object_version_number
40: FROM ahl_unit_deferrals_b udf, ahl_unit_effectivities_b ue,
41: cs_incidents_all_vl cs, ahl_mel_cdl_ata_sequences mca, csi_item_instances csi,
42: jtf_notes_vl note, mtl_system_items_kfv mtl
43: WHERE udf.unit_effectivity_id = ue.unit_effectivity_id
44: AND ue.csi_item_instance_id = csi.instance_id

Line 2162: ahl_unit_effectivities_b ue, ahl_unit_deferrals_b udf,

2158: (select visit_number from ahl_visit_tasks_b tsk, ahl_visits_b vst where
2159: vst.visit_id = tsk.visit_id and tsk.unit_effectivity_id =
2160: ue.unit_effectivity_id and rownum < 2) visit_number
2161: from cs_incidents_all_vl cs, cs_incident_types_vl cit,
2162: ahl_unit_effectivities_b ue, ahl_unit_deferrals_b udf,
2163: csi_item_instances csi, mtl_system_items_kfv mtl,
2164: ahl_mel_cdl_ata_sequences seq, ahl_repair_categories arc,
2165: ahl_mel_cdl_headers mch, ahl_pc_headers_b aph, ahl_pc_nodes_b apn,
2166: cs_incident_urgencies_vl ciu

Line 3829: from ahl_unit_deferrals_b

3825: cursor ue_deferral_csr(p_unit_deferral_id IN NUMBER)
3826: is
3827: select unit_effectivity_id, object_version_number, unit_deferral_type,
3828: approval_status_code, ata_sequence_id
3829: from ahl_unit_deferrals_b
3830: where unit_deferral_id = p_unit_deferral_id and
3831: unit_deferral_type in ('MEL', 'CDL')
3832: for update of object_version_number;
3833:

Line 4068: UPDATE AHL_UNIT_DEFERRALS_B

4064: source_lang = userenv('LANG')
4065: WHERE unit_deferral_id = l_object_id
4066: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4067:
4068: UPDATE AHL_UNIT_DEFERRALS_B
4069: SET approval_status_code = 'DEFERRAL_REJECTED',
4070: object_version_number = object_version_number + 1,
4071: last_update_date = sysdate,
4072: last_updated_by = fnd_global.user_id,

Line 4104: UPDATE AHL_UNIT_DEFERRALS_B

4100: source_lang = userenv('LANG')
4101: WHERE unit_deferral_id = l_object_id
4102: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4103:
4104: UPDATE AHL_UNIT_DEFERRALS_B
4105: SET approval_status_code = 'DEFERRAL_REJECTED',
4106: object_version_number = object_version_number + 1,
4107: last_update_date = sysdate,
4108: last_updated_by = fnd_global.user_id,

Line 4329: UPDATE AHL_UNIT_DEFERRALS_B

4325: SOURCE_LANG = userenv('LANG')
4326: WHERE unit_deferral_id = l_object_id
4327: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4328:
4329: UPDATE AHL_UNIT_DEFERRALS_B
4330: SET approval_status_code = 'DEFERRAL_REJECTED',
4331: object_version_number = object_version_number + 1,
4332: last_update_date = sysdate,
4333: last_updated_by = fnd_global.user_id,

Line 4364: UPDATE AHL_UNIT_DEFERRALS_B

4360: SOURCE_LANG = userenv('LANG')
4361: WHERE unit_deferral_id = l_object_id
4362: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
4363:
4364: UPDATE AHL_UNIT_DEFERRALS_B
4365: SET approval_status_code = 'DEFERRAL_REJECTED',
4366: object_version_number = object_version_number + 1,
4367: last_update_date = sysdate,
4368: last_updated_by = fnd_global.user_id,