APPS.PA_BILLING_PUB dependencies on PA_CONVERSION_TYPES_V

Line 1012: FROM pa_conversion_types_v

1008: BEGIN
1009: SELECT 'found'
1010: INTO l_found
1011: FROM ( SELECT conversion_type, user_conversion_type
1012: FROM pa_conversion_types_v
1013: WHERE conversion_type <>'User'
1014: AND (pa_multi_currency.is_user_rate_type_allowed(
1015: l_txn_currency_code,
1016: l_projfunc_currency_code,

Line 1022: FROM pa_conversion_types_v

1018: 'PA_INVOICE_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),
1019: 'FIXED_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date)))= 'N')
1020: UNION
1021: SELECT conversion_type, user_conversion_type
1022: FROM pa_conversion_types_v
1023: WHERE pa_multi_currency.is_user_rate_type_allowed(
1024: l_txn_currency_code,
1025: l_projfunc_currency_code,
1026: DECODE(l_projfunc_bil_rate_date_code,

Line 1074: FROM pa_conversion_types_v

1070: BEGIN
1071: SELECT 'found'
1072: INTO l_found
1073: FROM ( SELECT conversion_type, user_conversion_type
1074: FROM pa_conversion_types_v
1075: WHERE conversion_type <>'User'
1076: AND (pa_multi_currency.is_user_rate_type_allowed(
1077: l_txn_currency_code,
1078: l_project_currency_code,

Line 1084: FROM pa_conversion_types_v

1080: 'PA_INVOICE_DATE', NVL(X_project_rate_date,l_project_bil_rate_date),
1081: 'FIXED_DATE', NVL(X_project_rate_date,l_project_bil_rate_date)))= 'N')
1082: UNION
1083: SELECT conversion_type, user_conversion_type
1084: FROM pa_conversion_types_v
1085: WHERE pa_multi_currency.is_user_rate_type_allowed(
1086: l_txn_currency_code,
1087: l_project_currency_code,
1088: DECODE(l_project_bil_rate_date_code,

Line 1134: FROM pa_conversion_types_v)

1130: BEGIN
1131: SELECT 'found'
1132: INTO l_found
1133: FROM ( SELECT conversion_type, user_conversion_type
1134: FROM pa_conversion_types_v)
1135: WHERE DECODE(conversion_type,X_funding_rate_type,'Y','N') = 'Y';
1136: EXCEPTION
1137: WHEN NO_DATA_FOUND THEN
1138: RAISE l_fund_invalid_rate_type;