DBA Data[Home] [Help]

APPS.PA_BILLING_CORE dependencies on PA_PROJECT_CUSTOMERS

Line 158: select PPC.customer_id from pa_project_customers PPC

154:
155: cursor agreements is
156: select 1 from dual where not exists
157: (
158: select PPC.customer_id from pa_project_customers PPC
159: where PPC.project_id= x_project_id
160: and PPC.customer_bill_split > 0 /* Added for Bug2453912 */
161: and not exists
162: (

Line 1188: from pa_project_customers c2, pa_project_fundings f

1184: WHERE p.project_id = x_new_project_id
1185: /* Bug 727421 Performance Issue
1186: AND exists
1187: (select null
1188: from pa_project_customers c2, pa_project_fundings f
1189: where f.project_id = x_orig_project_id
1190: and f.agreement_id = a.agreement_id
1191: and c2.project_id = x_orig_project_id
1192: and c2.customer_bill_split = 100

Line 1200: from pa_project_customers c2

1196: (SELECT F.agreement_id from pa_summary_project_fundings F
1197: WHERE F.project_id = x_orig_project_id)
1198: AND exists
1199: (select null
1200: from pa_project_customers c2
1201: where c2.project_id = x_orig_project_id
1202: -- and nvl(c2.customer_bill_split,0) = 100
1203: -- FP_M changes
1204: -- If the project is implemented with Top Task Customer then