APPS.PN_LEASE_PUB dependencies on PN_LEASES_ALL

Line 5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';

1: PACKAGE BODY pn_lease_pub AS
2: /* $Header: PNLSPUBB.pls 120.4 2011/09/12 08:39:04 acprakas ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_PUB';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_resp_appl_id CONSTANT NUMBER := fnd_global.resp_appl_id;
8: g_resp_id CONSTANT NUMBER := fnd_global.resp_appl_id;
9: g_user_id CONSTANT NUMBER := fnd_global.user_id;

Line 449: FROM pn_leases_all

445: BEGIN
446:
447: SELECT lease_id
448: INTO p_lease_rec.lease_id
449: FROM pn_leases_all
450: WHERE name = p_lease_rec.lease_name
451: AND org_id = g_org_id;
452:
453: EXCEPTION

Line 472: FROM pn_leases_all

468: ELSIF(p_lease_rec.lease_num IS NOT NULL AND p_lease_rec.lease_num <> pn_lease_utils.g_pn_miss_char) THEN
469: BEGIN
470: SELECT lease_id
471: INTO p_lease_rec.lease_id
472: FROM pn_leases_all
473: WHERE lease_num = p_lease_rec.lease_num
474: AND org_id = g_org_id;
475: EXCEPTION
476: WHEN NO_DATA_FOUND THEN