DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on QP_LIST_HEADERS_B

Line 1833: FROM qp_list_headers_b qp,ozf_offers ofs

1829: CURSOR c_offer_date IS
1830: SELECT qp.start_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
1831: NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,ofs.owner_id,ofs.custom_setup_id,
1832: ofs.org_id
1833: FROM qp_list_headers_b qp,ozf_offers ofs
1834: WHERE qp.list_header_id = p_offer_id
1835: AND qp.list_header_id = ofs.qp_list_header_id;
1836:
1837: --get product information.

Line 2253: FROM qp_list_headers_b qp,ozf_offers ofs

2249: CURSOR c_offer_date IS
2250: SELECT qp.start_date_active,qp.end_date_active, NVL(qp.currency_code, ofs.fund_request_curr_code) currency_code,
2251: ofs.custom_setup_id,NVL(ofs.account_closed_flag,'N'),ofs.qualifier_id, ofs.qualifier_type,
2252: ofs.org_id
2253: FROM qp_list_headers_b qp,ozf_offers ofs
2254: WHERE qp.list_header_id = p_offer_id
2255: AND qp.list_header_id = ofs.qp_list_header_id;
2256:
2257: ---get distribution