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 1374: per_assignments_f pas

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

Line 1383: per_assignments_f paf

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
1387: AND l_begin_date between ppf.effective_start_date and ppf.effective_end_date -- Added for Bug 10387328

Line 1407: per_assignments_f paf

1403:
1404: CURSOR assign_org_name_cur IS
1405: SELECT name
1406: FROM hr_all_organization_units haou,
1407: per_assignments_f paf
1408: WHERE haou.organization_id = paf.organization_id
1409: AND paf.assignment_id = l_assignment_id
1410: AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date;
1411: