APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 1039: FROM ahl_unit_deferrals_b

1035: DELETE FROM ahl_unit_deferrals_tl
1036: WHERE unit_deferral_id IN
1037: (
1038: SELECT unit_deferral_id
1039: FROM ahl_unit_deferrals_b
1040: WHERE unit_effectivity_id = l_unit_effectivity_id
1041: );
1042:
1043: DELETE FROM ahl_unit_deferrals_b

Line 1043: DELETE FROM ahl_unit_deferrals_b

1039: FROM ahl_unit_deferrals_b
1040: WHERE unit_effectivity_id = l_unit_effectivity_id
1041: );
1042:
1043: DELETE FROM ahl_unit_deferrals_b
1044: WHERE unit_effectivity_id = l_unit_effectivity_id;
1045:
1046: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1047: THEN

Line 1189: from ahl_unit_deferrals_b

1185: cursor ue_deferral_csr(p_ue_id IN NUMBER)
1186: is
1187: select unit_deferral_id, object_version_number, unit_deferral_type,
1188: approval_status_code, ata_sequence_id, deferral_effective_on
1189: from ahl_unit_deferrals_b
1190: where unit_effectivity_id = p_ue_id and
1191: unit_deferral_type in ('MEL', 'CDL')
1192: for update of object_version_number;
1193:

Line 1220: from ahl_unit_deferrals_b

1216: -- query for defer details.
1217: cursor ue_defer_csr (p_ue_id IN NUMBER)
1218: is
1219: select 'x'
1220: from ahl_unit_deferrals_b
1221: where unit_effectivity_id = p_ue_id
1222: and unit_deferral_type = 'DEFERRAL'
1223: and approval_status_code = 'DEFERRAL_PENDING';
1224:

Line 1229: from ahl_unit_deferrals_b

1225: -- query for defer details for child UEs.
1226: cursor ue_defer_child_csr (p_ue_id IN NUMBER)
1227: is
1228: select 'x'
1229: from ahl_unit_deferrals_b
1230: where unit_effectivity_id IN (select related_ue_id
1231: from ahl_ue_relationships
1232: start with ue_id = p_ue_id
1233: connect by PRIOR related_ue_id = ue_id)

Line 1255: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,

1251: --p_cs_incident_id IN NUMBER)
1252: is
1253: select count(ue.cs_incident_id)
1254: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1255: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1256: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1257: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1258: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1259: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID

Line 1743: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,

1739: CURSOR nr_mel_cdl_csr(p_mel_cdl_header_id IN NUMBER) IS
1740: SELECT UE.unit_effectivity_id
1741: FROM
1742: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1743: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1744: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1745: WHERE
1746: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1747: --AND

Line 1763: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,

1759: CURSOR nr_pc_node_csr(p_pc_node_id IN NUMBER) IS
1760: SELECT UE.unit_effectivity_id
1761: FROM
1762: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1763: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1764: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1765: WHERE
1766: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1767: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID

Line 1971: FROM ahl_unit_deferrals_b

1967:
1968: CURSOR get_ue_details
1969: IS
1970: SELECT unit_deferral_type, approval_status_code
1971: FROM ahl_unit_deferrals_b
1972: WHERE unit_effectivity_id = p_unit_effectivity_id AND
1973: unit_deferral_type IN ('MEL', 'CDL');
1974:
1975: l_deferral_type VARCHAR2(30);

Line 2028: FROM ahl_unit_deferrals_b

2024:
2025: CURSOR get_mel_cdl_status
2026: IS
2027: SELECT approval_status_code, unit_deferral_type
2028: FROM ahl_unit_deferrals_b
2029: WHERE unit_effectivity_id = p_unit_effectivity_id;
2030:
2031: l_deferral_type VARCHAR2(30);
2032: l_approval_code VARCHAR2(30);

Line 2168: FROM ahl_unit_deferrals_b

2164:
2165: CURSOR check_ue_mel_cdl_approved
2166: IS
2167: SELECT 'x'
2168: FROM ahl_unit_deferrals_b
2169: WHERE unit_effectivity_id = p_unit_effectivity_id AND
2170: unit_deferral_type IN ('MEL', 'CDL') AND
2171: approval_status_code IN ('DEFERRAL_PENDING', 'DEFERRED');
2172:

Line 2178: FROM ahl_unit_deferrals_b

2174: --Fix for Bug# 5350385
2175: CURSOR is_ue_mel_cdl_qual
2176: IS
2177: SELECT 'x'
2178: FROM ahl_unit_deferrals_b
2179: WHERE unit_effectivity_id = p_unit_effectivity_id AND
2180: unit_deferral_type IN ('MEL', 'CDL');
2181:
2182: BEGIN