DBA Data[Home] [Help]

APPS.OZF_AUTOPAY_PVT dependencies on OZF_CLAIMS

Line 336: from ozf_claims_all

332: l_cust_name_num VARCHAR2(70);
333:
334: CURSOR claim_info_csr(p_claim_id in number) IS
335: select object_version_number, sales_rep_id
336: from ozf_claims_all
337: where claim_id = p_claim_id;
338:
339: l_object_version_number number;
340: l_return_status varchar2(1);

Line 355: FROM ozf_claims

351: l_sales_rep_id NUMBER;
352:
353: CURSOR csr_claim_num(cv_claim_id IN NUMBER) IS
354: SELECT claim_number, amount, cust_billto_acct_site_id
355: FROM ozf_claims
356: WHERE claim_id = cv_claim_id;
357: l_claim_num varchar2(30);
358: l_claim_amt number;
359: l_cust_billto_acct_site_id number;