DBA Data[Home] [Help]

APPS.PA_FUNDING_CORE dependencies on PA_CONVERSION_TYPES_V

Line 1596: from pa_conversion_types_v

1592: BEGIN
1593:
1594:
1595: SELECT 'Y' INTO l_valid_rate_type
1596: from pa_conversion_types_v
1597: /* WHERE user_conversion_type = p_exchange_rate_type Commented for bug 5478703 */
1598: WHERE conversion_type = p_exchange_rate_type /* Added for bug 5478703 */
1599: AND ( (p_exchange_rate_type = 'User'
1600: AND pa_multi_currency.is_user_rate_type_allowed(

Line 1608: from pa_conversion_types_v

1604: OR p_exchange_rate_type <> 'User');
1605:
1606: /*
1607: SELECT 'Y' INTO l_valid_rate_type
1608: from pa_conversion_types_v
1609: WHERE user_conversion_type = p_exchange_rate_type;
1610: */
1611: IF p_exchange_rate_type = 'User' THEN
1612: IF p_exchange_rate is NULL then

Line 1742: FROM pa_conversion_types_v

1738: IF p_project_rate_type is not null
1739: THEN
1740: SELECT conversion_type
1741: INTO p_project_rate_type
1742: FROM pa_conversion_types_v
1743: WHERE user_conversion_type = p_project_rate_type
1744: or conversion_type = p_project_rate_type;
1745: END IF;
1746:

Line 1751: FROM pa_conversion_types_v

1747: IF p_projfunc_rate_type is not null
1748: THEN
1749: SELECT conversion_type
1750: INTO p_projfunc_rate_type
1751: FROM pa_conversion_types_v
1752: WHERE user_conversion_type = p_projfunc_rate_type
1753: or conversion_type = p_projfunc_rate_type;
1754: END IF;
1755: /* bug 5478703 - Code change Ends here*/