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 163: cn_period_types pt

159: ) IS
160: 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
161: SELECT MAX(p.period_id) max_period_id
162: FROM cn_period_statuses p,
163: cn_period_types pt
164: WHERE p.quarter_num = p_quarter_num
165: AND p.period_year = p_period_year
166: AND p.period_type = pt.period_type
167: AND pt.period_type_id = 0

Line 175: cn_period_types pt

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