DBA Data[Home] [Help]

APPS.GHR_VALIDATE_CHECK dependencies on PER_ALL_ASSIGNMENTS_F

Line 449: ll_bg_id per_all_assignments_f.business_group_id%type;

445: where assignment_id = p_assignment_id
446: and p_eff_date between effective_start_date
447: and effective_end_date;
448:
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;

Line 566: from per_all_assignments_f asg

562: AND information_type = 'GHR_US_PAR_BENEFITS';
563:
564: cursor cur_asg_prior_date is
565: Select asg.effective_start_date
566: from per_all_assignments_f asg
567: Where asg.assignment_id = p_pa_request_rec.employee_assignment_id
568: and asg.primary_flag = 'Y'
569: and asg.assignment_type <> 'B'
570: order by asg.effective_start_date;