APPS.PA_MULTI_CURRENCY_BILLING dependencies on FND_CURRENCIES

Line 825: FROM FND_CURRENCIES FC

821: SELECT FC.Currency_Code currency_code,
822: FC.Minimum_Accountable_Unit mau,
823: FC.Precision sp,
824: FC.Extended_Precision ep
825: FROM FND_CURRENCIES FC
826: WHERE EXISTS
827: (SELECT null FROM
828: pa_projects_all pr
829: where pr.project_id = p_project_id AND

Line 918: FROM FND_CURRENCIES FC

914: FC.Extended_Precision
915: INTO x_mau,
916: x_sp,
917: x_ep
918: FROM FND_CURRENCIES FC
919: WHERE FC.Currency_Code = p_curr_code;
920:
921: END Get_Trans_Currency_Info;
922:

Line 941: l_mau fnd_currencies.minimum_accountable_unit%TYPE;

937: FUNCTION round_trans_currency_amt ( p_amount IN NUMBER,
938: p_Curr_Code IN VARCHAR2 ) RETURN NUMBER
939: IS
940:
941: l_mau fnd_currencies.minimum_accountable_unit%TYPE;
942: l_sp fnd_currencies.precision%TYPE;
943: l_ep fnd_currencies.extended_precision%TYPE;
944:
945: l_prectab_count NUMBER;

Line 942: l_sp fnd_currencies.precision%TYPE;

938: p_Curr_Code IN VARCHAR2 ) RETURN NUMBER
939: IS
940:
941: l_mau fnd_currencies.minimum_accountable_unit%TYPE;
942: l_sp fnd_currencies.precision%TYPE;
943: l_ep fnd_currencies.extended_precision%TYPE;
944:
945: l_prectab_count NUMBER;
946: l_found_flag VARCHAR2(1):= 'F';

Line 943: l_ep fnd_currencies.extended_precision%TYPE;

939: IS
940:
941: l_mau fnd_currencies.minimum_accountable_unit%TYPE;
942: l_sp fnd_currencies.precision%TYPE;
943: l_ep fnd_currencies.extended_precision%TYPE;
944:
945: l_prectab_count NUMBER;
946: l_found_flag VARCHAR2(1):= 'F';
947:

Line 1388: l_currency_code fnd_currencies.currency_code%TYPE;

1384: FUNCTION Check_update_ou_mcb_flag RETURN VARCHAR2 IS
1385:
1386: lv_return_flag varchar2(1);
1387: /* Added local variable l_currency_code for bug 2872748 */
1388: l_currency_code fnd_currencies.currency_code%TYPE;
1389: BEGIN
1390:
1391: /* Code addition for bug 2872748 starts */
1392: begin