DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_SD_BATCH_HEADERS_ALL

Line 12061: FROM ozf_sd_batch_headers_all

12057: --Vendor details added for bug 6921727
12058: --Added created_by for bug 7578152
12059: CURSOR csr_batch_currency(cv_batch_id IN NUMBER) IS
12060: SELECT currency_code, org_id, vendor_id, vendor_site_id, created_by
12061: FROM ozf_sd_batch_headers_all
12062: WHERE batch_id = cv_batch_id;
12063:
12064: CURSOR csr_batch_header(cv_batch_id IN NUMBER) IS
12065: SELECT DISTINCT

Line 12070: , ozf_sd_batch_headers_all head

12066: util.cust_account_id
12067: , util.bill_to_site_use_id
12068: , head.claim_number
12069: FROM ozf_funds_utilized_all_b util
12070: , ozf_sd_batch_headers_all head
12071: , ozf_sd_batch_lines_all line
12072: WHERE head.batch_id = cv_batch_id
12073: AND head.batch_id = line.batch_id
12074: --Fix for Bug 10047209