APPS.PER_PYP_BUS dependencies on HR_GENERAL

Line 246: and effective_end_date = hr_general.end_of_time;

242: select null
243: from pay_element_entries_f
244: where assignment_id = p_assignment_id
245: and creator_type = 'SP'
246: and effective_end_date = hr_general.end_of_time;
247: --
248: -- Cursor to get the effective_end_date of the latest salary
249: -- element.
250: --

Line 298: and NVL(pds.final_process_date,hr_general.end_of_time);

294: where asg.assignment_id=p_assignment_id
295: and p_change_date between asg.effective_start_date and asg.effective_end_date
296: and asg.person_id=pds.person_id
297: and p_change_date between pds.date_start
298: and NVL(pds.final_process_date,hr_general.end_of_time);
299:
300: --
301: -- Cursor to check that whether there are any pay_basis changes after
302: -- the change_date

Line 376: if l_effective_end_date = hr_general.end_of_time then

372: hr_utility.set_message(801,'HR_51716_PYP_ELEMNT_ID_INVL');
373: hr_utility.raise_error;
374: else
375: close csr_element_effective_end_date;
376: if l_effective_end_date = hr_general.end_of_time then
377: hr_utility.set_location(l_proc,15);
378: else
379: --
380: -- element has ended for some reason. Check