[Home] [Help]
277: l_pc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
278: l_pfc_cur_conv_rej_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
279:
280: l_project_name PA_PROJECTS_ALL.NAME%TYPE;
281: l_task_number PA_TASKS.TASK_NUMBER%TYPE;
282: l_resource_name PA_RESOURCE_LIST_MEMBERS.ALIAS%TYPE;
283:
284: -- Variables added for Bug Fix 4582616
285: l_fp_src_plan_ver_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
892: SELECT p.name, ta.task_number, rlm.alias
893: INTO l_project_name, l_task_number, l_resource_name
894: FROM pa_resource_assignments ra,
895: pa_projects_all p,
896: pa_tasks ta,
897: pa_resource_list_members rlm
898: WHERE ra.resource_assignment_id = l_res_asg_id(i)
899: AND p.project_id = ra.project_id
900: AND ta.task_id (+) = ra.task_id
1114: l_bl_id_counter := l_bl_id_counter + 1;
1115:
1116: -- Get the target task billability flag
1117: SELECT NVL(billable_flag,'Y') INTO l_billable_flag
1118: FROM pa_tasks ta,
1119: pa_resource_assignments ra
1120: WHERE ra.resource_assignment_id = l_res_asg_id(i)
1121: AND ra.task_id = ta.task_id (+);
1122:
1731: l_sr_tgt_ra_id_tab,
1732: l_sr_txn_currency_code_tab
1733: FROM pa_resource_assignments src_ra,
1734: pa_resource_assignments tgt_ra,
1735: pa_tasks ta,
1736: pa_fp_rollup_tmp cmt
1737: WHERE tgt_ra.resource_assignment_id = cmt.resource_assignment_id
1738: AND ta.task_id (+) = NVL(tgt_ra.task_id,0) -- A. check billability
1739: AND NVL(ta.billable_flag,'Y') = 'Y' -- A. check billability
1757: INTO l_sr_src_ra_id_tab,
1758: l_sr_tgt_ra_id_tab,
1759: l_sr_txn_currency_code_tab
1760: FROM pa_fp_calc_amt_tmp1 tmp1,
1761: pa_tasks ta,
1762: pa_fp_rollup_tmp cmt
1763: WHERE tmp1.transaction_source_code = 'FINANCIAL_PLAN' -- C. check finplan
1764: AND tmp1.target_res_asg_id = cmt.resource_assignment_id
1765: AND ta.task_id (+) = NVL(tmp1.task_id,0) -- A. check billability