eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on GL_CURRENCY_API

Line 363: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

359: P_BaseCurrencyCode VARCHAR2,
360: P_ExchangeRateType VARCHAR2
361: ) IS
362: SELECT sum(decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
363: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
364: P_BaseCurrencyCode,
365: sysdate,
366: P_ExchangeRateType,
367: aerl.amount

Line 389: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

385: SELECT SUM(line_amount) AS violation_line_amount
386: FROM
387: (
388: SELECT decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
389: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
390: P_BaseCurrencyCode,
391: sysdate,
392: P_ExchangeRateType,
393: aerl.amount

Line 422: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

418: SELECT sum(violation_amount) as violation_amount,
419: sum(number_of_violations) as number_of_violations
420: FROM
421: ( SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
422: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
423: P_BaseCurrencyCode,
424: sysdate,
425: P_ExchangeRateType,
426: aerv.violation_amount

Line 438: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

434: AND aerv.violation_type NOT IN ( 'RECEIPT_MISSING', 'DAILY_SUM_LIMIT')
435: UNION ALL
436: /* The below query is to fetch the daily sum limit violations for MEALS category */
437: SELECT decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.exceeded_amount,
438: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
439: P_BaseCurrencyCode,
440: SYSDATE,
441: P_ExchangeRateType,
442: apv.exceeded_amount

Line 463: GL_CURRENCY_API.convert_amount_sql( aerv.currency_code,

459: AND aerh.week_end_date BETWEEN P_StartDate AND P_EndDate
460: UNION ALL
461: /* The below query is to bundle up RECEIPT_MISSING violations per line */
462: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
463: GL_CURRENCY_API.convert_amount_sql( aerv.currency_code,
464: P_BaseCurrencyCode,
465: SYSDATE,
466: P_ExchangeRateType,
467: aerv.violation_amount

Line 730: L_ByManagerTab( L_TabIndex ).total_expenses := gl_currency_api.CONVERT_AMOUNT_SQL(

726:
727: -- If amount needs to be converted to user preference currency
728: -- convert the amounts
729: IF ( L_Convert ) THEN
730: L_ByManagerTab( L_TabIndex ).total_expenses := gl_currency_api.CONVERT_AMOUNT_SQL(
731: L_BaseCurrencyCode,
732: P_UserCurrencyCode,
733: sysdate,
734: L_ExchangeRateType,

Line 738: L_ByManagerTab( L_TabIndex ).violation_line_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

734: L_ExchangeRateType,
735: L_ExpenseAmount
736: );
737:
738: L_ByManagerTab( L_TabIndex ).violation_line_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
739: L_BaseCurrencyCode,
740: P_UserCurrencyCode,
741: sysdate,
742: L_ExchangeRateType,

Line 745: L_ByManagerTab( L_TabIndex ).violation_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

741: sysdate,
742: L_ExchangeRateType,
743: L_ViolationLineAmount
744: );
745: L_ByManagerTab( L_TabIndex ).violation_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
746: L_BaseCurrencyCode,
747: P_UserCurrencyCode,
748: sysdate,
749: L_ExchangeRateType,

Line 918: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

914: ) IS
915: SELECT sum(NVL(expense_amount,0)) as expense_amount
916: FROM
917: ( SELECT decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
918: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
919: P_BaseCurrencyCode,
920: sysdate,
921: P_ExchangeRateType,
922: aerl.amount

Line 930: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

926: AND aerl.week_end_date BETWEEN P_StartDate AND P_EndDate
927: AND nvl(aerl.category_code, 'ALL') = decode (P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory)
928: UNION ALL
929: SELECT decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
930: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
931: P_BaseCurrencyCode,
932: sysdate,
933: P_ExchangeRateType,
934: aerl.amount

Line 963: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

959: SELECT SUM(line_amount) AS violation_line_amount
960: FROM
961: (
962: SELECT decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
963: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
964: P_BaseCurrencyCode,
965: sysdate,
966: P_ExchangeRateType,
967: aerl.amount

Line 980: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

976: AND aerl.week_end_date BETWEEN P_StartDate AND P_EndDate
977: AND nvl(aerl.category_code, 'ALL') = decode (P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory)
978: UNION ALL
979: SELECT decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
980: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
981: P_BaseCurrencyCode,
982: sysdate,
983: P_ExchangeRateType,
984: aerl.amount

Line 1020: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1016: sum(nvl(number_of_violations,0)) as number_of_violations
1017: FROM
1018: (
1019: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1020: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1021: P_BaseCurrencyCode,
1022: sysdate,
1023: P_ExchangeRateType,
1024: aerv.violation_amount

Line 1027: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1023: P_ExchangeRateType,
1024: aerv.violation_amount
1025: ))) as violation_amount,
1026: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1027: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1028: P_BaseCurrencyCode,
1029: sysdate,
1030: P_ExchangeRateType,
1031: aerv.allowable_amount

Line 1042: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1038: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)
1039: AND aerv.violation_type NOT IN ( 'RECEIPT_MISSING', 'DAILY_SUM_LIMIT')
1040: UNION ALL
1041: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1042: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1043: P_BaseCurrencyCode,
1044: sysdate,
1045: P_ExchangeRateType,
1046: aerv.violation_amount

Line 1049: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1045: P_ExchangeRateType,
1046: aerv.violation_amount
1047: ))) as violation_amount,
1048: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1049: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1050: P_BaseCurrencyCode,
1051: sysdate,
1052: P_ExchangeRateType,
1053: aerv.allowable_amount

