APPS.RRS_SITE_INFO dependencies on MTL_PARAMETERS

Line 1303: org_code mtl_parameters.organization_code%TYPE,

1299:
1300: TYPE local_rrs_property_rec is RECORD (
1301: location_name pn_locations_all.location_code%TYPE,
1302: property_name pn_properties_all.property_name%TYPE,
1303: org_code mtl_parameters.organization_code%TYPE,
1304: org_description hr_all_organization_units.name%TYPE
1305: );
1306: TYPE local_rrs_property_tab IS TABLE OF local_rrs_property_rec;
1307: l_property_details local_rrs_property_tab;

Line 1340: MTL_PARAMETERS MP

1336: INTO l_property_details
1337: from
1338: rrs_sites_b site,
1339: HR_ALL_ORGANIZATION_UNITS HAOU,
1340: MTL_PARAMETERS MP
1341: where MP.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
1342: and site.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
1343: and site.site_id = l_site_id;
1344: