74: into x_dummy
75: from sys.dual
76: where not exists
77: ( select 1
78: from pa_billing_assignments
79: where billing_extension_id = x_bill_extension_id );
80: --
81: x_return_status := 0;
82: --
103: --
104: select 1 into x_dummy
105: from sys.dual
106: where not exists ( select 1
107: from pa_billing_assignments
108: where billing_extension_id = x_bill_extension_id
109: and billing_assignment_id in
110: ( select billing_assignment_id
111: from pa_events ));