APPS.PSP_VALID_NON_ORCL_PKG dependencies on PER_ASSIGNMENTS_F

Line 471: from pay_payrolls_f a, per_assignments_f b

467: ELSE
468: /***** Modifed the following SELECT for 11510_CU2 consolidated performance fixes.
469: Select DISTINCT a.payroll_id
470: into v_local_number
471: from pay_payrolls_f a, per_assignments_f b
472: where a.payroll_id = b.payroll_id
473: and a.PAYROLL_ID = v_Payroll_ID
474: and b.assignment_id = v_assignment_id
475: and (v_effective_date between a.effective_start_date and a.effective_end_date)

Line 489: FROM per_assignments_f b

485: AND (v_effective_date between a.effective_start_date and a.effective_end_date)
486: AND a.business_group_id = v_business_group_id
487: AND a.gl_set_of_books_id = v_set_of_books_id
488: AND EXISTS (SELECT 1
489: FROM per_assignments_f b
490: WHERE b.payroll_id = a.payroll_id
491: AND b.assignment_id = v_assignment_id
492: AND v_effective_date BETWEEN b.effective_start_date AND b.effective_end_date);
493: -- End of changes for 11510_CU2 conslodated fixes.

Line 565: from per_assignments_f a ,

561: End If;
562:
563: Select a.assignment_id
564: into v_local_number
565: from per_assignments_f a ,
566: pay_payrolls_f b
567: where a.person_id = v_person_id
568: AND a.assignment_type ='E' --Added for bug 2624259.
569: and a.assignment_id = v_Assignment_ID

Line 599: FROM per_assignments_f b,pay_payrolls_f f

595: WHERE a.Person_ID = v_person_id
596: -- AND a.current_employee_flag ='Y' --Added for bug 2624259. Commented for Bug 3424494
597: AND (v_effective_date BETWEEN a.EFFECTIVE_START_DATE and a.EFFECTIVE_END_DATE)
598: AND v_effective_date <= (SELECT max(b.effective_end_date)
599: FROM per_assignments_f b,pay_payrolls_f f
600: WHERE a.person_id = b.person_id
601: AND b.assignment_type ='E' --Added for bug 2624259.
602: AND b.business_group_id = v_business_group_id
603: AND f.gl_set_of_books_id = v_set_of_books_id

Line 614: FROM per_assignments_f paf,

610: FROM per_people_f ppf
611: WHERE ppf.person_id = v_person_id
612: AND (v_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date)
613: AND v_effective_date <= (SELECT MAX(paf.effective_end_date)
614: FROM per_assignments_f paf,
615: pay_payrolls_f ppf2
616: WHERE paf.person_id = v_person_id
617: AND paf.business_group_id = v_business_group_id
618: AND ppf2.payroll_id = paf.payroll_id

Line 634: from per_assignments_f f,pay_payrolls_f b

630: where a.Person_ID = v_Person_ID
631: and (v_effective_date BETWEEN a.EFFECTIVE_START_DATE and A.EFFECTIVE_END_DATE)
632: and a.business_group_id = v_business_group_id
633: and a.person_id in ( select distinct person_id
634: from per_assignments_f f,pay_payrolls_f b
635: where (v_effective_date between f.effective_start_date and f.effective_end_date)
636: and f.business_group_id = v_business_group_id
637: and b.gl_set_of_books_id = v_set_of_books_id
638: and f.payroll_id = b.payroll_id )

Line 655: from per_assignments_f

651: -- Commented out the foll. lines of code bcos of performance issues. (AL comm.
652: -- the lines on 12/09/98)
653: and a.Person_ID in
654: (select distinct Person_ID
655: from per_assignments_f
656: where (v_Effective_Date between per_assignments_f.effective_start_date
657: and per_assignments_f.effective_end_date));
658: ****************************************************************************/
659: return 0;

Line 656: where (v_Effective_Date between per_assignments_f.effective_start_date

652: -- the lines on 12/09/98)
653: and a.Person_ID in
654: (select distinct Person_ID
655: from per_assignments_f
656: where (v_Effective_Date between per_assignments_f.effective_start_date
657: and per_assignments_f.effective_end_date));
658: ****************************************************************************/
659: return 0;
660: Exception

Line 657: and per_assignments_f.effective_end_date));

653: and a.Person_ID in
654: (select distinct Person_ID
655: from per_assignments_f
656: where (v_Effective_Date between per_assignments_f.effective_start_date
657: and per_assignments_f.effective_end_date));
658: ****************************************************************************/
659: return 0;
660: Exception
661: when no_data_found then