DBA Data[Home] [Help]

APPS.OZF_AUTO_WRITEOFF_PVT dependencies on OZF_CLAIMS

Line 68: FROM ozf_claims

64: claim_number,
65: payment_method,
66: status_code,
67: user_status_id
68: FROM ozf_claims
69: WHERE cust_account_id = NVL(p_cust_account_id , cust_account_id)
70: AND claim_type_id = NVL(p_claim_type_id , claim_type_id)
71: AND reason_code_id = NVL(p_reason_code_id , reason_code_id)
72: AND claim_class = NVL(p_claim_class , claim_class)

Line 183: UPDATE ozf_claims

179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'Job Parameter4-Reason Code: '||l_reason_code_name);
180: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '+---------------------------------------------------------------------------+');
181:
182: --bug#4940880 Update Payment Method
183: UPDATE ozf_claims
184: SET payment_method = 'WRITE_OFF'
185: WHERE cust_account_id = NVL(p_cust_account_id , cust_account_id)
186: AND claim_type_id = NVL(p_claim_type_id , claim_type_id)
187: AND reason_code_id = NVL(p_reason_code_id , reason_code_id)