APPS.GHR_PROCESS_SF52 dependencies on PER_ALL_ASSIGNMENTS_F

Line 423: l_new_assignment_id per_all_assignments_f.assignment_id%type;

419: l_shadow_data ghr_pa_request_shadow%rowtype;
420: l_session_var ghr_history_api.g_session_var_type;
421: l_result varchar2(30);
422: l_proc varchar2(30):='dual_action_sf52';
423: l_new_assignment_id per_all_assignments_f.assignment_id%type;
424: l_capped_other_pay number;
425:
426: Begin
427:

Line 3769: FROM per_all_assignments_f

3765: p_prd OUT NOCOPY ghr_pa_requests.pay_rate_determinant%type ) IS
3766:
3767: 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
3768: SELECT assignment_id, person_id
3769: FROM per_all_assignments_f
3770: WHERE position_id = c_position_id
3771: AND assignment_type <> 'B'
3772: AND primary_flag = 'Y'
3773: AND c_effective_date

Line 3776: l_assignment_id per_all_assignments_f.assignment_id%type;

3772: AND primary_flag = 'Y'
3773: AND c_effective_date
3774: between effective_start_date and effective_end_date;
3775:
3776: l_assignment_id per_all_assignments_f.assignment_id%type;
3777: l_asgei_data per_assignment_extra_info%rowtype;
3778: l_session ghr_history_api.g_session_var_type;
3779:
3780: