DBA Data[Home] [Help]

APPS.PA_EVENT_CORE dependencies on PA_CONVERSION_TYPES_V

Line 389: FROM pa_conversion_types_v

385: CURSOR FUND_RATE_TYPE
386: IS
387: -- Commented for bug 3009307 SELECT 1
388: SELECT conversion_type -- Added for bug 3009307
389: FROM pa_conversion_types_v
390: WHERE user_conversion_type = P_fund_rate_type;
391:
392: BEGIN
393:

Line 442: FROM pa_conversion_types_v

438: CURSOR PROJ_RATE_TYPE
439: IS
440: -- Commented for bug 3009307 SELECT 1
441: SELECT conversion_type
442: FROM pa_conversion_types_v
443: WHERE conversion_type <>'User'
444: AND (pa_multi_currency.is_user_rate_type_allowed(
445: p_bill_trans_currency_code,
446: p_project_currency_code,

Line 454: FROM pa_conversion_types_v

450: AND user_conversion_type=P_proj_rate_type
451: UNION ALL
452: -- Commented for bug 3009307 SELECT 1
453: SELECT conversion_type
454: FROM pa_conversion_types_v
455: WHERE pa_multi_currency.is_user_rate_type_allowed(
456: p_bill_trans_currency_code,
457: p_project_currency_code,
458: decode(p_proj_level_rt_dt_cod, 'PA_INVOICE_DATE',

Line 510: FROM pa_conversion_types_v

506: CURSOR PFC_RATE_TYPE
507: IS
508: -- Commented for bug 3009307 SELECT 1
509: SELECT conversion_type
510: FROM pa_conversion_types_v
511: WHERE conversion_type <>'User'
512: AND (pa_multi_currency.is_user_rate_type_allowed(
513: p_bill_trans_currency_code,
514: p_proj_func_currency_code,

Line 522: FROM pa_conversion_types_v

518: AND user_conversion_type=P_pfc_rate_type
519: UNION ALL
520: -- Commented for bug 3009307 SELECT 1
521: SELECT conversion_type
522: FROM pa_conversion_types_v
523: WHERE pa_multi_currency.is_user_rate_type_allowed(
524: p_bill_trans_currency_code,
525: p_proj_func_currency_code,
526: decode(p_proj_level_func_rt_dt_cod,