APPS.PSP_PREGEN dependencies on PER_PEOPLE_F

Line 1091: FROM Per_People_F a

1087:
1088: /***** Modified the following cursor for R12 performance fixes (bug 4507892)
1089: CURSOR check_person_csr IS
1090: SELECT a.person_id
1091: FROM Per_People_F a
1092: WHERE a.Person_ID = x_person_id
1093: -- AND a.current_employee_flag ='Y' --Added for bug 2624259. Commented for Bug 3424494
1094: AND (x_effective_date BETWEEN a.EFFECTIVE_START_DATE and a.EFFECTIVE_END_DATE)
1095: AND x_effective_date <= ( SELECT max(b.effective_end_date)

Line 1107: FROM per_people_f ppf

1103: End of comment for R12 performance fixes (bug 4507892) *****/
1104: -- New cursor defn. for R12 performance fixes (bug 4507892)
1105: CURSOR check_person_csr IS
1106: SELECT ppf.person_id
1107: FROM per_people_f ppf
1108: WHERE ppf.person_id = x_person_id
1109: AND (x_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date)
1110: AND x_effective_date <= (SELECT MAX(paf.effective_end_date)
1111: FROM per_assignments_f paf,

Line 2476: FROM per_people_f

2472:
2473: /* Following cursor is added for bug 2514611 */
2474: CURSOR employee_name_cur IS
2475: SELECT full_name
2476: FROM per_people_f
2477: WHERE person_id =p_person_id;
2478:
2479: v_return_value varchar2(30);
2480: v_return_Status varchar2(1);