98: FROM ozf_resale_lines_int
99: WHERE resale_line_int_id = p_id;
100:
101: CURSOR g_header_id_csr IS
102: SELECT ozf_resale_headers_all_s.nextval
103: FROM dual;
104:
105: CURSOR g_line_id_csr IS
106: SELECT ozf_resale_lines_all_s.nextval
177: WHERE resale_batch_id = cv_batch_id;
178:
179: CURSOR g_resale_header_org_id_csr(cv_header_id NUMBER) IS
180: SELECT org_id
181: FROM ozf_resale_headers_all
182: WHERE resale_header_id = cv_header_id;
183: -- End: bug # 5997978 fixed
184:
185: --Bug# 8414563 fixed by ateotia(+)