Line 535: and p_date_earned between date_start and nvl(actual_termination_date,hr_general.end_of_time)
531: where pps.person_id = paa.person_id
532: and paa.assignment_id = p_assignment_id
533: and pps.business_group_id = p_business_group_id
534: and paa.business_group_id = p_business_group_id 535: and p_date_earned between date_start and nvl(actual_termination_date,hr_general.end_of_time) 536: and p_date_earned between paa.effective_start_date and paa.effective_end_date;
537: --
538: -- Cursor to get_dob
539: --