[Home] [Help]
147: pra.schedule_start_date,
148: pra.schedule_end_date,
149: pra.sp_fixed_date,
150: pra.named_role
151: from pa_resource_assignments pra, pa_resource_asgn_curr prc
152: where pra.budget_version_id = c_bv_Id
153: and pra.task_id = c_Task_Id
154: and pra.resource_list_member_id = c_rlmi_id
155: and pra.resource_assignment_id = prc.resource_assignment_id
655: c_task_id number,
656: c_rlmi_id number,
657: c_currency_code varchar2) is
658: select pra.RESOURCE_ASSIGNMENT_ID, ppe.ELEMENT_NUMBER, ppe.NAME
659: from pa_resource_assignments pra, pa_proj_elements ppe, pa_tasks pt,
660: pa_resource_asgn_curr prc
661: WHERE pra.budget_version_id = c_bvId
662: and pra.task_id = c_task_id
663: and pra.RESOURCE_LIST_MEMBER_ID = c_rlmi_id
1112: c_currency_code varchar2) is
1113: select 'Y', pra.resource_assignment_id,
1114: total_quantity,
1115: total_txn_raw_cost
1116: from pa_resource_assignments pra, pa_resource_asgn_curr prac
1117: where pra.budget_version_id = c_bvid and pra.task_id = c_task_id
1118: and pra.resource_list_member_id = c_rlmi_id
1119: and prac.txn_currency_code = c_currency_code
1120: and prac.resource_assignment_id = pra.resource_assignment_id;
1122: cursor get_resource_asgn_csr(c_bvid number,
1123: c_task_id number,
1124: c_rlmi_id number) is
1125: select txn_currency_code
1126: from pa_resource_assignments pra, pa_resource_asgn_curr prc
1127: where pra.resource_assignment_id = prc.resource_assignment_id
1128: and pra.budget_version_id = c_bvid
1129: and pra.task_id = c_task_id
1130: and pra.resource_list_member_id = c_rlmi_id
1598: ,pc.last_update_by
1599: ,pc.last_update_date
1600: ,pc.last_update_login
1601: from pa_ci_direct_cost_details pc,
1602: pa_resource_assignments pra,
1603: pa_resource_asgn_curr prc
1604: where pc.ci_id = p_ci_id
1605: and pc.dc_line_id = p_line_id_tbl(j)
1606: and pc.resource_assignment_id is null