APPS.MSC_EXCEPTION_PKG dependencies on FND_PROFILE

Line 93: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1, nvl(mcc.CONV_RATE,0))

89: exception_tbl.exception_count,
90: exception_tbl.exception_value,
91: exception_tbl.exception_value
92: * decode(exception_tbl.currency_code,
93: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'),1, nvl(mcc.CONV_RATE,0))
94: exception_value2,
95: exception_tbl.exception_days,
96: exception_tbl.exception_quantity,
97: exception_tbl.exception_ratio,

Line 594: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')

590: msc_currency_conv_mv mcc,
591: msc_phub_customers_mv mpc,
592: msc_phub_suppliers_mv mps
593: where mcc.from_currency(+) = exception_tbl.currency_code
594: and mcc.to_currency(+) = fnd_profile.value('MSC_HUB_CUR_CODE_RPT')
595: and mcc.calendar_date(+) = exception_tbl.analysis_date
596: and mpc.customer_id(+) = exception_tbl.customer_id
597: and mpc.customer_site_id(+) = exception_tbl.customer_site_id
598: and mpc.region_id = decode(nvl(exception_tbl.customer_id, -23453),

Line 623: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');

619:
620: procedure populate_summary(errbuf out nocopy varchar2, retcode out nocopy varchar2,
621: p_plan_id number, p_plan_run_id number)
622: is
623: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
624: begin
625: -- level 1
626: insert into msc_exceptions_f (
627: plan_id, plan_run_id,