APPS.BEN_ASSIGNMENT_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 192: per_assignment_status_types ast

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

Line 254: from per_assignment_status_types

250: and effective_end_date;
251: --
252: cursor c_assignment_status_type_id is
253: select null
254: from per_assignment_status_types
255: where assignment_status_type_id = p_assignment_status_type_id
256: and active_flag = 'Y';
257: --
258: -- End of bug 1925131

Line 471: from per_assignment_status_types

467: -- In other words take the default active assignment status.
468: --
469: select assignment_status_type_id
470: into l_assignment_status_type_id
471: from per_assignment_status_types
472: where per_system_status = 'ACTIVE_ASSIGN'
473: and default_flag = 'Y'
474: and business_group_id is null;
475: --