APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_OPEN_ASGMT_COMPETENCES_V

Line 11467: FROM PA_OPEN_ASGMT_COMPETENCES_V

11463: -- Given Competence Element id this cursor is used to get the info about that
11464: -- Perticulat competence
11465: CURSOR cur_competence_details(l_competence_element_id NUMBER) IS
11466: SELECT *
11467: FROM PA_OPEN_ASGMT_COMPETENCES_V
11468: WHERE competence_element_id = l_competence_element_id;
11469:
11470: -- For Future developement
11471: /*CURSOR cur_competence_details_alt(l_requirement_id NUMBER, l_competence_id NUMBER ) IS

Line 11473: FROM PA_OPEN_ASGMT_COMPETENCES_V

11469:
11470: -- For Future developement
11471: /*CURSOR cur_competence_details_alt(l_requirement_id NUMBER, l_competence_id NUMBER ) IS
11472: SELECT *
11473: FROM PA_OPEN_ASGMT_COMPETENCES_V
11474: WHERE assignment_id = l_requirement_id
11475: AND competence_id=l_competence_id;*/
11476:
11477:

Line 11493: l_cur_competence_in_rec PA_OPEN_ASGMT_COMPETENCES_V%ROWTYPE;

11489: FROM pa_project_statuses
11490: WHERE project_status_code = l_status_code;
11491:
11492: -- To Hold the values used.
11493: l_cur_competence_in_rec PA_OPEN_ASGMT_COMPETENCES_V%ROWTYPE;
11494:
11495: BEGIN
11496: --Flows which are supported by this API
11497: ------------------------------------------------------

Line 12050: FROM PA_OPEN_ASGMT_COMPETENCES_V

12046: -- Given Competence Element id this cursor is used to get the info about that
12047: -- Perticulat competence
12048: CURSOR cur_competence_details(l_competence_element_id NUMBER) IS
12049: SELECT *
12050: FROM PA_OPEN_ASGMT_COMPETENCES_V
12051: WHERE competence_element_id = l_competence_element_id;
12052:
12053:
12054: -- This cursor is used to get the information like which Requirement

Line 12070: l_cur_competence_in_rec PA_OPEN_ASGMT_COMPETENCES_V%ROWTYPE;

12066: WHERE project_status_code = l_status_code
12067: AND status_type= 'OPEN_ASGMT';
12068:
12069: -- Record type
12070: l_cur_competence_in_rec PA_OPEN_ASGMT_COMPETENCES_V%ROWTYPE;
12071:
12072: BEGIN
12073: -- Flows which are supported by this API
12074: -----------------------------------------