APPS.PER_FR_BIAF_REPORT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 602: from hr_assignment_set_amendments hsa

598: and hs.business_group_id=paf.business_group_id
599: and pef.person_id=paf.person_id
600: and paf.business_group_id=l_bg_id
601: and paf.assignment_id in ( select assignment_id
602: from hr_assignment_set_amendments hsa
603: where hsa.assignment_set_id =l_asg_id
604: and hsa.include_or_exclude='I')
605: and p_effective_date between pef.effective_start_date and pef.effective_end_date ;
606:

Line 619: from hr_assignment_set_amendments hsa

615: and nvl(hs.payroll_id,paf.payroll_id)=paf.payroll_id
616: and pef.person_id=paf.person_id
617: and paf.business_group_id=l_bg_id
618: and paf.assignment_id not in ( select assignment_id
619: from hr_assignment_set_amendments hsa
620: where hsa.assignment_set_id =l_asg_id
621: and hsa.include_or_exclude='E')
622: and p_effective_date between pef.effective_start_date and pef.effective_end_date ;
623:

Line 626: from hr_assignment_set_amendments hsa

622: and p_effective_date between pef.effective_start_date and pef.effective_end_date ;
623:
624: cursor c_asg_amendments is
625: select /*count(hsa.include_or_exclude) cnt , */ hsa.include_or_exclude ioe
626: from hr_assignment_set_amendments hsa
627: where hsa.assignment_set_id =p_asg_id;
628: -- group by hsa.include_or_exclude;
629:
630: /*

Line 639: and paf.assignment_id not in ( select assignment_id from hr_assignment_set_amendments hsa

635: and hs.payroll_id is null
636: and hs.business_group_id=paf.business_group_id
637: and pef.person_id=paf.person_id
638: and paf.business_group_id= l_bg_id
639: and paf.assignment_id not in ( select assignment_id from hr_assignment_set_amendments hsa
640: where hsa.assignment_set_id =hs.assignment_set_id
641: and hsa.include_or_exclude='E'
642: )
643: and p_effective_date between pef.effective_start_date and pef.effective_end_date