59: -- Private types
60: ------------------------------------------------------------------------
61: TYPE autoacc_rec_type IS RECORD
62: (
63: type ra_account_defaults.type%type,
64: segment ra_account_default_segments.segment%type,
65: table_name ra_account_default_segments.table_name%type,
66: constant ra_account_default_segments.constant%type
67: );
921: upper(ads.table_name) table_name,
922: ads.constant constant
923: FROM
924: ra_account_default_segments ads,
925: ra_account_defaults ad
926: WHERE ad.gl_default_id = ads.gl_default_id
927: AND ad.org_id = NVL(arp_global.sysparam.org_id, ad.org_id)
928: AND ad.type in
929: (