APPS.PER_ASN_BUS dependencies on PER_ASSESSMENT_TYPES

Line 81: -- ASSESSMENT_TYPE_ID is a foreign key to the table PER_ASSESSMENT_TYPES.

77: -- |------------------------< chk_assessment_type_id >------------------------|
78: -- ----------------------------------------------------------------------------
79: --
80: -- DESCRIPTION
81: -- ASSESSMENT_TYPE_ID is a foreign key to the table PER_ASSESSMENT_TYPES.
82: -- The value can be updated only if there are no rows in
83: -- PER_COMPETENCE_ELEMENTS for the particular assessment ie. if the
84: -- assessment hasn't been filled in at all (no ratings assigned to the
85: -- competences), then the ASSESSMENT_TYPE_ID can be updated.

Line 129: from per_assessment_types

125: where p_assessment_id = assessment_id;
126: --
127: cursor csr_ast_date_from_date_to is
128: select date_from , date_to
129: from per_assessment_types
130: where p_assessment_type_id = assessment_type_id
131: and p_business_group_id = business_group_id;
132: --
133: l_ast_date_from per_assessment_types.date_from%TYPE;

Line 133: l_ast_date_from per_assessment_types.date_from%TYPE;

129: from per_assessment_types
130: where p_assessment_type_id = assessment_type_id
131: and p_business_group_id = business_group_id;
132: --
133: l_ast_date_from per_assessment_types.date_from%TYPE;
134: l_ast_date_to per_assessment_types.date_to%TYPE;
135: --
136: begin
137: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 134: l_ast_date_to per_assessment_types.date_to%TYPE;

130: where p_assessment_type_id = assessment_type_id
131: and p_business_group_id = business_group_id;
132: --
133: l_ast_date_from per_assessment_types.date_from%TYPE;
134: l_ast_date_to per_assessment_types.date_to%TYPE;
135: --
136: begin
137: hr_utility.set_location('Entering:'|| l_proc, 1);
138: hr_utility.set_location('assessment_type_id = '|| p_assessment_type_id,1);