APPS.PA_BILLING dependencies on PA_BILLING_EXTN_PARAMS_V

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 ||

Line 561: FROM pa_billing_extn_params_v;

557: it will be data issue */
558: BEGIN
559: SELECT default_cost_plan_type_id,default_rev_plan_type_id
560: INTO l_cost_plan_type_id,l_rev_plan_type_id
561: FROM pa_billing_extn_params_v;
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF g1_debug_mode = 'Y' THEN
565: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);

Line 565: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);

561: FROM pa_billing_extn_params_v;
562: EXCEPTION
563: WHEN OTHERS THEN
564: IF g1_debug_mode = 'Y' THEN
565: PA_MCB_INVOICE_PKG.log_message('Error from pa_billing_extn_params_v pa_billing.ccrev :'||SQLERRM);
566: END IF;
567: RAISE;
568: END;
569: /* till here */