APPS.AMS_ACTMETRIC_PVT dependencies on FND_CURRENCIES

Line 3855: SELECT 1 from FND_CURRENCIES

3851: SELECT 1 from ams_metrics_all_b
3852: WHERE METRIC_ID = p_metric_id;
3853:
3854: CURSOR c_check_currency(p_CURRENCY_CODE varchar2, p_enabled_flag varchar2) IS
3855: SELECT 1 from FND_CURRENCIES
3856: WHERE CURRENCY_CODE = p_CURRENCY_CODE
3857: and enabled_flag = p_enabled_flag;
3858:
3859: BEGIN

Line 3931: l_table_name := 'FND_CURRENCIES';

3927: END IF;
3928:
3929:
3930: /*
3931: l_table_name := 'FND_CURRENCIES';
3932: l_pk_name := 'CURRENCY_CODE';
3933: l_pk_value := l_act_metrics_rec.transaction_currency_code;
3934: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3935: l_additional_where_clause := ' enabled_flag = ''Y''';

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

3952: END IF; -- Check_FK_Exists*/
3953:
3954:
3955:
3956: /*l_table_name := 'FND_CURRENCIES';
3957: l_pk_name := 'CURRENCY_CODE';
3958: l_pk_value := l_act_metrics_rec.functional_currency_code;
3959: l_pk_data_type := Ams_Utility_Pvt.G_VARCHAR2;
3960: l_additional_where_clause := ' enabled_flag = ''Y''';

Line 5634: -- Get currency information from FND_CURRENCIES table

5630: x_mau IN OUT NOCOPY NUMBER,
5631: x_xau IN OUT NOCOPY NUMBER ) IS
5632:
5633: BEGIN
5634: -- Get currency information from FND_CURRENCIES table
5635: SELECT NVL( minimum_accountable_unit, POWER( 10, (-1 * PRECISION))),
5636: POWER( 10, (-1 * EXTENDED_PRECISION))
5637: INTO x_mau, x_xau
5638: FROM FND_CURRENCIES

Line 5638: FROM FND_CURRENCIES

5634: -- Get currency information from FND_CURRENCIES table
5635: SELECT NVL( minimum_accountable_unit, POWER( 10, (-1 * PRECISION))),
5636: POWER( 10, (-1 * EXTENDED_PRECISION))
5637: INTO x_mau, x_xau
5638: FROM FND_CURRENCIES
5639: WHERE currency_code = x_currency;
5640:
5641: EXCEPTION
5642: WHEN NO_DATA_FOUND THEN