APPS.PA_EVENT_PUB dependencies on PA_CONVERSION_TYPES_V

Line 501: FROM pa_conversion_types_v

497: IF p_event_in_rec.p_funding_rate_type is not null
498: THEN
499: SELECT conversion_type
500: INTO l_funding_rate_type
501: FROM pa_conversion_types_v
502: WHERE user_conversion_type = p_event_in_rec.p_funding_rate_type
503: or conversion_type = p_event_in_rec.p_funding_rate_type;
504: p_event_in_rec.p_funding_rate_type := l_funding_rate_type;
505: END IF;

Line 511: FROM pa_conversion_types_v

507: IF p_event_in_rec.p_projfunc_rate_type is not null
508: THEN
509: SELECT conversion_type
510: INTO l_projfunc_bil_rate_type
511: FROM pa_conversion_types_v
512: WHERE user_conversion_type = p_event_in_rec.p_projfunc_rate_type
513: or conversion_type = p_event_in_rec.p_projfunc_rate_type;
514: p_event_in_rec.p_projfunc_rate_type := l_projfunc_bil_rate_type;
515: END IF;

Line 521: FROM pa_conversion_types_v

517: IF p_event_in_rec.p_project_rate_type is not null
518: THEN
519: SELECT conversion_type
520: INTO l_project_bil_rate_type
521: FROM pa_conversion_types_v
522: WHERE user_conversion_type = p_event_in_rec.p_project_rate_type
523: or conversion_type = p_event_in_rec.p_project_rate_type;
524: p_event_in_rec.p_project_rate_type := l_project_bil_rate_type;
525: END IF;

Line 782: FROM pa_conversion_types_v

778: /* IF p_event_in_rec.p_funding_rate_type is not null
779: THEN
780: SELECT conversion_type
781: INTO l_funding_rate_type
782: FROM pa_conversion_types_v
783: WHERE user_conversion_type = p_event_in_rec.p_funding_rate_type
784: or conversion_type = p_event_in_rec.p_funding_rate_type;
785: p_event_in_rec.p_funding_rate_type := l_funding_rate_type;
786: END IF;

Line 792: FROM pa_conversion_types_v

788: IF p_event_in_rec.p_projfunc_rate_type is not null
789: THEN
790: SELECT conversion_type
791: INTO l_projfunc_bil_rate_type
792: FROM pa_conversion_types_v
793: WHERE user_conversion_type = p_event_in_rec.p_projfunc_rate_type
794: or conversion_type = p_event_in_rec.p_projfunc_rate_type;
795: p_event_in_rec.p_projfunc_rate_type := l_projfunc_bil_rate_type;
796: END IF;

Line 802: FROM pa_conversion_types_v

798: IF p_event_in_rec.p_project_rate_type is not null
799: THEN
800: SELECT conversion_type
801: INTO l_project_bil_rate_type
802: FROM pa_conversion_types_v
803: WHERE user_conversion_type = p_event_in_rec.p_project_rate_type
804: or conversion_type = p_event_in_rec.p_project_rate_type;
805: p_event_in_rec.p_project_rate_type := l_project_bil_rate_type;
806: END IF;

Line 2109: FROM pa_conversion_types_v

2105: IF p_event_in_rec.p_funding_rate_type is not null
2106: THEN
2107: SELECT conversion_type
2108: INTO l_funding_rate_type
2109: FROM pa_conversion_types_v
2110: WHERE user_conversion_type = p_event_in_rec.p_funding_rate_type
2111: or conversion_type = p_event_in_rec.p_funding_rate_type;
2112: p_event_in_rec.p_funding_rate_type := l_funding_rate_type;
2113: END IF;

Line 2119: FROM pa_conversion_types_v

2115: IF p_event_in_rec.p_projfunc_rate_type is not null
2116: THEN
2117: SELECT conversion_type
2118: INTO l_projfunc_bil_rate_type
2119: FROM pa_conversion_types_v
2120: WHERE user_conversion_type = p_event_in_rec.p_projfunc_rate_type
2121: or conversion_type = p_event_in_rec.p_projfunc_rate_type;
2122: p_event_in_rec.p_projfunc_rate_type := l_projfunc_bil_rate_type;
2123: END IF;

Line 2129: FROM pa_conversion_types_v

2125: IF p_event_in_rec.p_project_rate_type is not null
2126: THEN
2127: SELECT conversion_type
2128: INTO l_project_bil_rate_type
2129: FROM pa_conversion_types_v
2130: WHERE user_conversion_type = p_event_in_rec.p_project_rate_type
2131: or conversion_type = p_event_in_rec.p_project_rate_type;
2132: p_event_in_rec.p_project_rate_type := l_project_bil_rate_type;
2133: END IF;