APPS.MSD_SR_UTIL dependencies on MSD_SETUP_PARAMETERS

Line 170: from msd_setup_parameters

166: */
167:
168: select to_number(parameter_value)
169: into l_master_org
170: from msd_setup_parameters
171: where parameter_name = 'MSD_MASTER_ORG';
172:
173: select NVL(primary_uom_code,'Ea')
174: into l_master_uom

Line 219: from msd_setup_parameters

215: BEGIN
216:
217: select parameter_value
218: into c_global_currency_code
219: from msd_setup_parameters
220: where parameter_name = 'MSD_CURRENCY_CODE';
221:
222: select parameter_value
223: into c_global_rate_type

Line 224: from msd_setup_parameters

220: where parameter_name = 'MSD_CURRENCY_CODE';
221:
222: select parameter_value
223: into c_global_rate_type
224: from msd_setup_parameters
225: where parameter_name = 'MSD_CONVERSION_TYPE';
226:
227: if (p_curr_code = c_global_currency_code) then
228: l_ret := 1;

Line 1301: (select parameter_value from msd_setup_parameters where parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust

1297: 'attribute15', cust.attribute15, '2')
1298: , '1', nvl(cust.cust_account_id,msd_sr_util.get_null_pk), msd_sr_util.get_null_pk)
1299: from
1300: hz_cust_accounts cust,
1301: (select parameter_value from msd_setup_parameters where parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust
1302: where cust.party_id = p_party_id
1303: order by cust.cust_account_id ASC;
1304:
1305: