APPS.PA_RBS_ASGMT_PVT dependencies on PA_RBS_VERSIONS_B

Line 145: FROM pa_rbs_versions_b

141:
142: IF p_rbs_version_id IS NOT NULL THEN
143: SELECT rbs_version_id
144: INTO l_rbs_version_id
145: FROM pa_rbs_versions_b
146: WHERE rbs_version_id = p_rbs_version_id
147: AND rbs_header_id = p_rbs_header_id
148: AND status_code = 'FROZEN';
149: ELSE

Line 671: FROM pa_rbs_versions_b

667: *******************************************************/
668: BEGIN
669: SELECT rbs_version_id
670: INTO l_rbs_version_id
671: FROM pa_rbs_versions_b
672: WHERE rbs_version_id = p_rbs_version_id
673: AND rbs_header_id = p_rbs_header_id
674: AND status_code = 'FROZEN';
675: EXCEPTION

Line 814: FROM pa_rbs_versions_b

810: X_Return_Status := Fnd_Api.G_Ret_Sts_Success;
811: BEGIN
812: SELECT rbs_header_id
813: INTO l_rbs_header_id
814: FROM pa_rbs_versions_b
815: WHERE rbs_version_id = p_rbs_new_version_id;
816: EXCEPTION
817: WHEN OTHERS THEN
818: X_Return_Status := Fnd_Api.G_Ret_Sts_UNEXP_ERROR;