APPS.HR_CHANGE_START_DATE_API dependencies on STANDARD

Line 140: AND p_old_start_date BETWEEN NVL(last_standard_process_date,

136: CURSOR csr_inv_new_hd IS
137: SELECT null
138: FROM per_periods_of_service
139: WHERE person_id = p_person_id
140: AND p_old_start_date BETWEEN NVL(last_standard_process_date,
141: actual_termination_date)+1
142: AND final_process_date
143: AND p_new_start_date <= NVL(last_standard_process_date,actual_termination_date);
144: --

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

139: WHERE person_id = p_person_id
140: AND p_old_start_date BETWEEN NVL(last_standard_process_date,
141: actual_termination_date)+1
142: AND final_process_date
143: AND p_new_start_date <= NVL(last_standard_process_date,actual_termination_date);
144: --
145: CURSOR csr_overlap (p_start_date DATE) IS
146: SELECT null
147: FROM per_periods_of_service

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

145: CURSOR csr_overlap (p_start_date DATE) IS
146: SELECT null
147: FROM per_periods_of_service
148: WHERE person_id = p_person_id
149: AND csr_overlap.p_start_date BETWEEN NVL(last_standard_process_date,
150: actual_termination_date)+1
151: AND NVL(final_process_date,hr_api.g_eot);
152: --
153: l_old_start_date_in_range BOOLEAN;

Line 1444: ,p_last_standard_date => NULL

1440: ,p_new_payroll_id => 1
1441: ,p_business_group_id => l_business_group_id
1442: ,p_operation => 'HIRE_APPL' -- 'ASG_CRITERIA' for bug 5547271
1443: ,p_actual_term_date => NULL
1444: ,p_last_standard_date => NULL
1445: ,p_final_process_date => NULL
1446: ,p_validation_start_date => l_validation_start_date
1447: ,p_validation_end_date => l_validation_end_date
1448: ,p_dt_mode => 'CORRECTION'