[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;
307: -- Parent CC Num
308: BEGIN
309: SELECT cch.cc_num
310: INTO p_parent_cc_num
311: FROM igc_cc_headers_all cch
312: WHERE cch.cc_header_id = l_header_rec.parent_header_id;
313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN
315: p_parent_cc_num := NULL;