APPS.PA_BILLING_PUB dependencies on PA_CONVERSION_TYPES_V

Line 1013: FROM pa_conversion_types_v

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

Line 1023: FROM pa_conversion_types_v

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

Line 1075: FROM pa_conversion_types_v

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

Line 1085: FROM pa_conversion_types_v

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

Line 1135: FROM pa_conversion_types_v)

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

Line 1852: FROM pa_conversion_types_v

1848: BEGIN
1849: SELECT 'found'
1850: INTO l_found
1851: FROM ( SELECT conversion_type, user_conversion_type
1852: FROM pa_conversion_types_v
1853: WHERE conversion_type <>'User'
1854: AND (pa_multi_currency.is_user_rate_type_allowed(
1855: l_txn_currency_code,
1856: l_projfunc_currency_code,

Line 1862: FROM pa_conversion_types_v

1858: 'PA_INVOICE_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date),
1859: 'FIXED_DATE', NVL(X_project_func_rate_date,l_projfunc_bil_rate_date)))= 'N')
1860: UNION
1861: SELECT conversion_type, user_conversion_type
1862: FROM pa_conversion_types_v
1863: WHERE pa_multi_currency.is_user_rate_type_allowed(
1864: l_txn_currency_code,
1865: l_projfunc_currency_code,
1866: DECODE(l_projfunc_bil_rate_date_code,

Line 1914: FROM pa_conversion_types_v

1910: BEGIN
1911: SELECT 'found'
1912: INTO l_found
1913: FROM ( SELECT conversion_type, user_conversion_type
1914: FROM pa_conversion_types_v
1915: WHERE conversion_type <>'User'
1916: AND (pa_multi_currency.is_user_rate_type_allowed(
1917: l_txn_currency_code,
1918: l_project_currency_code,

Line 1924: FROM pa_conversion_types_v

1920: 'PA_INVOICE_DATE', NVL(X_project_rate_date,l_project_bil_rate_date),
1921: 'FIXED_DATE', NVL(X_project_rate_date,l_project_bil_rate_date)))= 'N')
1922: UNION
1923: SELECT conversion_type, user_conversion_type
1924: FROM pa_conversion_types_v
1925: WHERE pa_multi_currency.is_user_rate_type_allowed(
1926: l_txn_currency_code,
1927: l_project_currency_code,
1928: DECODE(l_project_bil_rate_date_code,

Line 1974: FROM pa_conversion_types_v)

1970: BEGIN
1971: SELECT 'found'
1972: INTO l_found
1973: FROM ( SELECT conversion_type, user_conversion_type
1974: FROM pa_conversion_types_v)
1975: WHERE DECODE(conversion_type,X_funding_rate_type,'Y','N') = 'Y';
1976: EXCEPTION
1977: WHEN NO_DATA_FOUND THEN
1978: RAISE l_fund_invalid_rate_type;