DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_TEAM_TEMPLATES

Line 419: FROM pa_team_templates

415: WHERE project_id = c_project_id;
416:
417: CURSOR c_get_team_templ_dtls(c_team_templ_id NUMBER) IS
418: SELECT role_list_id, calendar_id, work_type_id
419: FROM pa_team_templates
420: WHERE team_template_id = c_team_templ_id;
421:
422: CURSOR c_get_role_dtls(c_role_id NUMBER) IS
423: SELECT meaning, default_min_job_level, default_max_job_level, default_job_id

Line 6237: FROM pa_team_templates

6233: WHERE project_id = c_project_id;
6234:
6235: CURSOR c_get_team_templ_dtls(c_team_templ_id NUMBER) IS
6236: SELECT role_list_id, calendar_id, work_type_id
6237: FROM pa_team_templates
6238: WHERE team_template_id = c_team_templ_id;
6239:
6240: CURSOR c_get_role_dtls(c_role_id NUMBER) IS
6241: SELECT meaning