APPS.BEN_ASSIGNMENT_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 193: per_assignment_status_types ast

189: )
190: is
191: select null
192: from per_all_assignments_f asg,
193: per_assignment_status_types ast
194: where asg.person_id = c_person_id
195: and asg.assignment_type <> 'C'
196: and asg.assignment_status_type_id = ast.assignment_status_type_id
197: and c_eff_date between asg.effective_start_date

Line 255: from per_assignment_status_types

251: and effective_end_date;
252: --
253: cursor c_assignment_status_type_id is
254: select null
255: from per_assignment_status_types
256: where assignment_status_type_id = p_assignment_status_type_id
257: and active_flag = 'Y';
258:
259: /* Bug 7597322: Added cursor to get the person_type_id on benefits assignment creation date*/

Line 485: from per_assignment_status_types

481: -- In other words take the default active assignment status.
482: --
483: select assignment_status_type_id
484: into l_assignment_status_type_id
485: from per_assignment_status_types
486: where per_system_status = 'ACTIVE_ASSIGN'
487: and default_flag = 'Y'
488: and business_group_id is null;
489: --