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.PO_APPROVALLIST_S1 dependencies on PER_ASSIGNMENTS_F

Line 584: FROM per_assignments_f pera

580: p_error_stack IN OUT NOCOPY ErrorStackType,
581: p_supervisor_list OUT NOCOPY SupervisorListType) IS
582: CURSOR c_hr_hier(p_employee_id NUMBER, p_business_group_id NUMBER) IS
583: SELECT pera.supervisor_id
584: FROM per_assignments_f pera
585: WHERE trunc(SYSDATE) BETWEEN pera.effective_start_date AND pera.effective_end_date
586: AND pera.person_id = p_employee_id
587: AND pera.primary_flag = 'Y'
588: AND pera.ASSIGNMENT_TYPE IN ('E','C')-- bug 12388225

Line 591: FROM per_people_f PERF, per_assignments_f PERA1

587: AND pera.primary_flag = 'Y'
588: AND pera.ASSIGNMENT_TYPE IN ('E','C')-- bug 12388225
589: AND EXISTS
590: (SELECT '1'
591: FROM per_people_f PERF, per_assignments_f PERA1
592: WHERE trunc(sysdate) BETWEEN PERF.effective_start_date
593: AND PERF.effective_end_date
594: AND PERF.person_id = PERA.supervisor_id
595: AND PERA1.person_id = PERF.person_id

Line 691: /* Bug 2794501. When selecting the records from per_assignments_f only the

687: ** Added condition pera.person_id = p_employee_id to SQL
688: */
689: /* Bug 2605927. Changed the SQL and to construct the list */
690:
691: /* Bug 2794501. When selecting the records from per_assignments_f only the
692: records corresponding to assignment_type 'E' should be selected */
693:
694: CURSOR c_hr_hier(p_employee_id NUMBER, p_business_group_id NUMBER) IS
695: SELECT pera.supervisor_id

Line 696: FROM per_assignments_f pera

692: records corresponding to assignment_type 'E' should be selected */
693:
694: CURSOR c_hr_hier(p_employee_id NUMBER, p_business_group_id NUMBER) IS
695: SELECT pera.supervisor_id
696: FROM per_assignments_f pera
697: WHERE
698: EXISTS
699: (SELECT '1'
700: FROM per_people_f PERF, per_assignments_f PERA1

Line 700: FROM per_people_f PERF, per_assignments_f PERA1

696: FROM per_assignments_f pera
697: WHERE
698: EXISTS
699: (SELECT '1'
700: FROM per_people_f PERF, per_assignments_f PERA1
701: WHERE trunc(sysdate) BETWEEN PERF.effective_start_date
702: AND PERF.effective_end_date
703: AND PERF.person_id = PERA.supervisor_id
704: AND PERA1.person_id = PERF.person_id