39: WHERE bl.batch_id = cp_batch_id;
40: --
41: CURSOR csr_except(cp_batch_id IN NUMBER) IS
42: SELECT be.exception_text
43: FROM hr_pump_batch_exceptions be
44: WHERE be.source_type = 'BATCH_HEADER'
45: AND be.source_id = cp_batch_id
46: AND be.exception_sequence = (
47: SELECT MAX(bx.exception_sequence)
44: WHERE be.source_type = 'BATCH_HEADER'
45: AND be.source_id = cp_batch_id
46: AND be.exception_sequence = (
47: SELECT MAX(bx.exception_sequence)
48: FROM hr_pump_batch_exceptions bx
49: WHERE bx.source_type = 'BATCH_HEADER'
50: AND bx.source_id = cp_batch_id
51: );
52: --