102: ,p_effective_date in date
103: ,p_assignment_id in varchar2)
104: is
105: --
106: l_hr_base_salary_required VARCHAR2(10) := fnd_profile.VALUE('HR_BASE_SALARY_REQUIRED');
107: --
108: l_change_date date := null;
109: l_asst_id number;
110: l_txn_basis number;
5313: ,p_effective_date IN DATE
5314: ,p_transaction_id IN NUMBER)
5315: return NUMBER IS
5316: --
5317: l_fte_profile_value VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');
5318: --
5319: CURSOR csr_fte_BFTE
5320: IS
5321: select nvl(value, 1) val