APPS.PA_RBS_PUB dependencies on PA_RBS_VERSIONS_TL

Line 247: from pa_rbs_versions_b a, pa_rbs_versions_tl b

243: IS
244:
245: Cursor C_Rbs_Version_Details(P_Rbs_Version_Id IN Number) IS
246: Select a.rbs_version_id, b.name, b.Description,a.Version_Start_Date ,a.Job_Group_Id ,a.Record_Version_Number
247: from pa_rbs_versions_b a, pa_rbs_versions_tl b
248: Where a.rbs_version_id=P_Rbs_version_Id
249: and a.rbs_version_id=b.rbs_version_id;
250:
251: Rec_Details C_Rbs_Version_Details%RowType;

Line 274: From pa_rbs_versions_tl

270: -- Get the header id from the name if the name is not null
271: IF l_rbs_version_name is not null and l_rbs_version_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
272: Select rbs_version_id
273: Into l_rbs_version_id
274: From pa_rbs_versions_tl
275: Where name= l_rbs_version_name ;
276: End if ;
277: End if;
278:

Line 1249: Pa_Rbs_Versions_TL tl

1245: b.status_code,
1246: b.record_version_number
1247: From
1248: Pa_Rbs_Versions_B b,
1249: Pa_Rbs_Versions_TL tl
1250: Where
1251: b.Rbs_Version_Id = p_version_id
1252: And b.Rbs_Version_Id = tl.Rbs_Version_Id;
1253: