[Home] [Help]
25: CURSOR CURSOR_00007(CYCLE_ID_1 number) IS
26: SELECT
27: MIN(COUNT_NO)
28: FROM
29: IC_CYCL_DTL
30: WHERE CYCLE_ID = CYCLE_ID_1;
31: CURSOR CURSOR_00011(CYCLE_ID_1 number) IS
32: SELECT
33: count(*)
94: END IF;
95: BEGIN
96: SELECT MIN(COUNT_NO)
97: INTO X_MIN_COUNT
98: FROM IC_CYCL_DTL
99: WHERE CYCLE_ID = CYCLE_ID_1
100: AND rownum=1;
101: /*
102: OPEN CURSOR_00007(CYCLE_ID_1);