APPS.PA_FUNDING_CORE dependencies on PA_CONVERSION_TYPES_V

Line 1578: from pa_conversion_types_v

1574: BEGIN
1575:
1576:
1577: SELECT 'Y' INTO l_valid_rate_type
1578: from pa_conversion_types_v
1579: /* WHERE user_conversion_type = p_exchange_rate_type Commented for bug 5478703 */
1580: WHERE conversion_type = p_exchange_rate_type /* Added for bug 5478703 */
1581: AND ( (p_exchange_rate_type = 'User'
1582: AND pa_multi_currency.is_user_rate_type_allowed(

Line 1590: from pa_conversion_types_v

1586: OR p_exchange_rate_type <> 'User');
1587:
1588: /*
1589: SELECT 'Y' INTO l_valid_rate_type
1590: from pa_conversion_types_v
1591: WHERE user_conversion_type = p_exchange_rate_type;
1592: */
1593: IF p_exchange_rate_type = 'User' THEN
1594: IF p_exchange_rate is NULL then

Line 1724: FROM pa_conversion_types_v

1720: IF p_project_rate_type is not null
1721: THEN
1722: SELECT conversion_type
1723: INTO p_project_rate_type
1724: FROM pa_conversion_types_v
1725: WHERE user_conversion_type = p_project_rate_type
1726: or conversion_type = p_project_rate_type;
1727: END IF;
1728:

Line 1733: FROM pa_conversion_types_v

1729: IF p_projfunc_rate_type is not null
1730: THEN
1731: SELECT conversion_type
1732: INTO p_projfunc_rate_type
1733: FROM pa_conversion_types_v
1734: WHERE user_conversion_type = p_projfunc_rate_type
1735: or conversion_type = p_projfunc_rate_type;
1736: END IF;
1737: /* bug 5478703 - Code change Ends here*/