DBA Data[Home] [Help]

APPS.PA_PROJECT_PARTIES_PUB dependencies on PA_RESOURCE_TYPES

Line 202: FROM pa_resource_types

198: start date should be sysdate*/
199: /* Bug 3116962 : Added a IF clause to check if the project_role_id is valid or not. Accordingly the SELECT statement below will execute. */
200: IF l_project_role_id <> -999 AND x_return_status = FND_API.G_RET_STS_SUCCESS THEN
201: SELECT resource_type_id into x_resource_type_id
202: FROM pa_resource_types
203: WHERE resource_type_code='HZ_PARTY';
204:
205: /* Bug 2876924 - For external people start date should not be defaulted to sysdate.
206: resource type id of external people is same as that of org. ie 112.