DBA Data[Home] [Help]

APPS.FA_CUA_MASS_UPDATE1_PKG dependencies on DUAL

Line 22: from dual;

18: between conv.start_date and conv.end_date;
19: */
20: CURSOR C IS
21: select add_months(x_prorate_date,x_life)
22: from dual;
23:
24: BEGIN
25: open c;
26: fetch c into x_end_date;

Line 54: from dual;

50:
51: -- added the following cursor for bugfix 1055453
52: CURSOR C IS
53: select add_months(x_prorate_date,x_life)
54: from dual;
55:
56: l_end_date date;
57: Begin
58: open c;

Line 156: from dual;

152:
153: -- If Calendars are not setup OR some other problem then return life = 1 month
154: select decode(x_life,null,1,0,1,x_life)
155: into x_life
156: from dual;
157:
158: OPEN GET_RSR;
159: FETCH GET_RSR INTO l_rsr;
160: CLOSE GET_RSR;