APPS.PA_MULTI_CURRENCY_BILLING dependencies on FND_CURRENCIES

Line 832: FROM FND_CURRENCIES FC

828: SELECT FC.Currency_Code currency_code,
829: FC.Minimum_Accountable_Unit mau,
830: FC.Precision sp,
831: FC.Extended_Precision ep
832: FROM FND_CURRENCIES FC
833: WHERE EXISTS
834: (SELECT null FROM
835: pa_projects_all pr
836: where pr.project_id = p_project_id AND

Line 925: FROM FND_CURRENCIES FC

921: FC.Extended_Precision
922: INTO x_mau,
923: x_sp,
924: x_ep
925: FROM FND_CURRENCIES FC
926: WHERE FC.Currency_Code = p_curr_code;
927:
928: END Get_Trans_Currency_Info;
929:

Line 948: l_mau fnd_currencies.minimum_accountable_unit%TYPE;

944: FUNCTION round_trans_currency_amt ( p_amount IN NUMBER,
945: p_Curr_Code IN VARCHAR2 ) RETURN NUMBER
946: IS
947:
948: l_mau fnd_currencies.minimum_accountable_unit%TYPE;
949: l_sp fnd_currencies.precision%TYPE;
950: l_ep fnd_currencies.extended_precision%TYPE;
951:
952: l_prectab_count NUMBER;

Line 949: l_sp fnd_currencies.precision%TYPE;

945: p_Curr_Code IN VARCHAR2 ) RETURN NUMBER
946: IS
947:
948: l_mau fnd_currencies.minimum_accountable_unit%TYPE;
949: l_sp fnd_currencies.precision%TYPE;
950: l_ep fnd_currencies.extended_precision%TYPE;
951:
952: l_prectab_count NUMBER;
953: l_found_flag VARCHAR2(1):= 'F';

Line 950: l_ep fnd_currencies.extended_precision%TYPE;

946: IS
947:
948: l_mau fnd_currencies.minimum_accountable_unit%TYPE;
949: l_sp fnd_currencies.precision%TYPE;
950: l_ep fnd_currencies.extended_precision%TYPE;
951:
952: l_prectab_count NUMBER;
953: l_found_flag VARCHAR2(1):= 'F';
954:

Line 1395: l_currency_code fnd_currencies.currency_code%TYPE;

1391: FUNCTION Check_update_ou_mcb_flag RETURN VARCHAR2 IS
1392:
1393: lv_return_flag varchar2(1);
1394: /* Added local variable l_currency_code for bug 2872748 */
1395: l_currency_code fnd_currencies.currency_code%TYPE;
1396: BEGIN
1397:
1398: /* Code addition for bug 2872748 starts */
1399: begin