eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ASSIGNMENT_UTILS dependencies on PER_COMPETENCES

Line 130: ,p_competence_id IN per_competences.competence_id%TYPE

126: -- BUG: 1904822
127: PROCEDURE Validate_Asgmt_Competency
128: ( p_project_id IN pa_projects_all.project_id%TYPE
129: ,p_assignment_id IN pa_project_assignments.assignment_id%TYPE
130: ,p_competence_id IN per_competences.competence_id%TYPE
131: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
133: l_comp_bg_id NUMBER := 0;
134: l_proj_bg_id NUMBER := 0;

Line 136: SELECT business_group_id FROM per_competences

132: ,x_error_message_code OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
133: l_comp_bg_id NUMBER := 0;
134: l_proj_bg_id NUMBER := 0;
135: CURSOR l_bg_csr IS
136: SELECT business_group_id FROM per_competences
137: WHERE competence_id = p_competence_id;
138:
139: BEGIN
140: pa_debug.init_err_stack ('pa_assignment_utils.Validate_Asgmt_Competency');