APPS.PN_LEASE_UTILS dependencies on FND_GLOBAL

Line 160: AND org_id = fnd_global.org_id;

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
163: -- Initialize the return status.
164: x_return_status := fnd_api.g_ret_sts_success;

Line 349: AND loc.org_id = fnd_global.org_id

345: FROM pn_locations_all loc
346: , fnd_lookups lkp
347: WHERE loc.status = 'A'
348: --AND loc.org_id = g_org_id
349: AND loc.org_id = fnd_global.org_id
350: AND loc.location_type_lookup_code = lkp.lookup_code
351: AND loc.location_code = p_location_code
352: AND lkp.lookup_type = 'PN_LOCATION_TYPE'
353: AND ( ( p_lease_class_code <> 'DIRECT'

Line 1296: ----dbms_output.put_line('fnd_global.org_id'||fnd_global.org_id);

1292: INTO x_company_id;
1293: ----dbms_output.put_line('Company ID:'||x_company_id);
1294: ----dbms_output.put_line('PN_MO_CACHE_UTILS.get_current_org_id'||PN_MO_CACHE_UTILS.get_current_org_id);
1295: -------dbms_output.put_line('fnd_profile.VALUE.org_id'||fnd_profile.VALUE('org_id'));
1296: ----dbms_output.put_line('fnd_global.org_id'||fnd_global.org_id);
1297: IF (c_company_name%NOTFOUND)
1298: THEN
1299: /* fnd_message.set_name ('PN', 'PN_INVALID_COMPANY');
1300: fnd_message.set_token ('COMPANY_NAME', p_company_name);