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 187: l_Resource_List_Member_ID PA_Resource_List_Members.Resource_List_Member_ID%TYPE;

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

Line 619: FROM PA_RESOURCE_LIST_MEMBERS

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

Line 1611: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,

1607: P_Period_End_Date IN GL_Periods.End_Date%TYPE,
1608: P_Transfer_Amount IN NUMBER,
1609: P_Project_ID IN PA_Projects_all.Project_ID%TYPE,
1610: P_Task_ID IN PA_Tasks.Task_ID%TYPE,
1611: P_Resource_List_Member_ID IN PA_Resource_List_Members.Resource_List_Member_ID%TYPE,
1612: P_Raw_Cost_Flag IN PA_Budget_Entry_Methods.Raw_Cost_Flag%TYPE,
1613: P_Burdened_Cost_Flag IN PA_Budget_Entry_Methods.Burdened_Cost_Flag%TYPE,
1614: P_CCID IN GL_Code_Combinations.Code_Combination_ID%TYPE,
1615: P_Request_ID IN FND_Concurrent_Requests.Request_ID%TYPE,

Line 2221: pa_resource_list_members rm,

2217: l_request_id
2218: from pa_budget_lines pb,
2219: pa_resource_assignments pa,
2220: pa_tasks pt,
2221: pa_resource_list_members rm,
2222: pa_budget_versions pbv
2223: where pbv.budget_version_id = p_budget_version_id
2224: and pa.resource_assignment_id = pb.resource_assignment_id
2225: and pa.task_id = pt.task_id (+)