APPS.PERWSEPY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 460: from per_all_assignments_f asg1

456: -- the change_date
457: --
458: cursor csr_asg_pay_bases is
459: select null
460: from per_all_assignments_f asg1
461: where assignment_id = p_assignment_id
462: and exists (select null
463: from per_all_assignments_f asg2
464: where asg2.assignment_id = p_assignment_id

Line 463: from per_all_assignments_f asg2

459: select null
460: from per_all_assignments_f asg1
461: where assignment_id = p_assignment_id
462: and exists (select null
463: from per_all_assignments_f asg2
464: where asg2.assignment_id = p_assignment_id
465: and asg1.pay_basis_id +0 <> asg2.pay_basis_id
466: and asg2.effective_start_date > p_change_date
467: and asg1.effective_end_date >= p_change_date);

Line 817: from per_all_assignments_f paf

813: ,p_end_ass_date_err OUT NOCOPY BOOLEAN) IS
814:
815: cursor start_ass_date is
816: select 1
817: from per_all_assignments_f paf
818: where paf.assignment_id=p_assignment_id
819: and p_date < (select min(paf2.effective_start_date)
820: from per_all_assignments_f paf2
821: where paf2.assignment_id=p_assignment_id);

Line 820: from per_all_assignments_f paf2

816: select 1
817: from per_all_assignments_f paf
818: where paf.assignment_id=p_assignment_id
819: and p_date < (select min(paf2.effective_start_date)
820: from per_all_assignments_f paf2
821: where paf2.assignment_id=p_assignment_id);
822:
823: cursor end_ass_date is
824: select 1

Line 825: from per_all_assignments_f paf

821: where paf2.assignment_id=p_assignment_id);
822:
823: cursor end_ass_date is
824: select 1
825: from per_all_assignments_f paf
826: where paf.assignment_id=p_assignment_id
827: and p_date > (select max(paf2.effective_end_date)
828: from per_all_assignments_f paf2
829: where paf2.assignment_id=p_assignment_id);

Line 828: from per_all_assignments_f paf2

824: select 1
825: from per_all_assignments_f paf
826: where paf.assignment_id=p_assignment_id
827: and p_date > (select max(paf2.effective_end_date)
828: from per_all_assignments_f paf2
829: where paf2.assignment_id=p_assignment_id);
830: l_dummy NUMBER;
831:
832: begin