APPS.JG_ZZ_RGRH_PKG dependencies on XLE_REGISTRATIONS

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

Line 63: select issuing_authority_site_id into site_id from xle_registrations

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
64: where source_id= P_LEGAL_ENTITY_ID and source_table='XLE_ENTITY_PROFILES' and IDENTIFYING_FLAG='Y';
65: select SUBSTR(address1,1,30) || country into C_GR_TAX_AREA from hz_locations
66: where location_id = ( select location_id from hz_party_sites where party_site_id = site_id) ;
67: Exception