APPS.JG_ZZ_RGRH_PKG dependencies on XLE_REGISTRATIONS_V

Line 59: Select legalauth_name into C_GR_TAX_OFFICE from xle_registrations_v

55: ELSIF (P_COUNTRY_CODE = 'GR') THEN
56: P_GR_FISCAL_COMPANY_VALUE := 'name';
57: P_GR_VAT_NUMBER := 'registration_number';
58: Begin
59: Select legalauth_name into C_GR_TAX_OFFICE from xle_registrations_v
60: where legal_entity_id= P_legal_entity_id and IDENTIFYING='Y';
61: select activity_code into C_GR_COMPANY_ACTIVITY
62: from xle_entity_profiles where legal_entity_id = P_legal_entity_id;
63: select issuing_authority_site_id into site_id from xle_registrations