APPS.PER_ES_SS_REP_DYN_TRG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 70: FROM per_assignment_status_types

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);

Line 75: l_system_status per_assignment_status_types.per_system_status%TYPE;

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: