DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 9782: FROM ozf_sd_batch_headers_all

9778: --Vendor details added for bug 6921727
9779: --Added created_by for bug 7578152
9780: CURSOR csr_batch_currency(cv_batch_id IN NUMBER) IS
9781: SELECT currency_code, org_id, vendor_id, vendor_site_id, created_by
9782: FROM ozf_sd_batch_headers_all
9783: WHERE batch_id = cv_batch_id;
9784:
9785: CURSOR csr_batch_header(cv_batch_id IN NUMBER) IS
9786: SELECT DISTINCT

Line 9791: , ozf_sd_batch_headers_all head

9787: util.cust_account_id
9788: , util.bill_to_site_use_id
9789: , head.claim_number
9790: FROM ozf_funds_utilized_all_b util
9791: , ozf_sd_batch_headers_all head
9792: , ozf_sd_batch_lines_all line
9793: WHERE head.batch_id = cv_batch_id
9794: AND head.batch_id = line.batch_id
9795: AND util.utilization_id = line.utilization_id;