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_PAYMENT_WORKSHEET_PVT dependencies on CN_PERIOD_TYPES

Line 161: cn_period_types pt

157: ) IS
158: CURSOR get_max_period_id_in_qtr(p_quarter_num cn_period_statuses.quarter_num%TYPE, p_period_year cn_period_statuses.period_year%TYPE) IS
159: SELECT MAX(p.period_id) max_period_id
160: FROM cn_period_statuses p,
161: cn_period_types pt
162: WHERE p.quarter_num = p_quarter_num
163: AND p.period_year = p_period_year
164: AND p.period_type = pt.period_type
165: AND pt.period_type_id = 0

Line 173: cn_period_types pt

169:
170: CURSOR get_max_period_id_in_yr(p_period_year cn_period_statuses.period_year%TYPE) IS
171: SELECT MAX(p.period_id) max_period_id
172: FROM cn_period_statuses p,
173: cn_period_types pt
174: WHERE period_year = p_period_year
175: AND p.period_type = pt.period_type
176: AND pt.period_type_id = 0
177: --R12