APPS.PA_CI_SUPPLIER_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 69: from pa_resource_assignments pra, pa_resource_asgn_curr prac

65: from sys.dual;
66:
67: cursor get_budget_data(bvId number) is
68: select prac.total_projfunc_burdened_cost , prac.total_projfunc_revenue, prac.txn_average_bill_rate
69: from pa_resource_assignments pra, pa_resource_asgn_curr prac
70: where
71: pra.budget_version_id = bvId and pra.task_id = p_task_id and
72: pra.resource_list_member_id = p_Resource_List_Mem_Id and
73: prac.resource_assignment_id = pra.resource_assignment_id;

Line 81: select pa_resource_assignments_s.nextval

77: from pa_control_items
78: where ci_id = p_ci_id;
79:
80: cursor get_res_asgn_id is
81: select pa_resource_assignments_s.nextval
82: from sys.dual;
83:
84: cursor get_burdened_cost(ci_trans_id number) is
85: select final_cost from pa_ci_supplier_details

Line 141: from pa_resource_assignments

137: schedule_start_date,
138: schedule_end_date,
139: sp_fixed_date,
140: named_role
141: from pa_resource_assignments
142: where budget_version_id = bv_Id
143: and task_id = p_Task_Id
144: and resource_list_member_id = p_Resource_List_Mem_Id;
145:

Line 962: select pa_resource_assignments_s.nextval

958: from pa_ci_supplier_details
959: where ci_transaction_id = p_ci_transaction_id;
960:
961: cursor get_res_asgn_id is
962: select pa_resource_assignments_s.nextval
963: from sys.dual;
964:
965: CURSOR cur_row is
966: SELECT CI_TYPE_ID

Line 1014: from pa_resource_assignments

1010: where ci_id = p_ci_id;
1011:
1012: cursor get_resource_assignment_id(bv_Id number) is
1013: select resource_assignment_id
1014: from pa_resource_assignments
1015: where budget_version_id = bv_Id
1016: and task_id = p_Task_Id
1017: and resource_list_member_id = p_Resource_List_Mem_Id;
1018:

Line 1289: INSERT INTO PA_RESOURCE_ASSIGNMENTS(

1285: close get_res_asgn_id;
1286: open get_project_id;
1287: fetch get_project_id into l_project_id;
1288: close get_project_id;
1289: INSERT INTO PA_RESOURCE_ASSIGNMENTS(
1290: RESOURCE_ASSIGNMENT_ID
1291: ,BUDGET_VERSION_ID
1292: ,PROJECT_ID
1293: ,TASK_ID

Line 1365: update PA_RESOURCE_ASSIGNMENTS SET

1361: --nag_test('UPDATE resource assignment id '||l_res_asgn_Id);
1362: If l_debug_mode = 'Y' Then
1363: print_msg('Updating the existing resource assignment');
1364: End If;
1365: update PA_RESOURCE_ASSIGNMENTS SET
1366: LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
1367: ,LAST_UPDATED_BY = 1319
1368: ,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN
1369: ,TOTAL_PLAN_REVENUE = l_revenue

Line 1436: from pa_resource_assignments pra, pa_proj_elements ppe, pa_tasks pt

1432: where ci_id = p_ci_id;
1433:
1434: cursor get_assignment_details(p_bvId number, p_task_id number, p_res_id number) is
1435: select pra.RESOURCE_ASSIGNMENT_ID, ppe.ELEMENT_NUMBER, ppe.NAME
1436: from pa_resource_assignments pra, pa_proj_elements ppe, pa_tasks pt
1437: WHERE pra.budget_version_id = p_bvId
1438: and pra.task_id = p_task_id
1439: and pra.RESOURCE_LIST_MEMBER_ID = p_res_id
1440: and pt.task_id = ppe.proj_element_id;