APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_REASON_CODES_VL

Line 1142: FROM ozf_reason_codes_vl

1138:
1139: -- Cursor to get claim reason name -- 11.5.10 Enhancements.
1140: CURSOR csr_get_reason_name (cv_reason_code_id IN NUMBER) IS
1141: SELECT SUBSTRB(name,1,30) name
1142: FROM ozf_reason_codes_vl
1143: WHERE reason_code_id = cv_reason_code_id;
1144:
1145: CURSOR csr_product_desc(cv_inventory_item_id IN NUMBER) IS
1146: SELECT SUBSTRB(description, 1, 240)

Line 1717: FROM ozf_reason_codes_vl

1713: -- [BEGIN OF BUG 3500049 FIXING]
1714: -- SELECT substr(name,1,30) name
1715: SELECT SUBSTRB(name,1,30) name
1716: -- [END OF BUG 3500049 FIXING]
1717: FROM ozf_reason_codes_vl
1718: WHERE reason_code_id = cv_reason_code_id;
1719:
1720: BEGIN
1721: -- Start populating the interface record values