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 FND_USER

Line 51: , fnd_user fnr

47: , pld.lease_termination_date
48: FROM pn_leases_all pl
49: , pn_tenancies_all pt
50: , pn_lease_details_all pld
51: , fnd_user fnr
52: , fnd_lookups lse_lkp
53: , fnd_lookups flg_lkp
54: , pn_locations_all ploc
55: , pn_properties_all prop

Line 82: , fnd_user fnr

78: , pld.lease_termination_date
79: FROM pn_leases_all pl
80: , pn_tenancies_all pt
81: , pn_lease_details_all pld
82: , fnd_user fnr
83: , fnd_lookups lse_lkp
84: , fnd_lookups flg_lkp
85: , pn_locations_all ploc
86: , pn_properties_all prop

Line 113: , fnd_user fnr

109: , pld.lease_termination_date
110: FROM pn_leases_all pl
111: , pn_tenancies_all pt
112: , pn_lease_details_all pld
113: , fnd_user fnr
114: , fnd_lookups lse_lkp
115: , fnd_lookups flg_lkp
116: , pn_locations_all ploc
117: , pn_properties_all prop

Line 644: FROM fnd_user

640: -- The below SQL has been commented and a new SQL has been added by Vivek on 02-DEC-2010
641: /*
642: SELECT user_id
643: , user_name
644: FROM fnd_user
645: WHERE ( UPPER (user_name) = UPPER (x_user_name)
646: OR user_id = x_user_id)
647: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date
648: , SYSDATE

Line 656: FROM fnd_user

652: */
653: -- New SQL added by Vivek on 02-DEC-2010
654: SELECT user_id
655: , user_name
656: FROM fnd_user
657: WHERE ( UPPER (user_name) = UPPER (NVL(x_user_name,user_name))
658: OR user_id = NVL(x_user_id,user_id))
659: AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date
660: , SYSDATE