APPS.PA_BILLING dependencies on PA_BILLING_ASSIGNMENTS

Line 183: from pa_billing_extensions be, pa_billing_assignments bea -- , Commented for bug 3643409

179: bea.billing_extension_id be_id, bea.top_task_id task_id,
180: decode(be.amount_reqd_flag, 'Y', nvl(bea.amount, 0), 0) amt,
181: decode(be.percentage_reqd_flag, 'Y', nvl(bea.percentage, 0), 0)
182: percent
183: from pa_billing_extensions be, pa_billing_assignments bea -- , Commented for bug 3643409
184: -- pa_projects p Commented for bug 3643409
185: where -- p.project_id = x_project_id Commented for bug 3643409
186: -- and Commented for bug 3643409
187: to_date(x_rev_or_bill_date,'YYYY/MM/DD') between be.start_date_active and nvl(be.end_date_active,to_date(x_rev_or_bill_date,'YYYY/MM/DD')) --Added the condition for bug 8206153, added nvl for bug 8228460

Line 320: -- view pa_billing_extn_params_v ( all the newly added columns in pa_billing_assignments table)

316: IF (task_rec.tpid IS NULL) THEN
317: -- This will be the case for Project Level funding and Project
318: -- Level assignment.
319: -- Do not have to change this stmt for MCB, because user is going to select from the
320: -- view pa_billing_extn_params_v ( all the newly added columns in pa_billing_assignments table)
321:
322: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
323: get_rec.proc_name || '(' || to_char(x_project_id) ||
324: ','''',''' || x_calling_process ||