APPS.AHL_VWP_VISITS_PUB dependencies on PA_PROJECTS

Line 200: SELECT name FROM pa_projects

196: SELECT unit_config_header_id FROM ahl_unit_config_headers
197: WHERE name = c_uc_name;
198:
199: CURSOR get_proj_template_name_csr(c_proj_template_id IN NUMBER) IS
200: SELECT name FROM pa_projects
201: WHERE project_id = c_proj_template_id
202: AND template_flag = 'Y';
203:
204: BEGIN