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 813: from per_assignment_status_types s

809: into p_first_term_date
810: from per_assignments_f a
811: where a.assignment_id = p_assignment_id
812: and exists ( select null
813: from per_assignment_status_types s
814: where s.assignment_status_type_id
815: = a.assignment_status_type_id
816: and s.per_system_status = 'TERM_ASSIGN');
817: --

Line 868: from per_assignment_status_types s

864: where a.assignment_id = p_assignment_id
865: and a.effective_start_date = p_atd + 1
866: and exists
867: (select null
868: from per_assignment_status_types s
869: where s.assignment_status_type_id
870: = a.assignment_status_type_id
871: and s.per_system_status = 'TERM_ASSIGN');
872: EXCEPTION

Line 989: from per_assignment_status_types s

985: where a.assignment_id = p_assignment_id
986: and a.effective_start_date = p_end_date + 1
987: and exists
988: (select null
989: from per_assignment_status_types s
990: where s.assignment_status_type_id
991: = a.assignment_status_type_id
992: and s.per_system_status = 'TERM_ASSIGN');
993: EXCEPTION

Line 1086: , per_assignment_status_types s

1082: from sys.dual
1083: where exists
1084: (select null
1085: from per_assignments_f a
1086: , per_assignment_status_types s
1087: where a.assignment_id = p_assignment_id
1088: and a.effective_start_date
1089: > p_effective_start_date
1090: and a.effective_start_date =

Line 1500: from per_assignment_status_types s

1496: into p_first_term_date
1497: from per_assignments_f a
1498: where a.assignment_id = p_assignment_id
1499: and exists ( select null
1500: from per_assignment_status_types s
1501: where s.assignment_status_type_id
1502: = a.assignment_status_type_id
1503: and s.per_system_status = 'TERM_ASSIGN');
1504: --

Line 2189: per_assignment_status_types ast

2185: -------------------------------------
2186: CURSOR get_candidate_primary_ass IS
2187: select to_char(a.assignment_id)
2188: from per_assignments_f a,
2189: per_assignment_status_types ast
2190: where assignment_id <> p_assignment_id
2191: and a.effective_start_date <= p_start_date
2192: and a.effective_end_date >= p_start_date
2193: and a.assignment_status_type_id = ast.assignment_status_type_id

Line 2213: from per_assignment_status_types s

2209: where a3.assignment_id = a.assignment_id
2210: and a3.effective_start_date between p_start_date and p_atd
2211: and exists
2212: (select null
2213: from per_assignment_status_types s
2214: where s.assignment_status_type_id = a3.assignment_status_type_id
2215: and s.per_system_status = 'TERM_ASSIGN'));
2216: --
2217: BEGIN

Line 4112: , per_assignment_status_types s

4108: from sys.dual
4109: where exists
4110: (select null
4111: from per_assignments_f a
4112: , per_assignment_status_types s
4113: where a.assignment_id = p_assignment_id
4114: and a.effective_start_date < p_start_date
4115: and a.assignment_status_type_id = s.assignment_status_type_id
4116: and s.per_system_status = 'TERM_ASSIGN');

Line 4221: , per_assignment_status_types s

4217: begin
4218: select min(a.effective_start_date)
4219: into l_leading_date
4220: from per_assignments_f a
4221: , per_assignment_status_types s
4222: where a.assignment_id = p_assignment_id
4223: and (l_ignore_val_start_date = 'N' or
4224: (l_ignore_val_start_date = 'Y' and
4225: effective_start_date <> p_validation_start_date ))

Line 4369: , per_assignment_status_types s

4365: begin
4366: select min(a.effective_start_date)
4367: into l_new_leading_date
4368: from per_assignments_f a
4369: , per_assignment_status_types s
4370: where a.assignment_id = p_assignment_id
4371: and effective_start_date > p_validation_end_date
4372: and a.assignment_status_type_id = s.assignment_status_type_id
4373: and s.per_system_status = 'TERM_ASSIGN';

Line 4434: from per_assignment_status_types s

4430: from per_assignments_f a
4431: where a.assignment_id = p_assignment_id
4432: and a.effective_start_date between p_sdate and p_edate
4433: and exists ( select null
4434: from per_assignment_status_types s
4435: where s.assignment_status_type_id
4436: = a.assignment_status_type_id
4437: and s.per_system_status = 'TERM_ASSIGN')
4438: and a.effective_start_date + 1 = e.qualifying_date));

Line 5256: PER_ASSIGNMENT_STATUS_TYPES ST ,

5252: PER_GRADES PG ,
5253: PER_JOBS J ,
5254: PER_GRADES_TL GDT ,
5255: PER_JOBS_TL JBT ,
5256: PER_ASSIGNMENT_STATUS_TYPES ST ,
5257: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
5258: PER_ASS_STATUS_TYPE_AMENDS AMD ,
5259: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL ,
5260: PAY_ALL_PAYROLLS_F PAY ,

Line 5257: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,

5253: PER_JOBS J ,
5254: PER_GRADES_TL GDT ,
5255: PER_JOBS_TL JBT ,
5256: PER_ASSIGNMENT_STATUS_TYPES ST ,
5257: PER_ASSIGNMENT_STATUS_TYPES_TL STTL ,
5258: PER_ASS_STATUS_TYPE_AMENDS AMD ,
5259: PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL ,
5260: PAY_ALL_PAYROLLS_F PAY ,
5261: HR_LOCATIONS_ALL_TL LOCTL ,