APPS.PA_CI_TYPE_USAGE_PUB dependencies on PA_PROJECT_TYPES_ALL

Line 45: FROM pa_project_types_all

41: IF p_project_type_id IS NULL THEN
42: BEGIN
43: SELECT project_type_id
44: INTO l_project_type_id
45: FROM pa_project_types_all
46: WHERE project_type like p_project_type
47: AND TRUNC(sysdate) BETWEEN TRUNC(start_date_active)
48: AND TRUNC(NVL(end_date_active, sysdate));
49: EXCEPTION

Line 163: FROM pa_project_types_all

159: IF p_project_type_id IS NULL THEN
160: BEGIN
161: SELECT project_type_id
162: INTO l_project_type_id
163: FROM pa_project_types_all
164: WHERE project_type like p_project_type
165: AND TRUNC(sysdate) BETWEEN TRUNC(start_date_active)
166: AND TRUNC(NVL(end_date_active, sysdate));
167: EXCEPTION

Line 279: FROM pa_project_types_all

275: IF p_project_type_id IS NULL THEN
276: BEGIN
277: SELECT project_type_id
278: INTO l_project_type_id
279: FROM pa_project_types_all
280: WHERE project_type like p_project_type
281: AND TRUNC(sysdate) BETWEEN TRUNC(start_date_active)
282: AND TRUNC(NVL(end_date_active, sysdate));
283: EXCEPTION