DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_API_PKG dependencies on GHG_ORGANIZATIONS_V

Line 527: FROM GHG_ORGANIZATIONS_V

523: ELSE
524: BEGIN
525: SELECT ghg_organization_id
526: INTO v_facility_id
527: FROM GHG_ORGANIZATIONS_V
528: WHERE ghg_organization_code = p_facility
529: AND allow_transactions = 'Y';
530:
531: EXCEPTION

Line 540: FROM GHG_ORGANIZATIONS_V

536:
537: BEGIN
538: SELECT ghg_organization_id
539: INTO v_facility_id
540: FROM GHG_ORGANIZATIONS_V
541: WHERE ghg_organization_code = p_facility
542: AND p_emission_from_date BETWEEN start_date AND nvl(end_date, GHG_utilities_pkg.end_date)
543: AND p_emission_to_date BETWEEN start_date AND nvl(end_date, GHG_utilities_pkg.end_date)
544: AND allow_transactions = 'Y';