APPS.OZF_OFFER_ADJUSTMENT_PVT dependencies on OZF_OFFERS

Line 80: FROM ozf_offers

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

Line 454: FROM ozf_offers

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