eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRENTMNT dependencies on PER_TIME_PERIODS

Line 4325: per_time_periods ptp

4321: from dual
4322: where exists
4323: (select null
4324: from pay_element_entries_f pee,
4325: per_time_periods ptp
4326: where pee.assignment_id = p_assignment_id
4327: and pee.entry_type in ('A','R','S')
4328: and pee.effective_start_date > p_val_start_date
4329: and ptp.payroll_id = p_payroll_id

Line 4452: select count(*) into v_start_date_check from per_time_periods where payroll_id in(

4448: if g_debug then
4449: hr_utility.trace ('1');
4450: end if;
4451: --
4452: select count(*) into v_start_date_check from per_time_periods where payroll_id in(
4453: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
4454: and p_val_start_date_minus_one between effective_start_date and effective_end_date)
4455: and p_val_start_date_minus_one between start_date and end_date;
4456:

Line 4457: select count(*) into v_end_date_check from per_time_periods where payroll_id in(

4453: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
4454: and p_val_start_date_minus_one between effective_start_date and effective_end_date)
4455: and p_val_start_date_minus_one between start_date and end_date;
4456:
4457: select count(*) into v_end_date_check from per_time_periods where payroll_id in(
4458: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
4459: and p_val_end_date_plus_one between effective_start_date and effective_end_date)
4460: and p_val_end_date_plus_one between start_date and end_date;
4461:

Line 4478: select end_date into v_vale_start_date from per_time_periods where payroll_id in(

4474: hr_utility.trace ('3');
4475: end if;
4476: --
4477: if v_start_date_check<>0 or v_end_date_check<>0 then
4478: select end_date into v_vale_start_date from per_time_periods where payroll_id in(
4479: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
4480: and v_chng_date between effective_start_date and effective_end_date)
4481: and v_chng_date between start_date and end_date;
4482: end if;

Line 5975: per_time_periods ptp

5971: p_final_process_date date
5972: ) is
5973: select ptp.start_date
5974: from per_assignments_f asg,
5975: per_time_periods ptp
5976: where asg.assignment_id = p_assignment_id
5977: and p_final_process_date
5978: between effective_start_date and asg.effective_end_date
5979: and ptp.payroll_id = asg.payroll_id