APPS.PA_RBS_PUB dependencies on PA_RBS_HEADERS_TL

Line 59: pa_rbs_headers_tl b

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;
63:

Line 93: from pa_rbs_headers_tl

89: IF l_rbs_header_name is not null and l_rbs_header_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR Then
90: BEGIN
91: Select rbs_header_id
92: into l_rbs_header_id
93: from pa_rbs_headers_tl
94: where name= l_rbs_header_name
95: AND language = userenv('LANG');
96: EXCEPTION
97: WHEN OTHERS THEN

Line 1230: Pa_Rbs_Headers_TL tl

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
1234: AND tl.language = userenv('LANG');

Line 2589: Pa_Rbs_Versions_b ver, Pa_Rbs_Headers_tl Hdr

2585: Cursor C_GetVersionId2(P_Header_Name IN Varchar2, P_Version_Number IN Number) Is
2586: Select
2587: rbs_version_id
2588: From
2589: Pa_Rbs_Versions_b ver, Pa_Rbs_Headers_tl Hdr
2590: Where
2591: hdr.name=P_Header_Name
2592: And
2593: hdr.language = userenv('LANG')

Line 2767: Pa_Rbs_Versions_b ver, Pa_Rbs_Headers_tl Hdr

2763: Cursor C_GetVersionId2(P_Header_Name IN Varchar2) Is
2764: Select
2765: Rbs_Version_Id
2766: From
2767: Pa_Rbs_Versions_b ver, Pa_Rbs_Headers_tl Hdr
2768: Where
2769: Hdr.name=P_Header_Name
2770: And
2771: hdr.language = userenv('LANG')

Line 2929: Pa_Rbs_Headers_tl Hdr

2925:
2926: Cursor C_GetVersionId2(P_Header_Name IN Varchar2) IS
2927: Select rbs_version_id
2928: From Pa_Rbs_Versions_b ver,
2929: Pa_Rbs_Headers_tl Hdr
2930: Where hdr.name = P_Header_Name
2931: And hdr.language = userenv('LANG')
2932: And hdr.rbs_header_id = ver.rbs_header_id
2933: And ver.current_reporting_flag = 'Y'; -- Added