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_LEASE_UTILS dependencies on PN_LEASE_CHANGES_ALL

Line 2010: FROM pn_lease_changes_all plc1

2006: l_lease_context VARCHAR2(20) := NULL;
2007: BEGIN
2008: SELECT change_type_lookup_code
2009: INTO l_lease_context
2010: FROM pn_lease_changes_all plc1
2011: WHERE lease_change_id = (select max(lease_change_id) from pn_lease_changes_all plc2 where lease_id = p_lease_id and org_id = p_org_id);
2012:
2013: RETURN l_lease_context;
2014: EXCEPTION

Line 2011: WHERE lease_change_id = (select max(lease_change_id) from pn_lease_changes_all plc2 where lease_id = p_lease_id and org_id = p_org_id);

2007: BEGIN
2008: SELECT change_type_lookup_code
2009: INTO l_lease_context
2010: FROM pn_lease_changes_all plc1
2011: WHERE lease_change_id = (select max(lease_change_id) from pn_lease_changes_all plc2 where lease_id = p_lease_id and org_id = p_org_id);
2012:
2013: RETURN l_lease_context;
2014: EXCEPTION
2015: WHEN OTHERS THEN

Line 2029: FROM pn_lease_changes_all

2025: BEGIN
2026:
2027: SELECT max(lease_change_id)
2028: INTO l_lease_change_id
2029: FROM pn_lease_changes_all
2030: WHERE lease_id = p_lease_id
2031: AND org_id = p_org_id;
2032:
2033: RETURN l_lease_change_id;