DBA Data[Home] [Help]

APPS.PA_RBS_PUB dependencies on PA_RBS_HEADERS_B

Line 58: From pa_rbs_headers_b a,

54: b.Description,
55: a.Effective_From_Date,
56: a.Effective_To_Date,
57: a.Record_Version_Number
58: From pa_rbs_headers_b a,
59: pa_rbs_headers_tl b
60: Where a.rbs_header_id=P_Rbs_Header_Id
61: and b.language = userenv('LANG')
62: and a.rbs_header_id=b.rbs_header_id;

Line 110: from pa_rbs_headers_b

106: ELSE
107: BEGIN
108: Select rbs_header_id
109: into l_rbs_header_id
110: from pa_rbs_headers_b
111: where rbs_header_id = P_Header_Rec.Rbs_Header_Id ;
112: EXCEPTION
113: WHEN OTHERS THEN
114: Pa_Debug.G_Stage := 'No Rbs Element id was provided. Add error message to stack.';

Line 1229: Pa_Rbs_Headers_B b,

1225: b.Effective_From_Date,
1226: b.Effective_To_Date,
1227: b.record_version_number
1228: From
1229: Pa_Rbs_Headers_B b,
1230: Pa_Rbs_Headers_TL tl
1231: Where
1232: b.Rbs_Header_Id = p_header_id
1233: And b.Rbs_Header_Id = tl.Rbs_Header_Id