APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_REASON_CODES_VL

Line 1306: FROM ozf_reason_codes_vl

1302:
1303: -- Cursor to get claim reason name
1304: CURSOR csr_get_reason_name (cv_reason_code_id IN NUMBER) IS
1305: SELECT SUBSTRB(name,1,30) name
1306: FROM ozf_reason_codes_vl
1307: WHERE reason_code_id = cv_reason_code_id;
1308: --End:Bug:2781186
1309:
1310:

Line 1594: FROM ozf_reason_codes_vl

1590: AND display = 'Y';
1591:
1592: CURSOR csr_reason_code(cv_reason_code_id IN NUMBER) IS
1593: SELECT adjustment_reason_code
1594: FROM ozf_reason_codes_vl
1595: WHERE reason_code_id = cv_reason_code_id;
1596:
1597: CURSOR csr_root_claim_number(cv_root_claim_id IN NUMBER) IS
1598: SELECT claim_number