APPS.PA_ALTERNATE_TASK_PVT dependencies on PA_RBS_ELEMENTS

Line 319: FROM PA_ALTERNATE_TASKS pat , PA_RBS_ELEMENTS pre

315: cursor isCostCodeAdded(c_Proj_Element_Id IN NUMBER, c_Cbs_Element_Id IN NUMBER) IS
316: select 'Y' from dual where
317: EXISTS
318: (SELECT *
319: FROM PA_ALTERNATE_TASKS pat , PA_RBS_ELEMENTS pre
320: WHERE (pat.CBS_ELEMENT_ID = c_Cbs_Element_Id
321: AND pat.PROJ_ELEMENT_ID = c_Proj_Element_Id)
322: OR (pat.CBS_ELEMENT_ID = pre.RBS_ELEMENT_ID --bug#16311830 checking if cost code is disabled
323: AND pat.CBS_ELEMENT_ID = c_Cbs_Element_Id

Line 941: (select rbs_version_id from pa_rbs_elements

937: (SELECT *
938: FROM pa_projects_all
939: WHERE project_id = c_Project_Id
940: AND CBS_VERSION_ID =
941: (select rbs_version_id from pa_rbs_elements
942: where rbs_element_id = c_Cbs_Element_Id)
943: );
944:
945: l_Cbs_Enabled VARCHAR2(1) := 'N';

Line 1028: AND cbs_element_id = (select rbs_element_id from pa_rbs_elements

1024: EXISTS
1025: (SELECT *
1026: FROM PA_ALTERNATE_TASKS
1027: WHERE proj_element_id = c_Task_Id
1028: AND cbs_element_id = (select rbs_element_id from pa_rbs_elements
1029: where cost_code = c_Cost_Code
1030: and rbs_version_id =
1031: (select cbs_version_id from pa_projects_all where project_id = c_Project_Id))
1032: );

Line 1037: (select * from pa_rbs_elements

1033:
1034: cursor validateCBSStructure(c_Project_Id IN NUMBER, c_Cost_Code IN Varchar2) IS
1035: select 'Y' from dual where
1036: EXISTS
1037: (select * from pa_rbs_elements
1038: where cost_code = c_Cost_Code
1039: and rbs_version_id =
1040: (select cbs_version_id from pa_projects_all where project_id = c_Project_Id)
1041: );

Line 1237: from pa_alternate_tasks pat , pa_rbs_elements pre , pa_proj_elements ppe

1233: IS
1234: disable_flag VARCHAR2(1):='N';
1235: CURSOR C1 IS
1236: SELECT DECODE(COUNT(*),0,'N','Y') DISABLED_EXISTS
1237: from pa_alternate_tasks pat , pa_rbs_elements pre , pa_proj_elements ppe
1238: where pat.cbs_element_id = pre.rbs_element_id
1239: and ppe.proj_element_id = pat.proj_element_id
1240: and pre.ENABLE_FLAG='N' and ppe.project_id=P_Project_Id;
1241:

Line 1260: FROM PA_RBS_ELEMENTS PRE , PA_PROJECTS_ALL PPA

1256: IS
1257: l_cbs_element_id NUMBER(15) :=null;
1258: CURSOR C1 IS
1259: SELECT PRE.RBS_ELEMENT_ID CBS_ELEMENT_ID
1260: FROM PA_RBS_ELEMENTS PRE , PA_PROJECTS_ALL PPA
1261: WHERE PRE.RBS_VERSION_ID=PPA.CBS_VERSION_ID
1262: AND PPA.PROJECT_ID=p_project_id
1263: AND PRE.COST_CODE=p_cost_code;
1264: