APPS.PN_LEASE_UTILS dependencies on PN_LEASES_ALL

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

1: PACKAGE BODY PN_LEASE_UTILS AS
2: /* $Header: PNLSUTLB.pls 120.1.12020000.2 2012/10/12 11:11:46 nisinha ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'PN_LEASE_UTILS';
5: g_table_name CONSTANT VARCHAR2 (40) := 'PN_LEASES_ALL';
6: g_tl_table_name CONSTANT VARCHAR2 (40) := 'NONE';
7: g_org_id CONSTANT NUMBER := fnd_profile.VALUE ('ORG_ID');--nvl(PN_MO_CACHE_UTILS.get_current_org_id,fnd_profile.VALUE ('org_id'));
8: --:= fnd_profile.VALUE ('org_id');
9: --PN_MO_CACHE_UTILS.get_current_org_id;--Messages

Line 158: FROM pn_leases_all

154:
155: CURSOR c_lease_name
156: IS
157: SELECT NAME
158: FROM pn_leases_all
159: WHERE NAME = x_lease_name
160: AND org_id = fnd_global.org_id;
161: --AND org_id = g_org_id;
162: BEGIN

Line 546: FROM pn_leases_all

542:
543: CURSOR c_master_lease
544: IS
545: SELECT lease_id
546: FROM pn_leases_all
547: WHERE status = 'F'
548: AND lease_class_code = 'DIRECT'
549: AND ( (p_lease_id IS NULL)
550: OR (lease_id <> p_lease_id))

Line 557: FROM pn_leases_all

553:
554: CURSOR c_master_lease_id
555: IS
556: SELECT lease_id
557: FROM pn_leases_all
558: WHERE status = 'F'
559: AND lease_class_code = 'DIRECT'
560: AND ( (p_lease_id IS NULL)
561: OR (lease_id <> p_lease_id))