[Home] [Help]
2277: WHERE resale_batch_id = p_resale_batch_id;
2278:
2279: CURSOR line_count_csr IS
2280: SELECT count(1)
2281: FROM ozf_resale_batch_line_maps
2282: WHERE resale_batch_id = p_resale_batch_id;
2283:
2284: CURSOR count_cust_acctid_csr(p_id NUMBER) IS
2285: SELECT 1
4859: END IF;
4860: -- End: bug # 5997978 fixed
4861:
4862: -- INSERT INTO mapping table
4863: OZF_RESALE_BATCH_LINE_MAPS_PKG.Insert_Row(
4864: px_resale_batch_line_map_id => l_map_id,
4865: p_resale_batch_id => p_resale_batch_id,
4866: p_resale_line_id => p_line_id,
4867: px_object_version_number => l_obj_ver_num,
6790: utilization_type = 'ACCRUAL' -- nepanda : Fix for 12747322 and 12660466 adjustments were getting added to obj_fundsum table twice
6791: AND object_id IN
6792: (select orl.resale_line_id
6793: from ozf_resale_lines_all orl,
6794: OZF_RESALE_BATCH_LINE_MAPS_ALL orblm
6795: where orl.resale_line_id = orblm.resale_line_id
6796: and orblm.resale_batch_id = p_batch_id)
6797: AND EXISTS (SELECT 1 FROM ozf_act_budgets_int where request_id = fut.request_id)
6798: GROUP BY