APPS.PA_RBS_ASGMT_PUB dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 166: INSERT INTO pa_rbs_prj_assignments

162:
163: BEGIN
164: x_return_status := FND_API.G_RET_STS_SUCCESS;
165:
166: INSERT INTO pa_rbs_prj_assignments
167: (RBS_PRJ_ASSIGNMENT_ID,
168: PROJECT_ID,
169: RBS_VERSION_ID,
170: RBS_HEADER_ID,

Line 184: PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL,

180: CREATED_BY,
181: LAST_UPDATE_LOGIN,
182: RECORD_VERSION_NUMBER)
183: SELECT
184: PA_RBS_PRJ_ASSIGNMENTS_S.NEXTVAL,
185: p_destination_project_id,
186: a.RBS_VERSION_ID,
187: a.RBS_HEADER_ID,
188: a.REPORTING_USAGE_FLAG,

Line 200: FROM pa_rbs_prj_assignments a

196: sysdate,
197: a.CREATED_BY,
198: a.LAST_UPDATE_LOGIN,
199: 1
200: FROM pa_rbs_prj_assignments a
201: WHERE a.project_id = p_source_project_id
202: AND a.assignment_status = 'ACTIVE'
203: AND NOT EXISTS
204: (select rbs_prj_assignment_id

Line 205: from pa_rbs_prj_assignments b

201: WHERE a.project_id = p_source_project_id
202: AND a.assignment_status = 'ACTIVE'
203: AND NOT EXISTS
204: (select rbs_prj_assignment_id
205: from pa_rbs_prj_assignments b
206: where a.rbs_header_id = b.rbs_header_id
207: and a.rbs_version_id = b.rbs_version_id
208: and b.project_id = p_destination_project_id);
209: EXCEPTION