DBA Data[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on PER_PEOPLE_F

Line 1373: from per_people_f ppf,

1369: /***** Modified the following cursor defn for R12 performance fixes (bug 4507892)
1370: select distinct ppf.full_name,
1371: ppf.employee_number,
1372: pas.assignment_number
1373: from per_people_f ppf,
1374: per_assignments_f pas
1375: where ppf.person_id = l_person_id and
1376: pas.assignment_id = l_assignment_id;
1377: end of comment for bug fix 4507892 *****/

Line 1382: FROM per_people_f ppf,

1378: -- New cursor defn for bug fix 4507892
1379: SELECT DISTINCT ppf.full_name,
1380: ppf.employee_number,
1381: paf.assignment_number
1382: FROM per_people_f ppf,
1383: per_assignments_f paf
1384: WHERE ppf.person_id = l_person_id
1385: AND paf.person_id = ppf.person_id
1386: AND paf.assignment_id = l_assignment_id