eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_GET_SRP_DATA_PVT dependencies on CN_PERIOD_STATUSES

Line 188: from cn_period_statuses p1,

184: l_rownum NUMBER := 0;
185:
186: cursor get_fy_start_date is
187: select min(p2.start_date)
188: from cn_period_statuses p1,
189: cn_period_statuses p2
190: where p_date between p1.start_date and p1.end_date
191: and p1.period_year = p2.period_year;
192:

Line 189: cn_period_statuses p2

185:
186: cursor get_fy_start_date is
187: select min(p2.start_date)
188: from cn_period_statuses p1,
189: cn_period_statuses p2
190: where p_date between p1.start_date and p1.end_date
191: and p1.period_year = p2.period_year;
192:
193: cursor get_srp_group_info is