APPS.PA_TASKS_MAINT_UTILS dependencies on PA_LOOKUPS

Line 1296: ,PA_LOOKUPS PL

1292: ,PL.MEANING SERVICE_TYPE_NAME
1293: FROM PA_TASKS PT
1294: ,HR_ORGANIZATION_UNITS HOU
1295: ,PA_WORK_TYPES_TL PWT
1296: ,PA_LOOKUPS PL
1297: WHERE PT.TASK_ID = p_task_id
1298: AND PT.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1299: AND PT.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
1300: AND userenv('lang') = PWT.language(+)

Line 1426: ,PA_LOOKUPS PL

1422: ,PL.MEANING SERVICE_TYPE_NAME
1423: FROM PA_PROJECTS_ALL PPA
1424: ,HR_ORGANIZATION_UNITS HOU
1425: ,PA_WORK_TYPES_TL PWT
1426: ,PA_LOOKUPS PL
1427: ,PA_PROJECT_TYPES_ALL PPT
1428: WHERE PPA.PROJECT_ID = p_project_id
1429: AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1430: AND PPA.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)

Line 1756: l_meaning pa_lookups.meaning%TYPE;

1752: IS
1753: l_api_name CONSTANT VARCHAR2(30) := 'check_start_end_date';
1754: l_start_date DATE;
1755: l_end_date DATE;
1756: l_meaning pa_lookups.meaning%TYPE;
1757: BEGIN
1758: p_return_status := FND_API.G_RET_STS_SUCCESS;
1759:
1760: -- added by hsiu

Line 1766: from pa_lookups

1762: IF p_context = 'START' then
1763: l_meaning := null;
1764: else
1765: select meaning into l_meaning
1766: from pa_lookups
1767: where lookup_type = 'PA_DATE' and lookup_code = p_context;
1768: end if;
1769:
1770: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE