APPS.HR_CHANGE_START_DATE_API dependencies on STANDARD

Line 149: AND p_old_start_date BETWEEN NVL(last_standard_process_date,

145: CURSOR csr_inv_new_hd IS
146: SELECT null
147: FROM per_periods_of_service
148: WHERE person_id = p_person_id
149: AND p_old_start_date BETWEEN NVL(last_standard_process_date,
150: actual_termination_date)+1
151: AND final_process_date
152: AND p_new_start_date <= NVL(last_standard_process_date,actual_termination_date);
153: --

Line 152: AND p_new_start_date <= NVL(last_standard_process_date,actual_termination_date);

148: WHERE person_id = p_person_id
149: AND p_old_start_date BETWEEN NVL(last_standard_process_date,
150: actual_termination_date)+1
151: AND final_process_date
152: AND p_new_start_date <= NVL(last_standard_process_date,actual_termination_date);
153: --
154: CURSOR csr_overlap (p_start_date DATE) IS
155: SELECT null
156: FROM per_periods_of_service

Line 158: AND csr_overlap.p_start_date BETWEEN NVL(last_standard_process_date,

154: CURSOR csr_overlap (p_start_date DATE) IS
155: SELECT null
156: FROM per_periods_of_service
157: WHERE person_id = p_person_id
158: AND csr_overlap.p_start_date BETWEEN NVL(last_standard_process_date,
159: actual_termination_date)+1
160: AND NVL(final_process_date,hr_api.g_eot);
161: --
162: l_old_start_date_in_range BOOLEAN;

Line 1882: ,p_last_standard_date => NULL

1878: ,p_new_payroll_id => 1
1879: ,p_business_group_id => l_business_group_id
1880: ,p_operation => 'HIRE_APPL' -- 'ASG_CRITERIA' for bug 5547271
1881: ,p_actual_term_date => NULL
1882: ,p_last_standard_date => NULL
1883: ,p_final_process_date => NULL
1884: ,p_validation_start_date => l_validation_start_date
1885: ,p_validation_end_date => l_validation_end_date
1886: ,p_dt_mode => 'CORRECTION'