DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on DUAL

Line 24: from dual;

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;

Line 56: from dual;

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;

Line 158: from dual;

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;