DBA Data[Home] [Help]

APPS.ARP_PROCESS_APPLICATION dependencies on OZF_CLAIMS

Line 7852: l_claim_status ozf_claims.status_code%TYPE; --Add for bug 13464283

7848: l_c_app_amt NUMBER := 0;
7849: l_amt_in_dispute NUMBER := 0;
7850: l_claim_flag ar_payment_schedules.active_claim_flag%TYPE := 'I';
7851: l_amt_applied NUMBER;
7852: l_claim_status ozf_claims.status_code%TYPE; --Add for bug 13464283
7853: cursor c_ra_app_id (p_cust_trx_id varchar2) is
7854: select receivable_application_id ra_app_id,
7855: amount_applied ,
7856: application_ref_type app_ref_type

Line 7945: FROM ozf_claims oc

7941: -- Added Begin/End block for bug 13464283
7942: BEGIN
7943: SELECT oc.status_code --Add for bug 13464283
7944: INTO l_claim_status
7945: FROM ozf_claims oc
7946: WHERE claim_number = x_claim_number;
7947: EXCEPTION
7948: WHEN OTHERS THEN
7949: l_claim_status := null;