Line 1071: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1067: AND aerv.violation_type NOT IN ( 'RECEIPT_MISSING', 'DAILY_SUM_LIMIT')
1068: UNION ALL
1069: /* The below two queries are to fetch the daily sum limit violations for MEALS category */
1070: SELECT decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.exceeded_amount,
1071: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1072: P_BaseCurrencyCode,
1073: SYSDATE,
1074: P_ExchangeRateType,
1075: apv.exceeded_amount

Line 1078: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1074: P_ExchangeRateType,
1075: apv.exceeded_amount
1076: )) as violation_amount,
1077: decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.allowable_amount,
1078: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1079: P_BaseCurrencyCode,
1080: SYSDATE,
1081: P_ExchangeRateType,
1082: apv.allowable_amount

Line 1103: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1099: AND (aerh.employee_id = P_EmployeeId OR aerh.paid_on_behalf_employee_id = P_EmployeeId)
1100: AND aerh.week_end_date BETWEEN P_StartDate AND P_EndDate
1101: UNION ALL
1102: SELECT decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.exceeded_amount,
1103: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1104: P_BaseCurrencyCode,
1105: SYSDATE,
1106: P_ExchangeRateType,
1107: apv.exceeded_amount

Line 1110: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1106: P_ExchangeRateType,
1107: apv.exceeded_amount
1108: )) as violation_amount,
1109: decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.allowable_amount,
1110: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1111: P_BaseCurrencyCode,
1112: SYSDATE,
1113: P_ExchangeRateType,
1114: apv.allowable_amount

Line 1142: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1138: AND 'MANAGER' = P_QryType
1139: /* The below query is to bundle up RECEIPT_MISSING violations per line */
1140: UNION ALL
1141: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1142: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1143: P_BaseCurrencyCode,
1144: sysdate,
1145: P_ExchangeRateType,
1146: aerv.violation_amount

Line 1149: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1145: P_ExchangeRateType,
1146: aerv.violation_amount
1147: ))) as violation_amount,
1148: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1149: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1150: P_BaseCurrencyCode,
1151: sysdate,
1152: P_ExchangeRateType,
1153: aerv.allowable_amount

Line 1164: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1160: AND ((P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'
1161: group by nvl(aerv.itemization_parent_id, aerv.report_line_id)
1162: UNION ALL
1163: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1164: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1165: P_BaseCurrencyCode,
1166: sysdate,
1167: P_ExchangeRateType,
1168: aerv.violation_amount

Line 1171: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1167: P_ExchangeRateType,
1168: aerv.violation_amount
1169: ))) as violation_amount,
1170: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1171: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1172: P_BaseCurrencyCode,
1173: sysdate,
1174: P_ExchangeRateType,
1175: aerv.allowable_amount

