function CP_1Formula return Number is
Vperiod_name VARCHAR2(40);
begin
declare
per_start_cre number;
per_start_deb number;
begin
Vperiod_name := TO_CHAR(TO_DATE(SUBSTR(:P_START_DATE,1,10),'yyyy/mm/dd'),'MON-YYYY');
get_start_balances(Vperiod_name,
per_start_deb,
per_start_cre);
return(per_start_deb);
end;
RETURN NULL;
end;
Kind Regards

Syed Massi Uddin

IT Manager
Sharief Group
PO Box: 4446
Dubai
UAE
Email: [Email address protected]
Mob: +971 50 7594187
Tel: +971 4 336 2224
Fax: +971 4 336 2333


CONFIDENTIALITY: The contents of this email (and of any attachments) are
intended for the designated recipient only, may be confidential and may
contain copyright material of Mohd Sharief & Bros or third parties.
You may only reproduce or distribute the contents if you are the designated
recipient of this e-mail, and then only for the purposes that we have
expressly authorised, or which are clearly implicit from the context
in which we have sent it to you. This authorisation is limited to those
purposes, and may be revoked by us at any time.

Fax:- 04-3362333

Oracle LazyDBA home page