DBA Data[Home] [Help]

APPS.PSP_ADJ_DRIVER dependencies on PER_PEOPLE_F

Line 1367: from per_people_f ppf,

1363: /***** Modified the following cursor defn for R12 performance fixes (bug 4507892)
1364: select distinct ppf.full_name,
1365: ppf.employee_number,
1366: pas.assignment_number
1367: from per_people_f ppf,
1368: per_assignments_f pas
1369: where ppf.person_id = l_person_id and
1370: pas.assignment_id = l_assignment_id;
1371: end of comment for bug fix 4507892 *****/

Line 1376: FROM per_people_f ppf,

1372: -- New cursor defn for bug fix 4507892
1373: SELECT DISTINCT ppf.full_name,
1374: ppf.employee_number,
1375: paf.assignment_number
1376: FROM per_people_f ppf,
1377: per_assignments_f paf
1378: WHERE ppf.person_id = l_person_id
1379: AND paf.person_id = ppf.person_id
1380: AND paf.assignment_id = l_assignment_id;