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_VAREN_UTIL dependencies on PN_VAR_TEMPLATES_ALL

Line 1202: FROM pn_var_templates_all

1198: , invg_spread_code
1199: , invg_day_of_month
1200: , invg_days_after
1201: , comments
1202: FROM pn_var_templates_all
1203: --WHERE agreement_template_id = x_agreement_template_id -- Commented by Vivek on 08-Dec-2010 as NULL value is not handled
1204: WHERE agreement_template_id = NVL(x_agreement_template_id,agreement_template_id) -- Added by Vivek on 08-Dec-2010 to handle NULL value
1205: --OR UPPER (agreement_template) = UPPER (x_agreement_template) -- Commented by Vivek on 08-Dec-2010 as NULL value and mutliple rows are not handled
1206: AND UPPER (agreement_template) = UPPER (NVL(x_agreement_template,agreement_template)) -- Added by Vivek on 08-Dec-2010 to handle NULL value and mutliple row cases