4104: AND B.Status_Code = 'STORE DRAFT';
4105:
4106: CURSOR C_Get_Quota_Credit_Type IS
4107: SELECT Sales_Credit_Type_Id
4108: FROM OE_SALES_CREDIT_TYPES
4109: WHERE Quota_Flag = 'Y';
4110:
4111: Cursor c_obj_id(p_qte_header_id Number) IS
4112: Select object_id
6963: AND B.Status_Code = 'DRAFT';
6964:
6965: CURSOR C_Get_Quota_Credit_Type IS
6966: SELECT Sales_Credit_Type_Id
6967: FROM OE_SALES_CREDIT_TYPES
6968: WHERE Quota_Flag = 'Y';
6969:
6970: CURSOR C_Get_SCredit_Exists(l_qte_hdr_id NUMBER) IS
6971: SELECT 'Y'