APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 4655: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b ud

4651: CURSOR ahl_init_due_csr (p_csi_item_instance_id IN NUMBER,
4652: p_title IN VARCHAR2) IS
4653: SELECT ud.set_due_date, ue.unit_effectivity_id, ud.unit_deferral_id
4654: --FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud
4655: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b ud
4656: WHERE ue.unit_effectivity_id = ud.unit_effectivity_id AND
4657: ud.unit_deferral_type = 'INIT-DUE' AND
4658: ue.csi_item_instance_id = p_csi_item_instance_id AND
4659: ue.mr_header_id IN (select mr_header_id from ahl_mr_headers_b mr where mr.title = p_title) AND

Line 10066: FROM ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR

10062: nvl(MR.whichever_first_code, 'FIRST') whichever_first_code,
10063: UDF.unit_deferral_type, UE.CS_INCIDENT_ID, UDF.DEFERRAL_EFFECTIVE_ON,
10064: UDF.AFFECT_DUE_CALC_FLAG, UDF.SET_DUE_DATE, UDF.unit_deferral_id,
10065: MR.title
10066: FROM ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR
10067: WHERE UE.defer_from_ue_id = UDF.unit_effectivity_id
10068: AND UE.mr_header_id = MR.mr_header_id(+)
10069: AND UE.csi_item_instance_id = p_csi_item_instance_id
10070: AND UE.application_usg_code = p_appln_usage_code

Line 10072: --AND defer_from_ue_id IS NOT NULL -- not required as joining table ahl_unit_deferrals_b

10068: AND UE.mr_header_id = MR.mr_header_id(+)
10069: AND UE.csi_item_instance_id = p_csi_item_instance_id
10070: AND UE.application_usg_code = p_appln_usage_code
10071: AND status_code IS NULL
10072: --AND defer_from_ue_id IS NOT NULL -- not required as joining table ahl_unit_deferrals_b
10073: AND UDF.unit_deferral_type IN ('DEFERRAL', 'MEL','CDL')
10074: AND NOT EXISTS (SELECT 'x'
10075: FROM ahl_ue_relationships
10076: WHERE related_ue_id = UE.unit_effectivity_id

Line 10085: FROM ahl_unit_deferrals_b

10081: /* Commented as we retrieve this info in ahl_deferred_ue_csr
10082: -- Get deferral detail from ahl_unit_deferrals.
10083: CURSOR ahl_unit_deferral_csr (p_deferred_from_ue_id IN NUMBER) IS
10084: SELECT AFFECT_DUE_CALC_FLAG, SET_DUE_DATE, unit_deferral_id, deferral_effective_on
10085: FROM ahl_unit_deferrals_b
10086: WHERE unit_effectivity_id = p_deferred_from_ue_id
10087: AND unit_deferral_type = 'DEFERRAL';
10088: */
10089:

Line 15281: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter

15277: p_chain_seq_num in number) is
15278: SELECT ue.accomplished_date, ue.unit_effectivity_id, ue.loop_chain_seq_num, ue.mr_header_id,
15279: decode(ue.status_code, 'TERMINATED', ter.affect_due_calc_flag, def.affect_due_calc_flag),
15280: decode(ue.status_code, 'TERMINATED', ter.deferral_effective_on, def.deferral_effective_on)
15281: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter
15282: WHERE ue.defer_from_ue_id = def.unit_effectivity_id (+)
15283: AND ue.unit_effectivity_id = ter.unit_effectivity_id(+)
15284: AND ue.status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','TERMINATED')
15285: AND def.unit_deferral_type(+) = 'DEFERRAL'

Line 16261: FROM ahl_unit_thresholds aut, ahl_unit_deferrals_b udf

16257: -- added for USAF: Assembly Maint. Enh.: Support for initializing a NR.
16258: -- Get threshold details.
16259: CURSOR ahl_unit_threshold_csr (p_ue_id IN NUMBER) IS
16260: SELECT aut.counter_id, aut.counter_value, (select uom_code from csi_counters_b where counter_id = aut.counter_id) uom_code
16261: FROM ahl_unit_thresholds aut, ahl_unit_deferrals_b udf
16262: WHERE udf.unit_effectivity_id = p_ue_id
16263: AND udf.unit_deferral_id = aut.unit_deferral_id
16264: AND udf.unit_deferral_type = 'INIT-DUE';
16265: