[Home] [Help]
278: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
280:
281: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
282: l_task_number PA_TASKS.TASK_NUMBER%TYPE;
283: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;
284:
285: -- Variables added for Bug Fix 4582616
286: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
900: SELECT p.name, ta.task_number, rlm.alias
901: INTO l_project_name, l_task_number, l_resource_name
902: FROM pa_resource_assignments ra,
903: pa_projects_all p,
904: pa_tasks ta,
905: pa_resource_list_members rlm
906: WHERE ra.resource_assignment_id = l_res_asg_id(i)
907: AND p.project_id = ra.project_id
908: AND ta.task_id (+) = ra.task_id
1122: l_bl_id_counter := l_bl_id_counter + 1;
1123:
1124: -- Get the target task billability flag
1125: SELECT NVL(billable_flag,'Y') INTO l_billable_flag
1126: FROM pa_tasks ta,
1127: pa_resource_assignments ra
1128: WHERE ra.resource_assignment_id = l_res_asg_id(i)
1129: AND ra.task_id = ta.task_id (+);
1130:
1739: l_sr_tgt_ra_id_tab,
1740: l_sr_txn_currency_code_tab
1741: FROM pa_resource_assignments src_ra,
1742: pa_resource_assignments tgt_ra,
1743: pa_tasks ta,
1744: pa_fp_rollup_tmp cmt
1745: WHERE tgt_ra.resource_assignment_id = cmt.resource_assignment_id
1746: AND ta.task_id (+) = NVL(tgt_ra.task_id,0) -- A. check billability
1747: AND NVL(ta.billable_flag,'Y') = 'Y' -- A. check billability
1765: INTO l_sr_src_ra_id_tab,
1766: l_sr_tgt_ra_id_tab,
1767: l_sr_txn_currency_code_tab
1768: FROM pa_fp_calc_amt_tmp1 tmp1,
1769: pa_tasks ta,
1770: pa_fp_rollup_tmp cmt
1771: WHERE tmp1.transaction_source_code = 'FINANCIAL_PLAN' -- C. check finplan
1772: AND tmp1.target_res_asg_id = cmt.resource_assignment_id
1773: AND ta.task_id (+) = NVL(tmp1.task_id,0) -- A. check billability