26: FROM dual
27: WHERE EXISTS (
28: SELECT 'CC TXNS'
29: FROM igc_cc_acct_lines igc
30: ,pa_projects_all pp
31: WHERE igc.project_id IS NOT NULL
32: AND igc.project_id = pp.project_id
33: AND pp.project_id = p_project_id
34: AND igc.task_id IN ( SELECT task.task_id
45: FROM dual
46: WHERE EXISTS (
47: SELECT 'CC TXNS'
48: FROM igc_cc_acct_lines igc
49: ,pa_projects_all pp
50: WHERE igc.project_id IS NOT NULL
51: AND igc.project_id = pp.project_id
52: AND pp.project_id = p_project_id
53: );
236: 'N', decode(t.work_type_id,NULL,
237: decode(ppasgn.work_type_id,NULL,pp.work_type_id,ppasgn.work_type_id)
238: ,t.work_type_id)
239: ) work_type_id
240: FROM pa_projects_all pp
241: ,pa_project_assignments ppasgn
242: ,pa_tasks t
243: WHERE pp.project_id = p_project_id
244: AND t.task_id = p_task_id
251: );
252:
253: CURSOR cur_Task_worktype IS
254: select Decode(t.work_type_id,NULL,pp.work_type_id,t.work_type_id) work_type_id
255: FROM pa_projects_all pp
256: ,pa_tasks t
257: WHERE pp.project_id = p_project_id
258: AND t.task_id = p_task_id
259: AND t.project_id = pp.project_id ;