APPS.PA_RBS_PUB dependencies on PA_RBS_VERSIONS_B

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 1248: Pa_Rbs_Versions_B b,

1244: b.Job_Group_Id,
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;

Line 1583: FROM PA_RBS_VERSIONS_B

1579: ELSE
1580: BEGIN
1581: SELECT status_code
1582: INTO l_status_code
1583: FROM PA_RBS_VERSIONS_B
1584: WHERE rbs_version_id = l_Elements_Tbl(i).Rbs_Version_Id;
1585:
1586: IF l_status_code = 'FROZEN' THEN
1587:

Line 2577: Pa_Rbs_Versions_b

2573: Cursor C_GetVersionId1(P_Header_Id IN Number, P_Version_Number IN Number) Is
2574: Select
2575: rbs_version_id
2576: From
2577: Pa_Rbs_Versions_b
2578: Where
2579: rbs_header_id=P_Header_Id
2580: And
2581: version_number=P_Version_Number;

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 2605: Pa_Rbs_Versions_b

2601: Cursor C_GetHeaderId Is
2602: Select
2603: rbs_header_id
2604: From
2605: Pa_Rbs_Versions_b
2606: Where
2607: rbs_version_id=P_RBS_Version_Id;
2608:
2609: Begin

Line 2757: Pa_Rbs_Versions_b

2753: Cursor C_GetVersionId1(P_Header_Id IN Number) Is
2754: Select
2755: Rbs_Version_Id
2756: From
2757: Pa_Rbs_Versions_b
2758: Where
2759: rbs_header_id=P_Header_Id
2760: And
2761: status_code='WORKING';

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 2921: From Pa_Rbs_Versions_b

2917: l_project_id Number;
2918:
2919: Cursor C_GetVersionId1(P_Header_Id IN Number) IS
2920: Select rbs_version_id
2921: From Pa_Rbs_Versions_b
2922: Where rbs_header_id = P_Header_Id
2923: And current_reporting_flag = 'Y'; -- Added
2924: --And version_number=P_Version_Number;
2925:

Line 2928: From Pa_Rbs_Versions_b ver,

2924: --And version_number=P_Version_Number;
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

Line 2938: --From Pa_Rbs_Versions_b

2934: --And ver.version_number=P_Version_Number;
2935:
2936: --Cursor C_GetHeaderId Is
2937: --Select rbs_header_id
2938: --From Pa_Rbs_Versions_b
2939: --Where rbs_version_id = P_RBS_Version_Id;
2940:
2941: l_current_flag VARCHAR2(1);
2942:

Line 3048: FROM pa_rbs_versions_b

3044: l_current_flag := 'N';
3045: BEGIN
3046: SELECT nvl(current_reporting_flag, 'N')
3047: INTO l_current_flag
3048: FROM pa_rbs_versions_b
3049: WHERE Rbs_Version_Id = l_Rbs_Version_Id;
3050:
3051: EXCEPTION WHEN NO_DATA_FOUND THEN
3052: l_current_flag := 'N';