APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_DEFERRALS_B

Line 1122: FROM ahl_unit_deferrals_b

1118: DELETE FROM ahl_unit_deferrals_tl
1119: WHERE unit_deferral_id IN
1120: (
1121: SELECT unit_deferral_id
1122: FROM ahl_unit_deferrals_b
1123: WHERE unit_effectivity_id = l_unit_effectivity_id
1124: );
1125:
1126: DELETE FROM ahl_unit_deferrals_b

Line 1126: DELETE FROM ahl_unit_deferrals_b

1122: FROM ahl_unit_deferrals_b
1123: WHERE unit_effectivity_id = l_unit_effectivity_id
1124: );
1125:
1126: DELETE FROM ahl_unit_deferrals_b
1127: WHERE unit_effectivity_id = l_unit_effectivity_id;
1128:
1129: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)
1130: THEN

Line 1272: from ahl_unit_deferrals_b

1268: cursor ue_deferral_csr(p_ue_id IN NUMBER)
1269: is
1270: select unit_deferral_id, object_version_number, unit_deferral_type,
1271: approval_status_code, ata_sequence_id, deferral_effective_on
1272: from ahl_unit_deferrals_b
1273: where unit_effectivity_id = p_ue_id and
1274: unit_deferral_type in ('MEL', 'CDL')
1275: for update of object_version_number;
1276:

Line 1303: from ahl_unit_deferrals_b

1299: -- query for defer details.
1300: cursor ue_defer_csr (p_ue_id IN NUMBER)
1301: is
1302: select 'x'
1303: from ahl_unit_deferrals_b
1304: where unit_effectivity_id = p_ue_id
1305: and unit_deferral_type = 'DEFERRAL'
1306: and approval_status_code = 'DEFERRAL_PENDING';
1307:

Line 1312: from ahl_unit_deferrals_b

1308: -- query for defer details for child UEs.
1309: cursor ue_defer_child_csr (p_ue_id IN NUMBER)
1310: is
1311: select 'x'
1312: from ahl_unit_deferrals_b
1313: where unit_effectivity_id IN (select related_ue_id
1314: from ahl_ue_relationships
1315: start with ue_id = p_ue_id
1316: connect by PRIOR related_ue_id = ue_id)

Line 1338: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,

1334: --p_cs_incident_id IN NUMBER)
1335: is
1336: select count(ue.cs_incident_id)
1337: from AHL_UNIT_EFFECTIVITIES_B UE, CS_INCIDENTS_ALL_B CS,
1338: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1339: AHL_MEL_CDL_ATA_SEQUENCES SEQ
1340: where SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1341: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID
1342: AND UE.CS_INCIDENT_ID = CS.INCIDENT_ID

Line 1831: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,

1827: CURSOR nr_mel_cdl_csr(p_mel_cdl_header_id IN NUMBER) IS
1828: SELECT UE.unit_effectivity_id
1829: FROM
1830: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1831: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF--,
1832: --AHL_MEL_CDL_ATA_SEQUENCES SEQ
1833: WHERE
1834: --SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1835: --AND

Line 1851: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,

1847: CURSOR nr_pc_node_csr(p_pc_node_id IN NUMBER) IS
1848: SELECT UE.unit_effectivity_id
1849: FROM
1850: AHL_UNIT_EFFECTIVITIES_APP_V UE, CS_INCIDENTS_ALL_B CS,
1851: CS_INCIDENT_STATUSES_B STATUS, AHL_UNIT_DEFERRALS_B UDF,
1852: AHL_MEL_CDL_ATA_SEQUENCES SEQ, AHL_MEL_CDL_HEADERS HDR
1853: WHERE
1854: SEQ.MEL_CDL_ATA_SEQUENCE_ID = UDF.ATA_SEQUENCE_ID
1855: AND UDF.UNIT_EFFECTIVITY_ID = UE.UNIT_EFFECTIVITY_ID

Line 2064: FROM ahl_unit_deferrals_b

2060:
2061: CURSOR get_ue_details
2062: IS
2063: SELECT unit_deferral_type, approval_status_code
2064: FROM ahl_unit_deferrals_b
2065: WHERE unit_effectivity_id = p_unit_effectivity_id AND
2066: unit_deferral_type IN ('MEL', 'CDL');
2067:
2068: l_deferral_type VARCHAR2(30);

Line 2121: FROM ahl_unit_deferrals_b

2117:
2118: CURSOR get_mel_cdl_status
2119: IS
2120: SELECT approval_status_code, unit_deferral_type
2121: FROM ahl_unit_deferrals_b
2122: WHERE unit_effectivity_id = p_unit_effectivity_id;
2123:
2124: l_deferral_type VARCHAR2(30);
2125: l_approval_code VARCHAR2(30);

Line 2262: FROM ahl_unit_deferrals_b

2258:
2259: CURSOR check_ue_mel_cdl_approved
2260: IS
2261: SELECT 'x'
2262: FROM ahl_unit_deferrals_b
2263: WHERE unit_effectivity_id = p_unit_effectivity_id AND
2264: unit_deferral_type IN ('MEL', 'CDL') AND
2265: approval_status_code IN ('DEFERRAL_PENDING', 'DEFERRED');
2266:

Line 2272: FROM ahl_unit_deferrals_b

2268: --Fix for Bug# 5350385
2269: CURSOR is_ue_mel_cdl_qual
2270: IS
2271: SELECT 'x'
2272: FROM ahl_unit_deferrals_b
2273: WHERE unit_effectivity_id = p_unit_effectivity_id AND
2274: unit_deferral_type IN ('MEL', 'CDL');
2275:
2276: BEGIN