DBA Data[Home] [Help]

APPS.GHG_UTILITIES_PKG dependencies on GHG_UTILITIES_PKG

Line 1: PACKAGE BODY GHG_UTILITIES_PKG AS

1: PACKAGE BODY GHG_UTILITIES_PKG AS
2: /*$Header: ghgutilb.pls 120.4.12020000.2 2012/10/17 04:40:41 sasuren ship $ */
3:
4: FUNCTION emissions_exist (x_invoice_id NUMBER) RETURN VARCHAR2 IS
5:

Line 440: trunc(nvl(end_date_active, GHG_UTILITIES_PKG.end_date ))

436: (SELECT LOOKUP_CODE
437: FROM FND_LOOKUPS
438: WHERE lookup_type = 'GHG_EMISSION_LINE_TYPES'
439: AND trunc(sysdate) between trunc(start_date_active) and
440: trunc(nvl(end_date_active, GHG_UTILITIES_PKG.end_date ))
441: );
442:
443: select amount/vl_invoice_total
444: into vl_inv_perc

Line 474: END GHG_UTILITIES_PKG;

470:
471: END;
472:
473:
474: END GHG_UTILITIES_PKG;