109: FUNCTION get_in_preferred_currency_num(
110: p_amount IN NUMBER
111: ,p_from_currency IN VARCHAR2
112: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
113: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
114: ) RETURN NUMBER;
115:
116: FUNCTION get_in_preferred_currency_str(
117: p_amount IN NUMBER
116: FUNCTION get_in_preferred_currency_str(
117: p_amount IN NUMBER
118: ,p_from_currency IN VARCHAR2
119: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
120: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
121: ) RETURN VARCHAR2;
122:
123: FUNCTION get_preferred_currency(
124: p_from_currency IN VARCHAR2
122:
123: FUNCTION get_preferred_currency(
124: p_from_currency IN VARCHAR2
125: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
126: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
127: ) RETURN VARCHAR2;
128:
129: FUNCTION get_employee_salary(
130: p_assignment_id IN NUMBER