APPS.PA_RBS_UTILS dependencies on PA_RBS_PRJ_ASSIGNMENTS

Line 3535: INSERT INTO pa_rbs_prj_assignments (

3531: -- Bug 3950096 - create association for reporting if resource list
3532: -- was used for reporting.
3533: -- Bug 4303512 - added outer join to make sure only one
3534: -- RBS association is marked as primary.
3535: INSERT INTO pa_rbs_prj_assignments (
3536: RBS_PRJ_ASSIGNMENT_ID ,
3537: PROJECT_ID ,
3538: RBS_VERSION_ID ,
3539: RBS_HEADER_ID ,

Line 3552: (SELECT pa_rbs_prj_assignments_s.nextval,

3548: CREATION_DATE ,
3549: CREATED_BY ,
3550: LAST_UPDATE_LOGIN ,
3551: RECORD_VERSION_NUMBER )
3552: (SELECT pa_rbs_prj_assignments_s.nextval,
3553: asg.project_id,
3554: l_rbs_version_id,
3555: l_rbs_header_id,
3556: 'Y',

Line 3570: pa_rbs_prj_assignments rpa

3566: fnd_global.login_id,
3567: 1
3568: FROM pa_resource_list_assignments asg,
3569: pa_resource_list_uses pru,
3570: pa_rbs_prj_assignments rpa
3571: WHERE asg.resource_list_id = l_list.resource_list_id
3572: AND asg.resource_list_assignment_id =
3573: pru.resource_list_assignment_id
3574: AND pru.use_code = 'ACTUALS_ACCUM'

Line 3831: DELETE FROM pa_rbs_prj_assignments

3827: IS
3828: BEGIN
3829: x_return_status := FND_API.G_RET_STS_SUCCESS;
3830: x_msg_count := 0;
3831: DELETE FROM pa_rbs_prj_assignments
3832: WHERE project_id = p_project_id;
3833: EXCEPTION
3834: WHEN OTHERS THEN
3835: FND_MSG_PUB.add_exc_msg( p_pkg_name =>