APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_REASON_CODES_VL

Line 1146: FROM ozf_reason_codes_vl

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

Line 1726: FROM ozf_reason_codes_vl

1722: -- [BEGIN OF BUG 3500049 FIXING]
1723: -- SELECT substr(name,1,30) name
1724: SELECT SUBSTRB(name,1,30) name
1725: -- [END OF BUG 3500049 FIXING]
1726: FROM ozf_reason_codes_vl
1727: WHERE reason_code_id = cv_reason_code_id;
1728:
1729: BEGIN
1730: -- Start populating the interface record values