DBA Data[Home] [Help]

APPS.OZF_GL_INTERFACE_PVT dependencies on OZF_OFFERS

Line 1174: , ozf_offers o

1170:
1171: CURSOR offer_code_csr(cv_utilization_id IN NUMBER) IS
1172: select o.offer_code
1173: from ozf_funds_utilized_all_b fu
1174: , ozf_offers o
1175: where fu.plan_type = 'OFFR'
1176: and fu.plan_id = o.qp_list_header_id
1177: and fu.utilization_id = cv_utilization_id;
1178:

Line 1306: , ozf_offers o

1302: select lu.claim_line_util_id
1303: from ozf_claim_lines_all ln
1304: , ozf_claim_lines_util_all lu
1305: , ozf_funds_utilized_all_b fu
1306: , ozf_offers o
1307: , ams_custom_setup_attr c
1308: where ln.claim_line_id = lu.claim_line_id
1309: and fu.utilization_id = lu.utilization_id
1310: and ln.item_type = 'PRODUCT'