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_ASSIGNMENT_STATUS_TYPES

Line 1509: , per_assignment_status_types ast

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
1513: AND asg.assignment_type = 'E'

Line 1520: per_assignment_status_types ast2

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
1524: AND asg2.assignment_type = 'E'

Line 2138: , per_assignment_status_types ast

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
2142: WHERE jei.jei_information1 = p_c_actual_rec.dim2_level_value_id)

Line 2169: , per_assignment_status_types ast2

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
2173: AND asg2.assignment_id = asg.assignment_id