APPS.PA_YEAR_END_ROLLOVER_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

Line 157: l_Parent_Member_ID PA_Resource_List_Members.Parent_Member_ID%TYPE;

153: IS
154:
155: -- Local Variables
156: l_Top_Task_ID PA_Tasks.Task_ID%TYPE;
157: l_Parent_Member_ID PA_Resource_List_Members.Parent_Member_ID%TYPE;
158: l_Project_Status_Code VARCHAR2(100);
159: l_Change_Reason_Code VARCHAR2(100);
160: l_Message_Code_Error VARCHAR2(100);
161: l_Message_Name VARCHAR2(100);

Line 186: l_Resource_List_Member_ID PA_Resource_List_Members.Resource_List_Member_ID%TYPE;

182: l_GL_Budget_Version_ID PA_Budgetary_Control_Options.GL_Budget_Version_ID%TYPE;
183: l_Raw_Cost_Flag PA_Budget_Entry_Methods.Raw_Cost_Flag%TYPE;
184: l_Burdened_Cost_Flag PA_Budget_Entry_Methods.Burdened_Cost_Flag%TYPE;
185: l_Entry_Level_Code PA_Budget_Entry_Methods.Entry_Level_Code%TYPE;
186: l_Resource_List_Member_ID PA_Resource_List_Members.Resource_List_Member_ID%TYPE;
187: l_CCID GL_Code_Combinations.Code_Combination_ID%TYPE;
188: l_New_CCID GL_Code_Combinations.Code_Combination_ID%TYPE;
189:
190: --

Line 618: FROM PA_RESOURCE_LIST_MEMBERS

614: -- Derive Parent Member ID
615: BEGIN
616: SELECT Parent_Member_ID
617: INTO l_Parent_Member_ID
618: FROM PA_RESOURCE_LIST_MEMBERS
619: WHERE Resource_List_Member_ID = l_Resource_List_Member_ID;
620:
621: IF P_DEBUG_MODE = 'Y' THEN
622: log_message('Year_End_Rollover: ' || 'PA_BC_PACKETS: Parent Member ID : '|| l_Parent_Member_ID );

Line 1554: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,

1550: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1551: P_Transfer_Amount IN NUMBER,
1552: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1553: P_Task_ID IN PA_Tasks.Task_ID%TYPE,
1554: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,
1555: P_Raw_Cost_Flag IN PA_Budget_Entry_Methods.Raw_Cost_Flag%TYPE,
1556: P_Burdened_Cost_Flag IN PA_Budget_Entry_Methods.Burdened_Cost_Flag%TYPE,
1557: P_CCID IN GL_Code_Combinations.Code_Combination_ID%TYPE,
1558: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,

Line 2164: pa_resource_list_members rm,

2160: l_request_id
2161: from pa_budget_lines pb,
2162: pa_resource_assignments pa,
2163: pa_tasks pt,
2164: pa_resource_list_members rm,
2165: pa_budget_versions pbv
2166: where pbv.budget_version_id = p_budget_version_id
2167: and pa.resource_assignment_id = pb.resource_assignment_id
2168: and pa.task_id = pt.task_id (+)