Line 101: if nvl(g_pilpep_effdt,hr_api.g_sot) = p_effective_date
97: then
98: --
99: -- Check if the passed in effective date matches the cached effective date
100: -- 101: if nvl(g_pilpep_effdt,hr_api.g_sot) = p_effective_date 102: and nvl(g_pilpep_personid,-9999999) = p_person_id
103: then
104: --
105: null;
Line 212: if nvl(g_optpilepo_effdt,hr_api.g_sot) = p_effective_date
208: then
209: --
210: -- Check if the passed in effective date matches the cached effective date
211: -- 212: if nvl(g_optpilepo_effdt,hr_api.g_sot) = p_effective_date 213: and nvl(g_optpilepo_personid,-9999999) = p_person_id
214: then
215: --
216: null;