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

Line 1368: per_assignments_f pas

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 *****/
1372: -- New cursor defn for bug fix 4507892

Line 1377: per_assignments_f paf

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;
1381:

Line 1398: per_assignments_f paf

1394:
1395: CURSOR assign_org_name_cur IS
1396: SELECT name
1397: FROM hr_all_organization_units haou,
1398: per_assignments_f paf
1399: WHERE haou.organization_id = paf.organization_id
1400: AND paf.assignment_id = l_assignment_id
1401: AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date;
1402: