20: between conv.start_date and conv.end_date;
21: */
22: CURSOR C IS
23: select add_months(x_prorate_date,x_life)
24: from dual;
25:
26: BEGIN
27: open c;
28: fetch c into x_end_date;
52:
53: -- added the following cursor for bugfix 1055453
54: CURSOR C IS
55: select add_months(x_prorate_date,x_life)
56: from dual;
57:
58: l_end_date date;
59: Begin
60: open c;
154:
155: -- If Calendars are not setup OR some other problem then return life = 1 month
156: select decode(x_life,null,1,0,1,x_life)
157: into x_life
158: from dual;
159:
160: OPEN GET_RSR;
161: FETCH GET_RSR INTO l_rsr;
162: CLOSE GET_RSR;