APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on OZF_OFFER_PERFORMANCES

Line 535: , ozf_offer_performances op

531: CURSOR csr_asso_offr_performance(cv_claim_line_id IN NUMBER) IS
532: SELECT op.offer_performance_id
533: FROM ozf_claim_lines_util lu
534: , ozf_funds_utilized fu
535: , ozf_offer_performances op
536: WHERE lu.utilization_id = fu.utilization_id
537: AND fu.component_type = 'OFFR'
538: AND fu.component_id = op.list_header_id
539: AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))

Line 546: , ozf_offer_performances op

542:
543: CURSOR csr_line_offr_performance(cv_claim_line_id IN NUMBER) IS
544: SELECT op.offer_performance_id
545: FROM ozf_claim_lines ln
546: , ozf_offer_performances op
547: WHERE ln.activity_type = 'OFFR'
548: AND ln.activity_id = op.list_header_id
549: AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))
550: AND op.required_flag = 'Y'