Line 1309: L_ByExpCatTab( L_TabIndex ).total_expenses := gl_currency_api.CONVERT_AMOUNT_SQL(

1305:
1306: -- If amount needs to be converted to user preference currency
1307: -- convert the amounts
1308: IF ( L_Convert ) THEN
1309: L_ByExpCatTab( L_TabIndex ).total_expenses := gl_currency_api.CONVERT_AMOUNT_SQL(
1310: L_BaseCurrencyCode,
1311: P_UserCurrencyCode,
1312: sysdate,
1313: L_ExchangeRateType,

Line 1316: L_ByExpCatTab( L_TabIndex ).violation_line_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

1312: sysdate,
1313: L_ExchangeRateType,
1314: L_ExpenseAmount
1315: );
1316: L_ByExpCatTab( L_TabIndex ).violation_line_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
1317: L_BaseCurrencyCode,
1318: P_UserCurrencyCode,
1319: sysdate,
1320: L_ExchangeRateType,

Line 1323: L_ByExpCatTab( L_TabIndex ).violation_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

1319: sysdate,
1320: L_ExchangeRateType,
1321: L_ViolationLineAmount
1322: );
1323: L_ByExpCatTab( L_TabIndex ).violation_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
1324: L_BaseCurrencyCode,
1325: P_UserCurrencyCode,
1326: sysdate,
1327: L_ExchangeRateType,

Line 1330: L_ByExpCatTab( L_TabIndex ).allowable_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

1326: sysdate,
1327: L_ExchangeRateType,
1328: L_ViolationAmount
1329: );
1330: L_ByExpCatTab( L_TabIndex ).allowable_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
1331: L_BaseCurrencyCode,
1332: P_UserCurrencyCode,
1333: sysdate,
1334: L_ExchangeRateType,

Line 1485: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

1481: SELECT SUM(line_amount) AS violation_line_amount
1482: FROM
1483: (
1484: SELECT decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
1485: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
1486: P_BaseCurrencyCode,
1487: sysdate,
1488: P_ExchangeRateType,
1489: aerl.amount

Line 1502: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,

1498: AND aerl.week_end_date BETWEEN P_StartDate AND P_EndDate
1499: AND nvl(aerl.category_code, 'ALL') = decode (P_ExpenseCategory, 'ALL', nvl(aerl.category_code, 'ALL'), P_ExpenseCategory)
1500: UNION ALL
1501: SELECT decode(aerl.currency_code, P_BaseCurrencyCode, aerl.amount,
1502: gl_currency_api.CONVERT_AMOUNT_SQL( aerl.currency_code,
1503: P_BaseCurrencyCode,
1504: sysdate,
1505: P_ExchangeRateType,
1506: aerl.amount

Line 1543: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1539: sum(nvl(number_of_violations,0)) as number_of_violations
1540: FROM
1541: (
1542: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1543: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1544: P_BaseCurrencyCode,
1545: sysdate,
1546: P_ExchangeRateType,
1547: aerv.violation_amount

Line 1550: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1546: P_ExchangeRateType,
1547: aerv.violation_amount
1548: ))) as violation_amount,
1549: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1550: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1551: P_BaseCurrencyCode,
1552: sysdate,
1553: P_ExchangeRateType,
1554: aerv.allowable_amount

Line 1565: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1561: AND aerv.violation_type = decode(P_ViolationType, 'ALL', aerv.violation_type, P_ViolationType)
1562: AND aerv.violation_type NOT IN ( 'RECEIPT_MISSING', 'DAILY_SUM_LIMIT')
1563: UNION ALL
1564: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1565: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1566: P_BaseCurrencyCode,
1567: sysdate,
1568: P_ExchangeRateType,
1569: aerv.violation_amount

Line 1572: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1568: P_ExchangeRateType,
1569: aerv.violation_amount
1570: ))) as violation_amount,
1571: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1572: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1573: P_BaseCurrencyCode,
1574: sysdate,
1575: P_ExchangeRateType,
1576: aerv.allowable_amount

Line 1594: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1590: AND aerv.violation_type NOT IN ( 'RECEIPT_MISSING', 'DAILY_SUM_LIMIT')
1591: UNION ALL
1592: /* The below two queries are to fetch the daily sum limit violations for MEALS category */
1593: SELECT decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.exceeded_amount,
1594: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1595: P_BaseCurrencyCode,
1596: SYSDATE,
1597: P_ExchangeRateType,
1598: apv.exceeded_amount

