APPS.OZF_QUOTA_PUB dependencies on FND_PROFILE

Line 644: p_fund_rec.currency_code_tc := fnd_profile.value ('OZF_TP_COMMON_CURRENCY');

640: -- Derived Columns
641: p_fund_rec.start_date_active := l_start_date_active;
642: p_fund_rec.end_date_active := l_end_date_active;
643: p_fund_rec.status_code := l_status_code;
644: p_fund_rec.currency_code_tc := fnd_profile.value ('OZF_TP_COMMON_CURRENCY');
645: --p_fund_rec.created_from := p_method; TODO: Add to Fund record
646: -- TODO: Add DFF attributes to fund record.
647:
648: p_fund_rec.parent_fund_id := p_quota_rec.parent_quota_id;

Line 1004: WHERE period_set_name = fnd_profile.value ('AMS_CAMPAIGN_DEFAULT_CALENDER')

1000:
1001: CURSOR c_from_date (p_period IN VARCHAR2) IS
1002: SELECT start_date
1003: FROM gl_periods_v
1004: WHERE period_set_name = fnd_profile.value ('AMS_CAMPAIGN_DEFAULT_CALENDER')
1005: AND period_name = p_period;
1006:
1007: CURSOR c_to_date (p_period IN VARCHAR2) IS
1008: SELECT end_date

Line 1010: WHERE period_set_name = fnd_profile.value ('AMS_CAMPAIGN_DEFAULT_CALENDER')

1006:
1007: CURSOR c_to_date (p_period IN VARCHAR2) IS
1008: SELECT end_date
1009: FROM gl_periods_v
1010: WHERE period_set_name = fnd_profile.value ('AMS_CAMPAIGN_DEFAULT_CALENDER')
1011: AND period_name = p_period;
1012:
1013: CURSOR c_product_spread (p_quota_id IN NUMBER) IS
1014: SELECT product_spread_time_id