APPS.PA_EVENT_PUB dependencies on PA_CONVERSION_TYPES_V

Line 521: FROM pa_conversion_types_v

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

Line 531: FROM pa_conversion_types_v

527: IF p_event_in_rec.p_projfunc_rate_type is not null
528: THEN
529: SELECT conversion_type
530: INTO l_projfunc_bil_rate_type
531: FROM pa_conversion_types_v
532: WHERE user_conversion_type = p_event_in_rec.p_projfunc_rate_type
533: or conversion_type = p_event_in_rec.p_projfunc_rate_type;
534: p_event_in_rec.p_projfunc_rate_type := l_projfunc_bil_rate_type;
535: END IF;

Line 541: FROM pa_conversion_types_v

537: IF p_event_in_rec.p_project_rate_type is not null
538: THEN
539: SELECT conversion_type
540: INTO l_project_bil_rate_type
541: FROM pa_conversion_types_v
542: WHERE user_conversion_type = p_event_in_rec.p_project_rate_type
543: or conversion_type = p_event_in_rec.p_project_rate_type;
544: p_event_in_rec.p_project_rate_type := l_project_bil_rate_type;
545: END IF;

Line 802: FROM pa_conversion_types_v

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

Line 812: FROM pa_conversion_types_v

808: IF p_event_in_rec.p_projfunc_rate_type is not null
809: THEN
810: SELECT conversion_type
811: INTO l_projfunc_bil_rate_type
812: FROM pa_conversion_types_v
813: WHERE user_conversion_type = p_event_in_rec.p_projfunc_rate_type
814: or conversion_type = p_event_in_rec.p_projfunc_rate_type;
815: p_event_in_rec.p_projfunc_rate_type := l_projfunc_bil_rate_type;
816: END IF;

Line 822: FROM pa_conversion_types_v

818: IF p_event_in_rec.p_project_rate_type is not null
819: THEN
820: SELECT conversion_type
821: INTO l_project_bil_rate_type
822: FROM pa_conversion_types_v
823: WHERE user_conversion_type = p_event_in_rec.p_project_rate_type
824: or conversion_type = p_event_in_rec.p_project_rate_type;
825: p_event_in_rec.p_project_rate_type := l_project_bil_rate_type;
826: END IF;

Line 2136: FROM pa_conversion_types_v

2132: IF p_event_in_rec.p_funding_rate_type is not null
2133: THEN
2134: SELECT conversion_type
2135: INTO l_funding_rate_type
2136: FROM pa_conversion_types_v
2137: WHERE user_conversion_type = p_event_in_rec.p_funding_rate_type
2138: or conversion_type = p_event_in_rec.p_funding_rate_type;
2139: p_event_in_rec.p_funding_rate_type := l_funding_rate_type;
2140: END IF;

Line 2146: FROM pa_conversion_types_v

2142: IF p_event_in_rec.p_projfunc_rate_type is not null
2143: THEN
2144: SELECT conversion_type
2145: INTO l_projfunc_bil_rate_type
2146: FROM pa_conversion_types_v
2147: WHERE user_conversion_type = p_event_in_rec.p_projfunc_rate_type
2148: or conversion_type = p_event_in_rec.p_projfunc_rate_type;
2149: p_event_in_rec.p_projfunc_rate_type := l_projfunc_bil_rate_type;
2150: END IF;

Line 2156: FROM pa_conversion_types_v

2152: IF p_event_in_rec.p_project_rate_type is not null
2153: THEN
2154: SELECT conversion_type
2155: INTO l_project_bil_rate_type
2156: FROM pa_conversion_types_v
2157: WHERE user_conversion_type = p_event_in_rec.p_project_rate_type
2158: or conversion_type = p_event_in_rec.p_project_rate_type;
2159: p_event_in_rec.p_project_rate_type := l_project_bil_rate_type;
2160: END IF;