DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on QP_LIST_HEADERS_B

Line 2355: FROM qp_list_headers_b qp,ozf_offers ofs

2351: CURSOR c_offer_date IS
2352: SELECT qp.start_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
2353: NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,ofs.owner_id,ofs.custom_setup_id,
2354: ofs.org_id
2355: FROM qp_list_headers_b qp,ozf_offers ofs
2356: WHERE qp.list_header_id = p_offer_id
2357: AND qp.list_header_id = ofs.qp_list_header_id;
2358:
2359: --get product information.

Line 2781: FROM qp_list_headers_b qp,ozf_offers ofs

2777: CURSOR c_offer_date IS
2778: SELECT qp.start_date_active,qp.end_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
2779: ofs.custom_setup_id,NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,
2780: ofs.org_id
2781: FROM qp_list_headers_b qp,ozf_offers ofs
2782: WHERE qp.list_header_id = p_offer_id
2783: AND qp.list_header_id = ofs.qp_list_header_id;
2784:
2785: ---get distribution