DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_CONVERSION_TYPES_V

Line 6195: FROM pa_conversion_types_v

6191: SELECT 'Y'
6192: INTO l_exists
6193: FROM dual
6194: WHERE EXISTS (SELECT 'X'
6195: FROM pa_conversion_types_v
6196: WHERE ((p_project_cost_rate_type IS NULL
6197: OR p_project_cost_rate_type=conversion_type) OR
6198:
6199: p_project_currency_code IN( p_txn_currency_code

Line 6204: FROM pa_conversion_types_v

6200: ,p_projfunc_currency_code))
6201: AND rownum=1)
6202:
6203: AND EXISTS (SELECT 'X'
6204: FROM pa_conversion_types_v
6205: WHERE ((p_projfunc_cost_rate_type IS NULL
6206: OR p_projfunc_cost_rate_type=conversion_type) OR
6207:
6208: p_projfunc_currency_code = p_txn_currency_code )

Line 6212: FROM pa_conversion_types_v

6208: p_projfunc_currency_code = p_txn_currency_code )
6209: AND rownum=1)
6210:
6211: AND EXISTS (SELECT 'X'
6212: FROM pa_conversion_types_v
6213: WHERE ((p_project_rev_rate_type IS NULL
6214: OR p_project_rev_rate_type=conversion_type) OR
6215:
6216: p_project_currency_code IN( p_txn_currency_code

Line 6221: FROM pa_conversion_types_v

6217: ,p_projfunc_currency_code))
6218: AND rownum=1)
6219:
6220: AND EXISTS (SELECT 'X'
6221: FROM pa_conversion_types_v
6222: WHERE ((p_projfunc_rev_rate_type IS NULL
6223: OR p_projfunc_rev_rate_type=conversion_type) OR
6224:
6225: p_projfunc_currency_code = p_txn_currency_code )