eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_VALID_NON_ORCL_PKG dependencies on PER_PEOPLE_F

Line 594: FROM Per_People_F a

590: Bug 1994421 "Zero Work Days Build" */
591: /***** Modified the following cursor for R12 performance fixes (bug 4507892)
592: CURSOR Valid_person_cur IS
593: SELECT a.person_id
594: FROM Per_People_F a
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)

Line 610: FROM per_people_f ppf

606:
607: -- New cursor definition for R12 performance fix (4507892)
608: CURSOR valid_person_cur IS
609: SELECT ppf.person_id
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,

Line 629: from Per_People_F a

625:
626: /* Commented for bug no 1994421,"Zero Work Days Build"*/
627: /* Select a.person_id
628: into v_local_number
629: from Per_People_F a
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