Line 1601: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1597: P_ExchangeRateType,
1598: apv.exceeded_amount
1599: )) as violation_amount,
1600: decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.allowable_amount,
1601: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1602: P_BaseCurrencyCode,
1603: SYSDATE,
1604: P_ExchangeRateType,
1605: apv.allowable_amount

Line 1626: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1622: AND (aerh.employee_id = P_EmployeeId OR aerh.paid_on_behalf_employee_id = P_EmployeeId)
1623: AND aerh.week_end_date BETWEEN P_StartDate AND P_EndDate
1624: UNION ALL
1625: SELECT decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.exceeded_amount,
1626: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1627: P_BaseCurrencyCode,
1628: SYSDATE,
1629: P_ExchangeRateType,
1630: apv.exceeded_amount

Line 1633: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,

1629: P_ExchangeRateType,
1630: apv.exceeded_amount
1631: )) as violation_amount,
1632: decode(aerh.default_currency_code, P_BaseCurrencyCode, apv.allowable_amount,
1633: GL_CURRENCY_API.convert_amount_sql( aerh.default_currency_code,
1634: P_BaseCurrencyCode,
1635: SYSDATE,
1636: P_ExchangeRateType,
1637: apv.allowable_amount

Line 1665: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1661: AND 'MANAGER' = P_QryType
1662: /* The below query is to bundle up RECEIPT_MISSING violations per line */
1663: UNION ALL
1664: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1665: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1666: P_BaseCurrencyCode,
1667: sysdate,
1668: P_ExchangeRateType,
1669: aerv.violation_amount

Line 1672: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1668: P_ExchangeRateType,
1669: aerv.violation_amount
1670: ))) as violation_amount,
1671: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1672: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1673: P_BaseCurrencyCode,
1674: sysdate,
1675: P_ExchangeRateType,
1676: aerv.allowable_amount

Line 1687: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1683: AND ((P_ViolationType = 'ALL') or (P_ViolationType = 'RECEIPT_MISSING')) AND aerv.violation_type = 'RECEIPT_MISSING'
1684: group by nvl(aerv.itemization_parent_id, aerv.report_line_id)
1685: UNION ALL
1686: SELECT sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.violation_amount,
1687: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1688: P_BaseCurrencyCode,
1689: sysdate,
1690: P_ExchangeRateType,
1691: aerv.violation_amount

Line 1694: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,

1690: P_ExchangeRateType,
1691: aerv.violation_amount
1692: ))) as violation_amount,
1693: sum(decode(aerv.currency_code, P_BaseCurrencyCode, aerv.allowable_amount,
1694: gl_currency_api.CONVERT_AMOUNT_SQL( aerv.currency_code,
1695: P_BaseCurrencyCode,
1696: sysdate,
1697: P_ExchangeRateType,
1698: aerv.allowable_amount

Line 1813: L_ByViolTypeTab( L_TabIndex ).violation_line_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

1809:
1810: -- If amount needs to be converted to user preference currency
1811: -- convert the amounts
1812: IF ( L_Convert ) THEN
1813: L_ByViolTypeTab( L_TabIndex ).violation_line_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
1814: L_BaseCurrencyCode,
1815: P_UserCurrencyCode,
1816: sysdate,
1817: L_ExchangeRateType,

Line 1820: L_ByViolTypeTab( L_TabIndex ).violation_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

1816: sysdate,
1817: L_ExchangeRateType,
1818: L_ViolationLineAmount
1819: );
1820: L_ByViolTypeTab( L_TabIndex ).violation_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
1821: L_BaseCurrencyCode,
1822: P_UserCurrencyCode,
1823: sysdate,
1824: L_ExchangeRateType,

Line 1827: L_ByViolTypeTab( L_TabIndex ).allowable_amount := gl_currency_api.CONVERT_AMOUNT_SQL(

1823: sysdate,
1824: L_ExchangeRateType,
1825: L_ViolationAmount
1826: );
1827: L_ByViolTypeTab( L_TabIndex ).allowable_amount := gl_currency_api.CONVERT_AMOUNT_SQL(
1828: L_BaseCurrencyCode,
1829: P_UserCurrencyCode,
1830: sysdate,
1831: L_ExchangeRateType,