APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_OFFERS

Line 81: FROM ozf_offers

77: RETURN VARCHAR2
78: IS
79: CURSOR c_budgetOffer(cp_listHeaderId NUMBER) IS
80: SELECT nvl(budget_offer_yn,'N')
81: FROM ozf_offers
82: WHERE qp_list_header_id = cp_listHeaderId;
83: l_budgetOffer VARCHAR2(1);
84: BEGIN
85: OPEN c_budgetOffer(cp_listHeaderId => p_listHeaderId);

Line 455: FROM ozf_offers

451: -- end mthumu
452:
453: CURSOR c_custom_setup_id(p_list_header_id NUMBER) IS
454: SELECT custom_setup_id ,NVL(budget_offer_yn, 'N')
455: FROM ozf_offers
456: WHERE qp_list_header_id=p_list_header_id;
457: -- code to get custom setup for approval
458: CURSOR c_attr_available_flag(p_custom_setup_id NUMBER) IS
459: SELECT attr_available_flag