APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 1226: FROM ozf_sys_parameters_all osp,

1222: CURSOR csr_get_interface_attr_dtls (cv_claim_id IN NUMBER) IS
1223: SELECT oc.customer_reason, oc.customer_ref_number,
1224: oc.reason_code_id, osp.post_to_gl,
1225: (SELECT SUBSTRB(name,1,30) FROM ozf_reason_codes_vl WHERE reason_code_id = oc.reason_code_id) as name
1226: FROM ozf_sys_parameters_all osp,
1227: ozf_claims_all oc
1228: WHERE
1229: NVL(osp.org_id, -99) = NVL(oc.org_id, -99)
1230: AND oc.claim_id = cv_claim_id;