DBA Data[Home] [Help]

APPS.PER_SSHR_CHANGE_PAY dependencies on FND_PROFILE

Line 105: l_hr_base_salary_required VARCHAR2(10) := fnd_profile.VALUE('HR_BASE_SALARY_REQUIRED');

101: ,p_effective_date in date
102: ,p_assignment_id in varchar2)
103: is
104: --
105: l_hr_base_salary_required VARCHAR2(10) := fnd_profile.VALUE('HR_BASE_SALARY_REQUIRED');
106: --
107: l_change_date date := null;
108: l_asst_id number;
109: l_txn_basis number;

Line 5179: l_fte_profile_value VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');

5175: ,p_effective_date IN DATE
5176: ,p_transaction_id IN NUMBER)
5177: return NUMBER IS
5178: --
5179: l_fte_profile_value VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');
5180: --
5181: CURSOR csr_fte_BFTE
5182: IS
5183: select nvl(value, 1) val