APPS.HR_BPL_ALERT_RECIPIENT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 163: ,per_assignment_status_types ast

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
167: AND asg.person_id = asg2.person_id

Line 164: ,per_assignment_status_types ast2

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
167: AND asg.person_id = asg2.person_id
168: AND asg2.primary_flag = 'Y'

Line 326: ,per_assignment_status_types ast

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
330: /* Ensures only current person and assignment used */

Line 471: ,per_assignment_status_types ast

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
475: /* Ensures only current person and assignment used */