APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on OZF_OFFER_PERFORMANCES

Line 504: , ozf_offer_performances op

500: CURSOR csr_asso_offr_performance(cv_claim_line_id IN NUMBER) IS
501: SELECT op.offer_performance_id
502: FROM ozf_claim_lines_util lu
503: , ozf_funds_utilized fu
504: , ozf_offer_performances op
505: WHERE lu.utilization_id = fu.utilization_id
506: AND fu.component_type = 'OFFR'
507: AND fu.component_id = op.list_header_id
508: AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))

Line 515: , ozf_offer_performances op

511:
512: CURSOR csr_line_offr_performance(cv_claim_line_id IN NUMBER) IS
513: SELECT op.offer_performance_id
514: FROM ozf_claim_lines ln
515: , ozf_offer_performances op
516: WHERE ln.activity_type = 'OFFR'
517: AND ln.activity_id = op.list_header_id
518: AND (op.requirement_type IS NULL OR op.requirement_type NOT IN ('AMOUNT', 'VOLUME'))
519: AND op.required_flag = 'Y'