APPS.AMS_ACTMETRIC_PVT dependencies on FND_CURRENCIES

Line 3863: SELECT 1 from FND_CURRENCIES

3859: SELECT 1 from ams_metrics_all_b
3860: WHERE METRIC_ID = p_metric_id;
3861:
3862: CURSOR c_check_currency(p_CURRENCY_CODE varchar2, p_enabled_flag varchar2) IS
3863: SELECT 1 from FND_CURRENCIES
3864: WHERE CURRENCY_CODE = p_CURRENCY_CODE
3865: and enabled_flag = p_enabled_flag;
3866:
3867: BEGIN

Line 3939: l_table_name := 'FND_CURRENCIES';

3935: END IF;
3936:
3937:
3938: /*
3939: l_table_name := 'FND_CURRENCIES';
3940: l_pk_name := 'CURRENCY_CODE';
3941: l_pk_value := l_act_metrics_rec.transaction_currency_code;
3942: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3943: l_additional_where_clause := ' enabled_flag = ''Y''';

Line 3964: /*l_table_name := 'FND_CURRENCIES';

3960: END IF; -- Check_FK_Exists*/
3961:
3962:
3963:
3964: /*l_table_name := 'FND_CURRENCIES';
3965: l_pk_name := 'CURRENCY_CODE';
3966: l_pk_value := l_act_metrics_rec.functional_currency_code;
3967: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3968: l_additional_where_clause := ' enabled_flag = ''Y''';

Line 5642: -- Get currency information from FND_CURRENCIES table

5638: x_mau IN OUT NOCOPY NUMBER,
5639: x_xau IN OUT NOCOPY NUMBER ) IS
5640:
5641: BEGIN
5642: -- Get currency information from FND_CURRENCIES table
5643: SELECT NVL( minimum_accountable_unit, POWER( 10, (-1 * PRECISION))),
5644: POWER( 10, (-1 * EXTENDED_PRECISION))
5645: INTO x_mau, x_xau
5646: FROM FND_CURRENCIES

Line 5646: FROM FND_CURRENCIES

5642: -- Get currency information from FND_CURRENCIES table
5643: SELECT NVL( minimum_accountable_unit, POWER( 10, (-1 * PRECISION))),
5644: POWER( 10, (-1 * EXTENDED_PRECISION))
5645: INTO x_mau, x_xau
5646: FROM FND_CURRENCIES
5647: WHERE currency_code = x_currency;
5648:
5649: EXCEPTION
5650: WHEN NO_DATA_FOUND THEN