APPS.BEN_DETERMINE_COMMUNICATIONS1 dependencies on PER_ALL_ASSIGNMENTS_F

Line 152: FROM per_all_assignments_f asg,

148: )
149: or
150: ppf.person_id in (select asg.person_id
151: -- exists (select 's'
152: FROM per_all_assignments_f asg,
153: per_assignment_status_types ast
154: WHERE
155: -- asg.person_id = ppf.person_id
156: -- AND

Line 172: FROM per_all_assignments_f asg1,

168: AND ((assignment_type = 'E'
169: AND (ast.per_system_status = 'ACTIVE_ASSIGN'
170: OR (ast.per_system_status = 'TERM_ASSIGN'
171: AND NOT EXISTS (SELECT assignment_id
172: FROM per_all_assignments_f asg1,
173: per_assignment_status_types ast1
174: WHERE asg1.assignment_type = 'B'
175: AND asg1.primary_flag = 'Y'
176: AND asg1.person_id = ppf.person_id

Line 188: FROM per_all_assignments_f asg2,

184: )
185: OR
186: (assignment_type = 'B'
187: AND NOT EXISTS (SELECT assignment_id
188: FROM per_all_assignments_f asg2,
189: per_assignment_status_types ast2
190: WHERE asg2.assignment_type = 'E'
191: AND asg2.primary_flag = 'Y'
192: AND asg2.person_id = ppf.person_id

Line 320: FROM per_all_assignments_f asg,

316: )
317: or
318: ppf.person_id in (select asg.person_id
319: -- exists (select 's'
320: FROM per_all_assignments_f asg,
321: per_assignment_status_types ast
322: WHERE
323: -- asg.person_id = ppf.person_id
324: -- AND

Line 340: FROM per_all_assignments_f asg1,

336: AND ((assignment_type = 'E'
337: AND (ast.per_system_status = 'ACTIVE_ASSIGN'
338: OR (ast.per_system_status = 'TERM_ASSIGN'
339: AND NOT EXISTS (SELECT assignment_id
340: FROM per_all_assignments_f asg1,
341: per_assignment_status_types ast1
342: WHERE asg1.assignment_type = 'B'
343: AND asg1.primary_flag = 'Y'
344: AND asg1.person_id = ppf.person_id

Line 356: FROM per_all_assignments_f asg2,

352: )
353: OR
354: (assignment_type = 'B'
355: AND NOT EXISTS (SELECT assignment_id
356: FROM per_all_assignments_f asg2,
357: per_assignment_status_types ast2
358: WHERE asg2.assignment_type = 'E'
359: AND asg2.primary_flag = 'Y'
360: AND asg2.person_id = ppf.person_id