[Home] [Help]
1319: period_year,
1320: period_num,
1321: quarter_num
1322: from gl_period_statuses ps,
1323: ar_system_parameters p
1324: where ps.set_of_books_id = p.set_of_books_id
1325: and application_id = 222
1326: and adjustment_period_flag = 'N'
1327: and trunc(gl_date) between start_date and end_date
2689: ELSE
2690: mo_utils.get_default_ou(l_default_org_id,l_default_ou_name,l_count);
2691: IF l_default_org_id is null then
2692: begin
2693: select min(org_id) into l_default_org_id from ar_system_parameters;
2694: end;
2695: end if;
2696: END IF;
2697:
2702:
2703: l_gr := ar_mo_global_cache.get_org_attributes(nvl(p_org_id,l_default_org_id));
2704:
2705: /* --------------------------------------------------------------------------------
2706: Begin populate all attribute of global variable, sysparm of ar_system_parameters%rowtype
2707: from Local Variable, l_gr, retieved from cache for the passed org
2708: --------------------------------------------------------------------------------- */
2709: /* enable_debug;
2710: enable_file_debug('/sqlcom/out/modev116','artestlog'||userenv('SESSIONID')||'.log');
2866: ARP_STANDARD.sysparm.min_refund_amount := l_gr.min_refund_amount;
2867: ARP_STANDARD.sysparm.create_detailed_dist_flag := l_gr.create_detailed_dist_flag;
2868:
2869: /* --------------------------------------------------------------------------------
2870: End populate all attribute of global variable, sysparm of ar_system_parameters%rowtype
2871: from Local Variable, l_gr, retieved from cache for the passed org
2872: --------------------------------------------------------------------------------- */
2873: if ARP_STANDARD.sysparm.from_postal_code is null
2874: then