public partial class Country { public decimal Id { get; set; } public string Code { get; set; } public string Name { get; set; } public string ForeignName { get; set; } public string StateFlag { get; set; } public string ZipCodeFlag { get; set; } public string EUFlag { get; set; } public string CrossBookingFlag { get; set; } public string Status { get; set; } public Nullable<System.DateTime> CreatedOn { get; set; } public Nullable<decimal> LastUpdatedBy { get; set; } public Nullable<System.DateTime> LastUpdatedOn { get; set; } public Nullable<decimal> PurgeYear { get; set; } }
procedure ibp_country_mstr_getlist ( p_country_id in number, p_cntry_getlist out SYS_REFCURSOR )as begin open p_cntry_getlist for select /*+index(ibt_country_master country_mas_status_idx)*/country_pid,country_code,country_name,country_fname from ibt_country_master where country_pid=p_country_id and country_status in ('A','D'); end;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)