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.PN_VAR_CHG_CAL_PKG dependencies on DUAL

Line 257: SELECT pn_var_lines_s.nextval into l_lineitemid from dual;

253: c3_rec.item_category_code = l_last_item_cat_code then
254: NULL;
255: ELSE
256: l_line_num := l_line_num + 1;
257: SELECT pn_var_lines_s.nextval into l_lineitemid from dual;
258:
259: INSERT INTO pn_var_lines_all (
260: line_item_id,
261: line_item_num,

Line 330: SELECT pn_var_bkpts_head_s.nextval into l_bkptheadid from dual;

326: l_last_item_cat_code := c3_rec.item_category_code;
327:
328:
329: FOR c4_rec IN c_old_bkpt_head(c2_rec.period_id) LOOP
330: SELECT pn_var_bkpts_head_s.nextval into l_bkptheadid from dual;
331:
332: INSERT INTO pn_var_bkpts_head_all (
333: bkpt_header_id,
334: last_update_date,

Line 854: FROM DUAL

850: ,ip_bkpt_start_date DATE
851: ,ip_bkpt_end_date DATE) IS
852:
853: SELECT 'x'
854: FROM DUAL
855: WHERE EXISTS( SELECT var_rent_id
856: FROM pn_var_transactions_all
857: WHERE var_rent_id = ip_var_rent_id
858: AND line_item_id = ip_line_item_id

Line 3297: FROM dual

3293: IS
3294:
3295: CURSOR period_exists_cur IS
3296: SELECT 'x' period_exists
3297: FROM dual
3298: WHERE EXISTS ( SELECT period_id
3299: FROM pn_var_periods_all
3300: WHERE var_rent_id = p_var_rent_id);
3301: