DBA Data[Home] [Help]

APPS.OZF_ACCRUAL_ENGINE dependencies on QP_LIST_HEADERS_ALL

Line 2247: FROM qp_list_headers_all qp, ozf_offers off

2243:
2244: --nirprasa,ER 8399134
2245: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
2246: SELECT qp.orig_org_id offer_org_id
2247: FROM qp_list_headers_all qp, ozf_offers off
2248: WHERE qp.list_header_id = p_list_header_id
2249: AND qp.list_header_id = off.qp_list_header_id;
2250:
2251: l_offer_info c_offer_info%ROWTYPE;

Line 2947: FROM ozf_offers off, qp_list_headers_all qp

2943: WHERE org_id = p_org_id;
2944:
2945: CURSOR c_offer_details(p_qp_list_header_id NUMBER) IS
2946: SELECT custom_setup_id, description
2947: FROM ozf_offers off, qp_list_headers_all qp
2948: WHERE off.qp_list_header_id = p_qp_list_header_id
2949: AND off.qp_list_header_id = qp.list_header_id;
2950:
2951: CURSOR c_is_parent_line (p_line_id IN NUMBER) IS