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

Line 1508: FROM per_all_assignments_f asg

1504: ,p_c_period_start_date IN date
1505: ,p_c_period_end_date IN date) IS
1506: SELECT asg.assignment_id
1507: , asg.effective_end_date
1508: FROM per_all_assignments_f asg
1509: , per_assignment_status_types ast
1510: WHERE p_c_period_start_date-1 between
1511: asg.effective_start_date and
1512: asg.effective_end_date

Line 1519: FROM per_all_assignments_f asg2,

1515: AND asg.assignment_status_type_id = ast.assignment_status_type_id
1516: AND ast.per_system_status = 'ACTIVE_ASSIGN'
1517: AND NOT EXISTS
1518: (SELECT null
1519: FROM per_all_assignments_f asg2,
1520: per_assignment_status_types ast2
1521: WHERE p_c_period_end_date between
1522: asg2.effective_start_date and
1523: asg2.effective_end_date

Line 2137: FROM per_all_assignments_f asg

2133: ,p_c_period_end_date DATE)
2134: IS
2135: SELECT asg.assignment_id
2136: , asg.effective_start_date
2137: FROM per_all_assignments_f asg
2138: , per_assignment_status_types ast
2139: WHERE ( (p_c_actual_rec.dim2_level_value_name = 'JOB CATEGORY'
2140: AND asg.job_id IN (SELECT jei.job_id
2141: FROM per_job_extra_info jei

Line 2168: FROM per_all_assignments_f asg2

2164: asg.effective_end_date
2165: /* Commented out because of the method in HRMNPSUM used to calc TOTAL
2166: AND EXISTS
2167: (SELECT null
2168: FROM per_all_assignments_f asg2
2169: , per_assignment_status_types ast2
2170: WHERE p_c_period_start_date-1 BETWEEN
2171: asg2.effective_start_date AND
2172: asg2.effective_end_date

Line 2677: FROM per_all_assignments_f a

2673: CURSOR asg_cur (p_vacancy_id IN NUMBER) IS
2674: SELECT a.assignment_id
2675: , a.vacancy_id
2676: , a.effective_start_date
2677: FROM per_all_assignments_f a
2678: WHERE (a.assignment_id, a.effective_start_date) IN
2679: (SELECT b.assignment_id,min(b.effective_start_date)
2680: FROM per_all_assignments_f b
2681: WHERE b.assignment_type = 'E'

Line 2680: FROM per_all_assignments_f b

2676: , a.effective_start_date
2677: FROM per_all_assignments_f a
2678: WHERE (a.assignment_id, a.effective_start_date) IN
2679: (SELECT b.assignment_id,min(b.effective_start_date)
2680: FROM per_all_assignments_f b
2681: WHERE b.assignment_type = 'E'
2682: AND b.vacancy_id = p_vacancy_id
2683: GROUP BY b.assignment_id);
2684: