133: FUNCTION get_in_preferred_currency_num(
134: p_amount IN NUMBER
135: ,p_from_currency IN VARCHAR2
136: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
137: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
138: ) RETURN NUMBER;
139:
140: FUNCTION get_in_preferred_currency_str(
141: p_amount IN NUMBER
140: FUNCTION get_in_preferred_currency_str(
141: p_amount IN NUMBER
142: ,p_from_currency IN VARCHAR2
143: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
144: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
145: ) RETURN VARCHAR2;
146:
147: FUNCTION get_preferred_currency(
148: p_from_currency IN VARCHAR2
146:
147: FUNCTION get_preferred_currency(
148: p_from_currency IN VARCHAR2
149: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
150: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
151: ) RETURN VARCHAR2;
152:
153: FUNCTION get_employee_salary(
154: p_assignment_id IN NUMBER