APPS.AHL_AVF_OPER_VSTS_PVT dependencies on AHL_OPER_VST_AUTOCREATE

Line 175: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

171: --Get the count of rows matching with the UC and org of the flight schedule and enabled_flag as Y
172: Cursor get_non_null_org_count (c_uc_id IN NUMBER, c_org_id IN NUMBER)
173: IS
174: SELECT count (*)
175: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
176: WHERE op.enabled_flag = 'Y'
177: AND uc.unit_config_header_id = c_uc_id
178: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
179: AND op.organization_id = c_org_id;

Line 186: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

182: --Get the count of rows matching with the UC, org and dep of the flight schedule and enabled_flag as Y
183: Cursor get_non_null_dep_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER)
184: IS
185: SELECT count (*)
186: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
187: WHERE op.enabled_flag = 'Y'
188: AND uc.unit_config_header_id = c_uc_id
189: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
190: AND op.organization_id = c_org_id

Line 198: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

194: --Get the count of rows matching with the UC, org, dep and category of the flight schedule and enabled_flag as Y
195: Cursor get_non_null_cat_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER, c_flight_cat IN VARCHAR2)
196: IS
197: SELECT count (*)
198: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
199: WHERE op.enabled_flag = 'Y'
200: AND uc.unit_config_header_id = c_uc_id
201: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
202: AND op.organization_id = c_org_id

Line 222: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

218: c_org_count IN NUMBER, c_dep_count IN NUMBER, c_cat_count IN NUMBER,
219: c_create_for IN VARCHAR2, c_ground_time IN NUMBER)
220: IS
221: SELECT op.*
222: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
223: WHERE op.enabled_flag = 'Y'
224: AND uc.unit_config_header_id = c_uc_id
225: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
226: AND ( (op.organization_id = c_org_id)

Line 1529: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

1525: --Get the count of rows matching with the UC and org of the flight schedule and enabled_flag as Y
1526: Cursor get_non_null_org_count (c_uc_id IN NUMBER, c_org_id IN NUMBER)
1527: IS
1528: SELECT count (*)
1529: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1530: WHERE op.enabled_flag = 'Y'
1531: AND uc.unit_config_header_id = c_uc_id
1532: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1533: AND op.organization_id = c_org_id;

Line 1540: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

1536: --Get the count of rows matching with the UC, org and dep of the flight schedule and enabled_flag as Y
1537: Cursor get_non_null_dep_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER)
1538: IS
1539: SELECT count (*)
1540: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1541: WHERE op.enabled_flag = 'Y'
1542: AND uc.unit_config_header_id = c_uc_id
1543: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1544: AND op.organization_id = c_org_id

Line 1552: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

1548: --Get the count of rows matching with the UC, org, dep and category of the flight schedule and enabled_flag as Y
1549: Cursor get_non_null_cat_count (c_uc_id IN NUMBER, c_org_id IN NUMBER, c_dep_id IN NUMBER, c_flight_cat IN VARCHAR2)
1550: IS
1551: SELECT count (*)
1552: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1553: WHERE op.enabled_flag = 'Y'
1554: AND uc.unit_config_header_id = c_uc_id
1555: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1556: AND op.organization_id = c_org_id

Line 1576: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc

1572: c_org_count IN NUMBER, c_dep_count IN NUMBER, c_cat_count IN NUMBER,
1573: c_create_for IN VARCHAR2, c_ground_time IN NUMBER)
1574: IS
1575: SELECT op.*
1576: FROM ahl_oper_vst_autocreate op, ahl_unit_config_headers uc
1577: WHERE op.enabled_flag = 'Y'
1578: AND uc.unit_config_header_id = c_uc_id
1579: AND (select mc_id from ahl_mc_headers_b where mc_header_id = uc.master_config_id) = op.mc_id
1580: AND ( (op.organization_id = c_org_id)