66: WHERE sck.soft_coding_keyflex_id = p_soft_coding_keyflex_id;
67:
68: CURSOR csr_asg_status_type IS
69: SELECT per_system_status
70: FROM per_assignment_status_types
71: WHERE assignment_status_type_id = p_asg_status_type_id;
72:
73: l_ovn NUMBER;
74: l_contribution_code VARCHAR2(60);
71: WHERE assignment_status_type_id = p_asg_status_type_id;
72:
73: l_ovn NUMBER;
74: l_contribution_code VARCHAR2(60);
75: l_system_status per_assignment_status_types.per_system_status%TYPE;
76:
77: BEGIN
78: IF p_assignment_type = 'E' AND p_primary_flag= 'Y' THEN
79: