[Home] [Help]
124: WHERE preceding_mr_header_id IS NOT NULL AND
125: preceding_csi_item_instance_id IS NOT NULL AND
126: preceding_forecast_seq IS NOT NULL
127: -- added for SB Enh: last accomplishment of MR is available in applicable mrs table.
128: AND NOT EXISTS (select 'x' from ahl_applicable_mrs appl
129: where appl.mr_header_id = tmp_ue.preceding_mr_header_id
130: and appl.csi_item_instance_id = tmp_ue.csi_item_instance_id
131: and appl.ACCOMPLISHED_UE_ID is not null);
132:
855: -- Added for SB Enhancements for accomplishment trigger type = TERMINATED_BY
856: BEGIN
857: SELECT DISTINCT mr_header_id, csi_item_instance_id,terminating_mr_header_id
858: BULK COLLECT INTO l_mr_id_tbl, l_ii_id_tbl, l_term_mr_id_tbl
859: FROM AHL_APPLICABLE_MRS appl_mr
860: WHERE appl_mr.terminating_mr_header_id IS NOT NULL;
861: EXCEPTION
862: WHEN OTHERS THEN
863: null;
3026:
3027: -- get start MRs
3028: CURSOR get_loop_start_mrs_csr IS
3029: SELECT distinct mr.title, csi_item_instance_id
3030: FROM ahl_applicable_mrs appl, ahl_mr_headers_b mr
3031: where appl.accomplish_trigger_type = 'LOOP'
3032: and appl.start_mr_header_id = appl.mr_header_id
3033: and appl.mr_header_id = mr.mr_header_id;
3034:
3404:
3405: -- get start MRs
3406: CURSOR get_loop_start_mrs_csr IS
3407: SELECT distinct mr.title, csi_item_instance_id
3408: FROM ahl_applicable_mrs appl, ahl_mr_headers_b mr
3409: where appl.accomplish_trigger_type = 'CHAIN'
3410: and appl.start_mr_header_id = appl.mr_header_id
3411: and appl.mr_header_id = mr.mr_header_id;
3412: