APPS.PSP_PREGEN dependencies on PER_PEOPLE_F

Line 1094: FROM Per_People_F a

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

Line 1110: FROM per_people_f ppf

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

Line 2479: FROM per_people_f

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