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_ASSIGNMENT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 843: from per_assignment_status_types s

839: into p_first_term_date
840: from per_assignments_f a
841: where a.assignment_id = p_assignment_id
842: and exists ( select null
843: from per_assignment_status_types s
844: where s.assignment_status_type_id
845: = a.assignment_status_type_id
846: and s.per_system_status = 'TERM_ASSIGN');
847: --

Line 898: from per_assignment_status_types s

894: where a.assignment_id = p_assignment_id
895: and a.effective_start_date = p_atd + 1
896: and exists
897: (select null
898: from per_assignment_status_types s
899: where s.assignment_status_type_id
900: = a.assignment_status_type_id
901: and s.per_system_status = 'TERM_ASSIGN');
902: EXCEPTION

Line 1019: from per_assignment_status_types s

1015: where a.assignment_id = p_assignment_id
1016: and a.effective_start_date = p_end_date + 1
1017: and exists
1018: (select null
1019: from per_assignment_status_types s
1020: where s.assignment_status_type_id
1021: = a.assignment_status_type_id
1022: and s.per_system_status = 'TERM_ASSIGN');
1023: EXCEPTION

Line 1116: , per_assignment_status_types s

1112: from sys.dual
1113: where exists
1114: (select null
1115: from per_assignments_f a
1116: , per_assignment_status_types s
1117: where a.assignment_id = p_assignment_id
1118: and a.effective_start_date
1119: > p_effective_start_date
1120: and a.effective_start_date =

Line 1530: from per_assignment_status_types s

1526: into p_first_term_date
1527: from per_assignments_f a
1528: where a.assignment_id = p_assignment_id
1529: and exists ( select null
1530: from per_assignment_status_types s
1531: where s.assignment_status_type_id
1532: = a.assignment_status_type_id
1533: and s.per_system_status = 'TERM_ASSIGN');
1534: --

Line 2226: per_assignment_status_types ast

2222: -------------------------------------
2223: CURSOR get_candidate_primary_ass IS
2224: select to_char(a.assignment_id)
2225: from per_assignments_f a,
2226: per_assignment_status_types ast
2227: where assignment_id <> p_assignment_id
2228: and a.effective_start_date <= p_start_date
2229: and a.effective_end_date >= p_start_date
2230: and a.assignment_status_type_id = ast.assignment_status_type_id

Line 2250: from per_assignment_status_types s

2246: where a3.assignment_id = a.assignment_id
2247: and a3.effective_start_date between p_start_date and p_atd
2248: and exists
2249: (select null
2250: from per_assignment_status_types s
2251: where s.assignment_status_type_id = a3.assignment_status_type_id
2252: and s.per_system_status = 'TERM_ASSIGN'));
2253: --
2254: BEGIN

Line 4152: , per_assignment_status_types s

4148: from sys.dual
4149: where exists
4150: (select null
4151: from per_assignments_f a
4152: , per_assignment_status_types s
4153: where a.assignment_id = p_assignment_id
4154: and a.effective_start_date < p_start_date
4155: and a.assignment_status_type_id = s.assignment_status_type_id
4156: and s.per_system_status = 'TERM_ASSIGN');

Line 4261: , per_assignment_status_types s

4257: begin
4258: select min(a.effective_start_date)
4259: into l_leading_date
4260: from per_assignments_f a
4261: , per_assignment_status_types s
4262: where a.assignment_id = p_assignment_id
4263: and (l_ignore_val_start_date = 'N' or
4264: (l_ignore_val_start_date = 'Y' and
4265: effective_start_date <> p_validation_start_date ))

Line 4409: , per_assignment_status_types s

4405: begin
4406: select min(a.effective_start_date)
4407: into l_new_leading_date
4408: from per_assignments_f a
4409: , per_assignment_status_types s
4410: where a.assignment_id = p_assignment_id
4411: and effective_start_date > p_validation_end_date
4412: and a.assignment_status_type_id = s.assignment_status_type_id
4413: and s.per_system_status = 'TERM_ASSIGN';

Line 4474: from per_assignment_status_types s

4470: from per_assignments_f a
4471: where a.assignment_id = p_assignment_id
4472: and a.effective_start_date between p_sdate and p_edate
4473: and exists ( select null
4474: from per_assignment_status_types s
4475: where s.assignment_status_type_id
4476: = a.assignment_status_type_id
4477: and s.per_system_status = 'TERM_ASSIGN')
4478: and a.effective_start_date + 1 = e.qualifying_date));

Line 5300: PER_ASSIGNMENT_STATUS_TYPES ST ,

5296: PER_GRADES PG ,
5297: PER_JOBS J ,
5298: PER_GRADES_TL GDT ,
5299: PER_JOBS_TL JBT ,
5300: PER_ASSIGNMENT_STATUS_TYPES ST ,
5301: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
5302: PER_ASS_STATUS_TYPE_AMENDS AMD ,
5303: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL ,
5304: PAY_ALL_PAYROLLS_F PAY ,

Line 5301: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,

5297: PER_JOBS J ,
5298: PER_GRADES_TL GDT ,
5299: PER_JOBS_TL JBT ,
5300: PER_ASSIGNMENT_STATUS_TYPES ST ,
5301: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
5302: PER_ASS_STATUS_TYPE_AMENDS AMD ,
5303: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL ,
5304: PAY_ALL_PAYROLLS_F PAY ,
5305: HR_LOCATIONS_ALL_TL LOCTL ,