APPS.OZF_CLAIM_PVT dependencies on OZF_CLAIMS_ALL_S

Line 3731: SELECT ozf_claims_all_s.nextval FROM dual;

3727:
3728: l_auto_assign_flag varchar2(1);
3729:
3730: CURSOR claim_id_csr IS
3731: SELECT ozf_claims_all_s.nextval FROM dual;
3732:
3733: CURSOR trade_profile_csr(p_customer_account_id in number) IS
3734: SELECT vendor_id, vendor_site_id
3735: FROM ozf_cust_trd_prfls

Line 7402: update ozf_claims_all set status_code = 'OPEN'

7398:
7399: -- Added For ER#9453443
7400: IF(l_claim.offer_id IS NOT NULL AND G_INIT_STATUS = 'NEW') THEN
7401:
7402: update ozf_claims_all set status_code = 'OPEN'
7403: where claim_id = l_claim.claim_id;
7404:
7405: END IF;
7406: