APPS.GHR_VALIDATE_CHECK dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 353: l_asg_extra_info_rec per_assignment_extra_info%rowtype;--Bug# 11776559

349: FROM ghr_pa_requests
350: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
351: --end Bug# 9899054
352:
353: l_asg_extra_info_rec per_assignment_extra_info%rowtype;--Bug# 11776559
354: --Begin Bug# 9898968
355: Cursor c_detail_chk(g_effective_date DATE) is
356: select assignment_extra_info_id
357: from per_assignment_extra_info

Line 357: from per_assignment_extra_info

353: l_asg_extra_info_rec per_assignment_extra_info%rowtype;--Bug# 11776559
354: --Begin Bug# 9898968
355: Cursor c_detail_chk(g_effective_date DATE) is
356: select assignment_extra_info_id
357: from per_assignment_extra_info
358: where assignment_id = p_pa_request_rec.employee_assignment_id
359: and information_type='GHR_US_ASG_DET_INFO'
360: and g_effective_date
361: between fnd_date.canonical_to_date(AEI_INFORMATION1)

Line 453: l_asg_ei_data per_assignment_extra_info%rowtype;

449: ll_bg_id per_all_assignments_f.business_group_id%type;
450:
451: -- End of bug 4016362
452: -- Start of 3563491
453: l_asg_ei_data per_assignment_extra_info%rowtype;
454: l_nte_date_flg BOOLEAN:=FALSE;
455:
456: --
457: CURSOR cur_nte_check(p_asg_id per_assignments_f.assignment_id%TYPE,