APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_OFFERS

Line 823: , ozf_offers o

819:
820: CURSOR offer_code_csr(cv_utilization_id IN NUMBER) IS
821: select o.offer_code
822: from ozf_funds_utilized_all_b fu
823: , ozf_offers o
824: where fu.plan_type = 'OFFR'
825: and fu.plan_id = o.qp_list_header_id
826: and fu.utilization_id = cv_utilization_id;
827:

Line 2713: ozf_offers a,

2709:
2710: --//Bug fix 10037158
2711: CURSOR offer_type_csr(p_id in number) IS
2712: SELECT offer_type FROM
2713: ozf_offers a,
2714: ozf_funds_utilized_all_b b
2715: WHERE a.qp_list_header_id = b.plan_id
2716: AND b.utilization_id = p_id;
2717: