[Home] [Help]
140:
141: SELECT 'Y'
142: INTO l_billable
143: FROM pa_projects_all pp,
144: pa_tasks t,
145: pa_project_types_all pt /** Bug fix 2262118 **/
146: WHERE t.task_id = p_task_id
147: AND pp.project_id = t.project_id
148: AND pp.project_type = pt.project_type
2309: FROM pa_expenditure_items_all EI
2310: ,pa_transaction_sources tr
2311: ,pa_project_types_all pt /** Bug fix 2262118 **/
2312: ,pa_projects_all pp
2313: -- ,pa_tasks t /* Bug 3457922 */
2314: WHERE tr.transaction_source(+) = ei.transaction_source
2315: AND ei.expenditure_item_id = ItemsIdTab(i)
2316: -- AND t.task_id = ei.task_id /* Bug 3457922 */
2317: -- AND pp.project_id = t.project_id /* Bug 3457922 */
4182:
4183: ( SELECT
4184: t.task_id
4185: FROM
4186: pa_tasks t
4187: WHERE
4188: t.project_id = X_project_id
4189: AND t.task_id = nvl( X_task_id, t.task_id )
4190: )
4293: AND ei.billable_flag <> 'Y'
4294: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4295: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4296: AND exists (select 1
4297: From pa_tasks t
4298: Where t.task_id = ei.task_id
4299: And t.retirement_cost_flag = 'N')
4300:
4301: )
4304: AND ei.billable_flag = 'Y'
4305: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4306: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4307: AND exists (select 1
4308: From pa_tasks t
4309: Where t.task_id = ei.task_id
4310: And t.retirement_cost_flag = 'N')
4311: )
4312: OR
4392: AND ei.billable_flag <> 'Y'
4393: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4394: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4395: AND exists (select 1
4396: From pa_tasks t
4397: Where t.task_id = ei.task_id
4398: And t.retirement_cost_flag = 'N')
4399: )
4400: OR
4402: AND ei.billable_flag = 'Y'
4403: AND nvl( ei.converted_flag, 'N' ) <> 'Y'
4404: AND nvl( eia.converted_flag, 'N' ) <> 'Y'
4405: AND exists (select 1
4406: From pa_tasks t
4407: Where t.task_id = ei.task_id
4408: And t.retirement_cost_flag = 'N')
4409: )
4410: OR
4516: WHERE
4517: /* Bug # 3457873
4518: ei.task_id IN (
4519: SELECT task_id
4520: FROM pa_tasks
4521: WHERE project_id = X_project_id )
4522: */
4523: ei.project_id = X_project_id /* Bug # 3457873 */
4524: AND ei.expenditure_item_id = eia.adjusted_expenditure_item_id (+)
5865: || ' AND p.org_id = pt.org_id'
5866: || ' AND p.project_id = ei.project_id'
5867: || ' AND pt.project_type_class_code = ''CAPITAL'')'
5868: || ' AND 1 = (SELECT 1'
5869: || ' FROM pa_tasks t'
5870: || ' WHERE t.task_id = ei.task_id'
5871: || ' AND t.retirement_cost_flag = ''N'')'
5872: || ' AND ei.revenue_distributed_flag = :grouped_cip_flag';
5873: end if;
5880: || ' AND p.org_id = pt.org_id'
5881: || ' AND p.project_id = ei.project_id'
5882: || ' AND pt.project_type_class_code = ''CAPITAL'')'
5883: || ' AND 1 = (SELECT 1'
5884: || ' FROM pa_tasks t'
5885: || ' WHERE t.task_id = ei.task_id'
5886: || ' AND t.retirement_cost_flag = ''Y'')'
5887: || ' AND ei.revenue_distributed_flag = :grouped_rwip_flag';
5888: end if;
5895: || ' AND p.org_id = pt.org_id'
5896: || ' AND p.project_id = ei.project_id'
5897: || ' AND pt.project_type_class_code = ''CAPITAL'')'
5898: || ' AND 1 = (SELECT 1'
5899: || ' FROM pa_tasks t'
5900: || ' WHERE t.task_id = ei.task_id'
5901: || ' AND t.billable_flag = ''N'''
5902: || ' AND t.retirement_cost_flag = ''N'')';
5903: end if;
6674: l_start_date DATE;
6675: l_end_date DATE;
6676: cursor task_start_end_date is
6677: select start_date, completion_date
6678: from pa_tasks
6679: where task_id = X_dest_task_id;
6680: begin
6681: open task_start_end_date;
6682: fetch task_start_end_date into l_start_date, l_end_date;
9378: l_acct_rate_type pa_expenditure_items_all.acct_rate_type%TYPE;
9379: l_acct_rate_date_code pa_implementations_all.acct_rate_date_code%TYPE;
9380: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
9381: l_ot_project_id pa_projects_all.project_id%TYPE;
9382: l_ot_task_id pa_tasks.task_id%TYPE;
9383: l_err_stage number;
9384: l_err_code varchar2(1000);
9385: OTHERS_EXCEPTION EXCEPTION;
9386: