[Home] [Help]
52: select 1
53: from sys.dual
54: where not exists
55: (select 1
56: from pa_agreements_all a,
57: pa_summary_project_fundings f
58: where f.project_id = x_project_id
59: and nvl(f.task_id, 0) = x_task_id
60: and ( ( nvl(f.total_baselined_amount, 0)
70: select 1
71: from sys.dual
72: where not exists
73: (select 1
74: from pa_agreements_all a,
75: pa_summary_project_fundings f
76: where f.project_id = x_project_id
77: and nvl(f.task_id, 0) = x_task_id
78: and ( ( nvl(f.projfunc_baselined_amount, 0)
83: and f.agreement_id = a.agreement_id
84: and a.revenue_limit_flag = 'Y')
85: and not exists
86: (select 1
87: from pa_agreements_all a,
88: pa_summary_project_fundings f
89: where f.project_id = x_project_id
90: and nvl(f.task_id, 0) = x_task_id
91: and ( ( nvl(f.invproc_baselined_amount, 0)
160: and PPC.customer_bill_split > 0 /* Added for Bug2453912 */
161: and not exists
162: (
163: select 1 from pa_summary_project_fundings PSPF,
164: pa_agreements_all PAA
165: where PPC.customer_id = PAA.customer_id
166: and PAA.agreement_id = PSPF.agreement_id
167: and PPC.project_id= PSPF.project_id
168: )
1113:
1114: -- dbms_output.put_line('x_agreement_id = '||to_char(x_agreement_id));
1115: x_err_stage := 'Insert into pa_agreements.';
1116:
1117: INSERT INTO PA_AGREEMENTS_ALL(
1118: agreement_id,
1119: customer_id,
1120: agreement_num,
1121: agreement_type,
1179: nvl(x_owning_organization_id,a.owning_organization_id),
1180: a.invoice_limit_flag,
1181: mo_global.get_current_org_id
1182: /* MCB2 columns end */
1183: FROM pa_agreements_all a, pa_projects_all p
1184: WHERE p.project_id = x_new_project_id
1185: /* Bug 727421 Performance Issue
1186: AND exists
1187: (select null
1381: */
1382:
1383: select agreement_currency_code, amount
1384: into l_funding_currency_code, l_allocated_amount
1385: from pa_agreements_all
1386: where agreement_id = x_agreement_id;
1387:
1388: /*
1389: dbms_output.put_line(' in copy fund agreement_curr = '||