[Home] [Help]
137: location_id,
138: cc_owner_user_id,
139: cc_preparer_user_id,
140: parent_header_id
141: FROM igc_cc_headers_all
142: WHERE cc_header_id = p_cc_header_id;
143:
144:
145: l_header_rec c_get_header%ROWTYPE;
305: -- Parent CC Num
306: BEGIN
307: SELECT cch.cc_num
308: INTO p_parent_cc_num
309: FROM igc_cc_headers_all cch
310: WHERE cch.cc_header_id = l_header_rec.parent_header_id;
311: EXCEPTION
312: WHEN NO_DATA_FOUND THEN
313: p_parent_cc_num := NULL;