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.OTA_COMPETENCE_SS dependencies on PER_ALL_ASSIGNMENTS_F

Line 730: FROM per_all_assignments_f paf

726:
727: --added for bug 7308160
728: cursor C_Assignment(p_person_id varchar2) is
729: SELECT paf.ASSIGNMENT_ID
730: FROM per_all_assignments_f paf
731: WHERE paf.person_id = p_person_id
732: AND TRUNC(SYSDATE) BETWEEN paf.effective_start_date AND paf.effective_end_date
733: AND paf.primary_flag ='Y'
734: AND paf.assignment_type in ('E','A', 'C');

Line 1482: FROM per_all_assignments_f paf

1478:
1479: Cursor C_Assignment is
1480: SELECT
1481: paf.ASSIGNMENT_ID
1482: FROM per_all_assignments_f paf
1483: WHERE paf.person_id = p_person_id
1484: AND TRUNC(SYSDATE) BETWEEN
1485: paf.effective_start_date
1486: AND paf.effective_end_date

Line 1494: FROM per_all_assignments_f paf

1490: --added for bug 7308160
1491: Cursor C_Ex_Assignment is
1492: SELECT
1493: paf.ASSIGNMENT_ID
1494: FROM per_all_assignments_f paf
1495: WHERE paf.person_id = p_person_id
1496: AND paf.primary_flag ='Y'
1497: AND paf.assignment_type in ('E','A', 'C')
1498: order by paf.effective_end_date;

Line 1510: FROM per_all_assignments_f asg,

1506:
1507:
1508: CURSOR csr_supervisor_id IS
1509: SELECT asg.supervisor_id, per.full_name
1510: FROM per_all_assignments_f asg,
1511: per_all_people_f per
1512: WHERE asg.person_id = p_person_id
1513: AND per.person_id = asg.supervisor_id
1514: AND asg.primary_flag = 'Y'