DBA Data[Home] [Help]

APPS.PA_USER_ATTR_PUB dependencies on PA_PROJECT_TYPES

Line 1149: FROM pa_project_types PTT, pa_projects_all PPA

1145:
1146: CURSOR get_old_project_type_id
1147: IS
1148: SELECT PTT.project_type_id
1149: FROM pa_project_types PTT, pa_projects_all PPA
1150: WHERE PPA.project_id = p_project_id
1151: AND PPA.project_type = PTT.project_type;
1152:
1153: CURSOR get_new_project_type_id

Line 1156: FROM pa_project_types

1152:
1153: CURSOR get_new_project_type_id
1154: IS
1155: SELECT project_type_id
1156: FROM pa_project_types
1157: WHERE project_type = p_new_project_type;
1158:
1159:
1160: l_old_project_type_id NUMBER;