DBA Data[Home] [Help]

APPS.RRS_IMPORT_INTERFACE_PKG dependencies on RRS_LOOKUPS_V

Line 1762: from rrs_lookups_v

1758:
1759: begin
1760: select LOOKUP_CODE
1761: into l_lookup_code
1762: from rrs_lookups_v
1763: where LOOKUP_TYPE = 'RRS_SITE_TYPE'
1764: and LOOKUP_CODE = p_site_type_code;
1765: exception
1766: When no_data_found then

Line 1787: from rrs_lookups_v

1783:
1784: begin
1785: select LOOKUP_CODE
1786: into l_lookup_code
1787: from rrs_lookups_v
1788: where LOOKUP_TYPE = 'RRS_SITE_STATUS'
1789: and LOOKUP_CODE = p_site_status_code;
1790: exception
1791: When no_data_found then

Line 1811: from rrs_lookups_v

1807:
1808: begin
1809: select Lookup_code
1810: into l_lookup_code
1811: from rrs_lookups_v
1812: where lookup_type = 'RRS_BRAND_NAME'
1813: and lookup_code = p_site_brand_code;
1814: exception
1815: when no_data_found then

Line 2086: from rrs_lookups_v

2082:
2083: begin
2084: select LOOKUP_CODE
2085: into l_lookup_code
2086: from rrs_lookups_v
2087: where LOOKUP_TYPE = 'RRS_GEO_SOURCE'
2088: and LOOKUP_CODE = p_geo_source_code;
2089: exception
2090: When no_data_found then