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_TERM_TEMPLATES_ALL

Line 559: FROM pn_term_templates_all term

555: -- The below SQL has been commented and a new SQL has been added by Vivek on 02-DEC-2010
556: /*
557: SELECT term.term_template_id
558: , term.NAME
559: FROM pn_term_templates_all term
560: WHERE active = 'Y'
561: AND ( UPPER (NAME) = UPPER (x_term_template_name)
562: OR term_template_id = x_term_template_id)
563: AND term.term_template_type IN ('NEUTRAL', 'PAYMENT')

Line 569: FROM pn_term_templates_all term

565: */
566: -- New SQL added by Vivek on 02-DEC-2010
567: SELECT term.term_template_id
568: , term.NAME
569: FROM pn_term_templates_all term
570: WHERE active = 'Y'
571: AND ( UPPER (NAME) = UPPER (NVL(x_term_template_name,NAME))
572: AND term_template_id = NVL(x_term_template_id,term_template_id))
573: AND term.term_template_type IN ('NEUTRAL', 'PAYMENT')