DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_CONVERSION_TYPES_V

Line 6189: FROM pa_conversion_types_v

6185: SELECT 'Y'
6186: INTO l_exists
6187: FROM dual
6188: WHERE EXISTS (SELECT 'X'
6189: FROM pa_conversion_types_v
6190: WHERE ((p_project_cost_rate_type IS NULL
6191: OR p_project_cost_rate_type=conversion_type) OR
6192:
6193: p_project_currency_code IN( p_txn_currency_code

Line 6198: FROM pa_conversion_types_v

6194: ,p_projfunc_currency_code))
6195: AND rownum=1)
6196:
6197: AND EXISTS (SELECT 'X'
6198: FROM pa_conversion_types_v
6199: WHERE ((p_projfunc_cost_rate_type IS NULL
6200: OR p_projfunc_cost_rate_type=conversion_type) OR
6201:
6202: p_projfunc_currency_code = p_txn_currency_code )

Line 6206: FROM pa_conversion_types_v

6202: p_projfunc_currency_code = p_txn_currency_code )
6203: AND rownum=1)
6204:
6205: AND EXISTS (SELECT 'X'
6206: FROM pa_conversion_types_v
6207: WHERE ((p_project_rev_rate_type IS NULL
6208: OR p_project_rev_rate_type=conversion_type) OR
6209:
6210: p_project_currency_code IN( p_txn_currency_code

Line 6215: FROM pa_conversion_types_v

6211: ,p_projfunc_currency_code))
6212: AND rownum=1)
6213:
6214: AND EXISTS (SELECT 'X'
6215: FROM pa_conversion_types_v
6216: WHERE ((p_projfunc_rev_rate_type IS NULL
6217: OR p_projfunc_rev_rate_type=conversion_type) OR
6218:
6219: p_projfunc_currency_code = p_txn_currency_code )