DBA Data[Home] [Help]

APPS.GHG_EMISSION_RATES_PKG dependencies on GHG_ORGANIZATIONS

Line 405: from GHG_organizations fac

401: WHERE fnd.APPLICATION_ID =800
402: AND fnd.DESCRIPTIVE_FLEXFIELD_NAME='Address Location'
403: AND fnd.DESCRIPTIVE_FLEX_CONTEXT_CODE = hr.style
404: AND exists (select 1
405: from GHG_organizations fac
406: where fac.ghg_organization_id = x_facility_id
407: and fac.location_id = hr.location_id)
408: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
409: EXCEPTION

Line 515: from GHG_organizations fac

511: WHERE fnd.APPLICATION_ID =800
512: AND fnd.DESCRIPTIVE_FLEXFIELD_NAME='Address Location'
513: AND fnd.DESCRIPTIVE_FLEX_CONTEXT_CODE = hr.style
514: AND exists (select 1
515: from GHG_organizations fac
516: where fac.ghg_organization_id = x_facility_id
517: and fac.location_id = hr.location_id)
518: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
519: EXCEPTION

Line 748: from GHG_organizations fac

744: WHERE fnd.APPLICATION_ID =800
745: AND fnd.DESCRIPTIVE_FLEXFIELD_NAME='Address Location'
746: AND fnd.DESCRIPTIVE_FLEX_CONTEXT_CODE = hr.style
747: AND exists (select 1
748: from GHG_organizations fac
749: where fac.ghg_organization_id = x_facility_id
750: and fac.location_id = hr.location_id)
751: AND upper(end_user_column_name) = fnd_profile.value('GHG_FACTOR_BREAK_REGION');
752: EXCEPTION