APPS.HRENTMNT dependencies on PER_TIME_PERIODS

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

3766: hr_utility.trace ('1');
3767: end if;
3768: --
3769:
3770: select count(*) into v_start_date_check from per_time_periods where payroll_id in(
3771: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
3772: and p_val_start_date_minus_one between effective_start_date and effective_end_date)
3773: and p_val_start_date_minus_one between start_date and end_date;
3774:

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

3771: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
3772: and p_val_start_date_minus_one between effective_start_date and effective_end_date)
3773: and p_val_start_date_minus_one between start_date and end_date;
3774:
3775: select count(*) into v_end_date_check from per_time_periods where payroll_id in(
3776: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
3777: and p_val_end_date_plus_one between effective_start_date and effective_end_date)
3778: and p_val_end_date_plus_one between start_date and end_date;
3779:

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

3792: hr_utility.trace ('3');
3793: end if;
3794: --
3795: if v_start_date_check<>0 or v_end_date_check<>0 then
3796: select end_date into v_vale_start_date from per_time_periods where payroll_id in(
3797: select payroll_id from per_all_assignments_f where assignment_id=p_assignment_id
3798: and v_chng_date between effective_start_date and effective_end_date)
3799: and v_chng_date between start_date and end_date;
3800: end if;