APPS.OZF_AUTOPAY_PVT dependencies on OZF_CLAIMS

Line 308: from ozf_claims_all

304: l_cust_name_num VARCHAR2(70);
305:
306: CURSOR claim_info_csr(p_claim_id in number) IS
307: select object_version_number, sales_rep_id
308: from ozf_claims_all
309: where claim_id = p_claim_id;
310:
311: l_object_version_number number;
312: l_return_status varchar2(1);

Line 327: FROM ozf_claims

323: l_sales_rep_id NUMBER;
324:
325: CURSOR csr_claim_num(cv_claim_id IN NUMBER) IS
326: SELECT claim_number, amount, cust_billto_acct_site_id
327: FROM ozf_claims
328: WHERE claim_id = cv_claim_id;
329: l_claim_num varchar2(30);
330: l_claim_amt number;
331: l_cust_billto_acct_site_id number;