APPS.PN_LEASE_UTILS dependencies on PN_COMPANY_SITES_ALL

Line 1264: FROM pn_company_sites_all csite

1260: SELECT comp.company_id company_id
1261: FROM pn_companies_all comp
1262: WHERE EXISTS (
1263: SELECT 1
1264: FROM pn_company_sites_all csite
1265: WHERE csite.lease_role_type = p_lease_role_type
1266: AND comp.company_id = csite.company_id)
1267: AND comp.company_id = x_company_id
1268: --AND comp.org_id = g_org_id;

Line 1278: FROM pn_company_sites_all csite

1274: SELECT comp.company_id company_id
1275: FROM pn_companies_all comp
1276: WHERE EXISTS (
1277: SELECT 1
1278: FROM pn_company_sites_all csite
1279: WHERE csite.lease_role_type = p_lease_role_type
1280: AND comp.company_id = csite.company_id)
1281: AND comp.NAME = p_company_name
1282: -- AND comp.org_id = g_org_id;

Line 1379: FROM pn_company_sites_all

1375: , x_company_site_id NUMBER
1376: )
1377: IS
1378: SELECT company_site_id
1379: FROM pn_company_sites_all
1380: WHERE company_id = p_company_id
1381: AND company_site_id = x_company_site_id
1382: --AND org_id = g_org_id;
1383: AND org_id = fnd_profile.VALUE('ORG_ID');

Line 1391: FROM pn_company_sites_all

1387: , p_company_site_name VARCHAR2
1388: )
1389: IS
1390: SELECT company_site_id
1391: FROM pn_company_sites_all
1392: WHERE company_id = p_company_id
1393: AND NAME = p_company_site_name
1394: --AND org_id = g_org_id;
1395: AND org_id = fnd_profile.VALUE('ORG_ID');