APPS.GHR_PROCESS_SF52 dependencies on PER_ALL_ASSIGNMENTS_F

Line 349: l_new_assignment_id per_all_assignments_f.assignment_id%type;

345: l_shadow_data ghr_pa_request_shadow%rowtype;
346: l_session_var ghr_history_api.g_session_var_type;
347: l_result varchar2(30);
348: l_proc varchar2(30):='dual_action_sf52';
349: l_new_assignment_id per_all_assignments_f.assignment_id%type;
350: l_capped_other_pay number := hr_api.g_number;
351:
352: Begin
353:

Line 3588: FROM per_all_assignments_f

3584: p_prd OUT NOCOPY ghr_pa_requests.pay_rate_determinant%type ) IS
3585:
3586: CURSOR cur_ass_id(c_position_id ghr_pa_requests.to_position_id%type, c_effective_date IN ghr_pa_requests.effective_date%type) IS
3587: SELECT assignment_id, person_id
3588: FROM per_all_assignments_f
3589: WHERE position_id = c_position_id
3590: AND assignment_type <> 'B'
3591: AND primary_flag = 'Y'
3592: AND c_effective_date

Line 3595: l_assignment_id per_all_assignments_f.assignment_id%type;

3591: AND primary_flag = 'Y'
3592: AND c_effective_date
3593: between effective_start_date and effective_end_date;
3594:
3595: l_assignment_id per_all_assignments_f.assignment_id%type;
3596: l_asgei_data per_assignment_extra_info%rowtype;
3597: l_session ghr_history_api.g_session_var_type;
3598:
3599: BEGIN