APPS.AS_SC_DENORM_TRG dependencies on FND_PROFILE

Line 64: and pr.to_currency = FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY')

60: Cursor factor (p_currency IN Varchar2, p_date IN Date) IS
61: Select denominator_rate, numerator_rate, minimum_accountable_unit, conversion_status_flag
62: From as_period_rates pr, as_period_days pd
63: Where pr.from_currency = p_currency
64: and pr.to_currency = FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY')
65: and pr.conversion_type = FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE')
66: and pr.conversion_status_flag = 0
67: and pr.period_name = pd.period_name
68: and pd.period_day = p_date

Line 65: and pr.conversion_type = FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE')

61: Select denominator_rate, numerator_rate, minimum_accountable_unit, conversion_status_flag
62: From as_period_rates pr, as_period_days pd
63: Where pr.from_currency = p_currency
64: and pr.to_currency = FND_PROFILE.VALUE('AS_PREFERRED_CURRENCY')
65: and pr.conversion_type = FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE')
66: and pr.conversion_status_flag = 0
67: and pr.period_name = pd.period_name
68: and pd.period_day = p_date
69: and pd.period_type = FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE')

Line 69: and pd.period_type = FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE')

65: and pr.conversion_type = FND_PROFILE.VALUE('AS_MC_DAILY_CONVERSION_TYPE')
66: and pr.conversion_status_flag = 0
67: and pr.period_name = pd.period_name
68: and pd.period_day = p_date
69: and pd.period_type = FND_PROFILE.VALUE('AS_DEFAULT_PERIOD_TYPE')
70: and rownum <= 1;
71: Begin
72: Begin
73: p_status_flg := 1;

Line 334: ,c1_currency_code = FND_PROFILE.Value('AS_PREFERRED_CURRENCY')

330: ,orig_system_reference = p_new_orig_system_reference
331: ,currency_code = p_new_currency_code
332: ,total_amount = p_new_total_amount
333: ,c1_total_amount = l_total_amount
334: ,c1_currency_code = FND_PROFILE.Value('AS_PREFERRED_CURRENCY')
335: ,customer_category = l_customer_category
336: ,customer_category_code = l_customer_category_code
337: ,org_id = p_new_org_id
338: ,request_id = Null

Line 1111: ,c1_currency_code = FND_PROFILE.Value('AS_PREFERRED_CURRENCY')

1107: ,product_cat_set_id = l_product_cat_set_id
1108: ,currency_code = l_currency_code
1109: ,total_amount = l_lead_total_amount
1110: ,sales_credit_amount = l_sales_credit_amount
1111: ,c1_currency_code = FND_PROFILE.Value('AS_PREFERRED_CURRENCY')
1112: ,c1_total_amount = l_total_amount
1113: ,c1_sales_credit_amount = l_sc_amount
1114: ,won_amount = l_won_amount
1115: ,weighted_amount = l_weighted_amount

Line 1340: ,FND_PROFILE.Value('AS_PREFERRED_CURRENCY')

1336: ,l_product_cat_set_id
1337: ,l_currency_code
1338: ,l_lead_total_amount
1339: ,l_sales_credit_amount
1340: ,FND_PROFILE.Value('AS_PREFERRED_CURRENCY')
1341: ,l_total_amount
1342: ,l_sc_amount
1343: ,l_won_amount
1344: ,l_weighted_amount