APPS.PA_TASKS_MAINT_UTILS dependencies on PA_LOOKUPS

Line 1245: ,PA_LOOKUPS PL

1241: ,PL.MEANING SERVICE_TYPE_NAME
1242: FROM PA_TASKS PT
1243: ,HR_ORGANIZATION_UNITS HOU
1244: ,PA_WORK_TYPES_TL PWT
1245: ,PA_LOOKUPS PL
1246: WHERE PT.TASK_ID = p_task_id
1247: AND PT.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1248: AND PT.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)
1249: AND userenv('lang') = PWT.language(+)

Line 1375: ,PA_LOOKUPS PL

1371: ,PL.MEANING SERVICE_TYPE_NAME
1372: FROM PA_PROJECTS_ALL PPA
1373: ,HR_ORGANIZATION_UNITS HOU
1374: ,PA_WORK_TYPES_TL PWT
1375: ,PA_LOOKUPS PL
1376: ,PA_PROJECT_TYPES_ALL PPT
1377: WHERE PPA.PROJECT_ID = p_project_id
1378: AND PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
1379: AND PPA.WORK_TYPE_ID = PWT.WORK_TYPE_ID(+)

Line 1705: l_meaning pa_lookups.meaning%TYPE;

1701: IS
1702: l_api_name CONSTANT VARCHAR2(30) := 'check_start_end_date';
1703: l_start_date DATE;
1704: l_end_date DATE;
1705: l_meaning pa_lookups.meaning%TYPE;
1706: BEGIN
1707: p_return_status := FND_API.G_RET_STS_SUCCESS;
1708:
1709: -- added by hsiu

Line 1715: from pa_lookups

1711: IF p_context = 'START' then
1712: l_meaning := null;
1713: else
1714: select meaning into l_meaning
1715: from pa_lookups
1716: where lookup_type = 'PA_DATE' and lookup_code = p_context;
1717: end if;
1718:
1719: IF p_new_start_date <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE