APPS.PN_LEASE_UTILS dependencies on PN_COMPANIES_ALL

Line 1261: FROM pn_companies_all comp

1257: p_lease_role_type VARCHAR2
1258: )
1259: IS
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

Line 1275: FROM pn_companies_all comp

1271: p_lease_role_type VARCHAR2
1272: )
1273: IS
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

Line 1991: select company_id into x_company_id from PN_COMPANIES_ALL where upper(name) = upper(p_company_name) or company_id = x_company_id;

1987: , x_return_status OUT NOCOPY VARCHAR2
1988: )
1989: IS
1990: BEGIN
1991: select company_id into x_company_id from PN_COMPANIES_ALL where upper(name) = upper(p_company_name) or company_id = x_company_id;
1992: x_return_status := fnd_api.g_ret_sts_success;
1993: EXCEPTION
1994: when NO_DATA_FOUND then
1995: x_return_status := fnd_api.g_ret_sts_error;