APPS.PA_BILLING dependencies on PA_BILLING_ASSIGNMENTS

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

119: bea.billing_extension_id be_id, bea.top_task_id task_id,
120: decode(be.amount_reqd_flag, 'Y', nvl(bea.amount, 0), 0) amt,
121: decode(be.percentage_reqd_flag, 'Y', nvl(bea.percentage, 0), 0)
122: percent
123: from pa_billing_extensions be, pa_billing_assignments bea -- , Commented for bug 3643409
124: -- pa_projects p Commented for bug 3643409
125: where -- p.project_id = x_project_id Commented for bug 3643409
126: -- and Commented for bug 3643409
127: bea.active_flag = 'Y'

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

255: IF (task_rec.tpid IS NULL) THEN
256: -- This will be the case for Project Level funding and Project
257: -- Level assignment.
258: -- Do not have to change this stmt for MCB, because user is going to select from the
259: -- view pa_billing_extn_params_v ( all the newly added columns in pa_billing_assignments table)
260:
261: proc_stmt := 'declare s varchar2(240):=null; begin ' ||
262: get_rec.proc_name || '(' || to_char(x_project_id) ||
263: ','''',''' || x_calling_process ||