186: PROCEDURE init_term_per_system_status IS
187:
188: CURSOR term_asg_statuses_csr IS
189: SELECT ast.assignment_status_type_id
190: FROM per_assignment_status_types ast
191: WHERE ast.per_system_status = 'TERM_ASSIGN';
192:
193: BEGIN
194:
204: /******************************************************************************/
205: /* Return whether the assignment status type id is terminated */
206: /******************************************************************************/
207: FUNCTION get_inv_flag_status(p_assignment_status_type_id
208: IN per_assignment_status_types.assignment_status_type_id%TYPE)
209: RETURN VARCHAR2 IS
210:
211: BEGIN
212:
234: CURSOR is_a_leaf_csr IS
235: SELECT /*+ index(ast PER_ASSIGNMENT_STATUS_TYPE_PK) use_nl(asg ast) */
236: 'N'
237: FROM per_all_assignments_f asg,
238: per_assignment_status_types ast
239: WHERE asg.supervisor_id = p_person_id
240: AND asg.assignment_type = 'E'
241: AND asg.primary_flag = 'Y'
242: AND ast.assignment_status_type_id = asg.assignment_status_type_id