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 562: from per_assignments_f a ,

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

Line 596: FROM per_assignments_f b,pay_payrolls_f f

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

Line 611: FROM per_assignments_f paf,

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

Line 631: from per_assignments_f f,pay_payrolls_f b

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

Line 652: from per_assignments_f

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

Line 653: where (v_Effective_Date between per_assignments_f.effective_start_date

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

Line 654: and per_assignments_f.effective_end_date));

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