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_BPL_ALERT_RECIPIENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 161: ,per_all_assignments_f asg

157: ,psn.full_name
158: ,psn.correspondence_language
159: ,psn.business_group_id
160: FROM per_all_people_f psn
161: ,per_all_assignments_f asg
162: ,per_all_assignments_f asg2
163: ,per_assignment_status_types ast
164: ,per_assignment_status_types ast2
165: WHERE asg.assignment_id = cp_assignment_id

Line 162: ,per_all_assignments_f asg2

158: ,psn.correspondence_language
159: ,psn.business_group_id
160: FROM per_all_people_f psn
161: ,per_all_assignments_f asg
162: ,per_all_assignments_f asg2
163: ,per_assignment_status_types ast
164: ,per_assignment_status_types ast2
165: WHERE asg.assignment_id = cp_assignment_id
166: AND asg.assignment_status_type_id = ast.assignment_status_type_id

Line 196: FROM per_all_assignments_f asg2

192: AND psn.effective_end_date)
193: OR
194: (
195: (NOT EXISTS (SELECT 'X'
196: FROM per_all_assignments_f asg2
197: WHERE asg2.assignment_id = asg.assignment_id
198: AND ((asg2.assignment_type = 'E') OR
199: (asg2.assignment_type = 'C'))
200: AND TRUNC(SYSDATE) BETWEEN asg2.effective_start_date

Line 206: FROM per_all_assignments_f asg3

202: AND
203: (asg.effective_start_date IN
204: (
205: SELECT MIN(asg3.effective_start_date)
206: FROM per_all_assignments_f asg3
207: WHERE asg3.assignment_id = asg.assignment_id
208: AND ((asg3.assignment_type = 'E') OR
209: (asg3.assignment_type = 'C'))
210: AND asg3.effective_start_date > TRUNC(SYSDATE)

Line 325: ,per_all_assignments_f asg

321: ,psn.full_name
322: ,psn.correspondence_language
323: ,psn.business_group_id
324: FROM per_all_people_f psn
325: ,per_all_assignments_f asg
326: ,per_assignment_status_types ast
327: WHERE asg.assignment_id = cp_assignment_id
328: AND asg.supervisor_id = psn.person_id
329: AND asg.assignment_status_type_id = ast.assignment_status_type_id

Line 349: FROM per_all_assignments_f asg2

345: AND psn.effective_end_date)
346: OR
347: (
348: (NOT EXISTS (SELECT 'X'
349: FROM per_all_assignments_f asg2
350: WHERE asg2.assignment_id = asg.assignment_id
351: AND ((asg2.assignment_type = 'E') OR
352: (asg2.assignment_type = 'C'))
353: AND TRUNC(SYSDATE) BETWEEN asg2.effective_start_date

Line 359: FROM per_all_assignments_f asg3

355: AND
356: (asg.effective_start_date IN
357: (
358: SELECT MIN(asg3.effective_start_date)
359: FROM per_all_assignments_f asg3
360: WHERE asg3.assignment_id = asg.assignment_id
361: AND ((asg3.assignment_type = 'E') OR
362: (asg3.assignment_type = 'C'))
363: AND asg3.effective_start_date > TRUNC(SYSDATE)

Line 470: ,per_all_assignments_f asg

466: ,psn.full_name
467: ,psn.correspondence_language
468: ,psn.business_group_id
469: FROM per_all_people_f psn
470: ,per_all_assignments_f asg
471: ,per_assignment_status_types ast
472: WHERE asg.assignment_id = cp_assignment_id
473: AND asg.assignment_status_type_id = ast.assignment_status_type_id
474: AND asg.person_id = psn.person_id

Line 494: FROM per_all_assignments_f asg2

490: AND psn.effective_end_date)
491: OR
492: (
493: (NOT EXISTS (SELECT 'X'
494: FROM per_all_assignments_f asg2
495: WHERE asg2.assignment_id = asg.assignment_id
496: AND ((asg2.assignment_type = 'E') OR
497: (asg2.assignment_type = 'C'))
498: AND TRUNC(SYSDATE) BETWEEN asg2.effective_start_date

Line 504: FROM per_all_assignments_f asg3

500: AND
501: (asg.effective_start_date IN
502: (
503: SELECT MIN(asg3.effective_start_date)
504: FROM per_all_assignments_f asg3
505: WHERE asg3.assignment_id = asg.assignment_id
506: AND ((asg3.assignment_type = 'E') OR
507: (asg3.assignment_type = 'C'))
508: AND asg3.effective_start_date > TRUNC(SYSDATE)

Line 900: ,per_all_assignments_f asg

896: ,psn.full_name
897: ,psn.correspondence_language
898: ,psn.business_group_id
899: FROM per_all_people_f psn
900: ,per_all_assignments_f asg
901: WHERE asg.person_id = cp_person_id
902: AND asg.primary_flag = 'Y'
903: AND asg.supervisor_id = psn.person_id
904: /* Ensures only current person and assignment used */

Line 923: FROM per_all_assignments_f asg2

919: AND psn.effective_end_date)
920: OR
921: (
922: (NOT EXISTS (SELECT 'X'
923: FROM per_all_assignments_f asg2
924: WHERE asg2.assignment_id = asg.assignment_id
925: AND ((asg2.assignment_type = 'E') OR
926: (asg2.assignment_type = 'C'))
927: AND TRUNC(SYSDATE) BETWEEN asg2.effective_start_date

Line 933: FROM per_all_assignments_f asg3

929: AND
930: (asg.effective_start_date IN
931: (
932: SELECT MIN(asg3.effective_start_date)
933: FROM per_all_assignments_f asg3
934: WHERE asg3.assignment_id = asg.assignment_id
935: AND ((asg3.assignment_type = 'E') OR
936: (asg3.assignment_type = 'C'))
937: AND asg3.effective_start_date > TRUNC(SYSDATE)