APPS.PER_PYP_BUS dependencies on HR_GENERAL

Line 247: and effective_end_date = hr_general.end_of_time;

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

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

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

Line 377: if l_effective_end_date = hr_general.end_of_time then

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