APPS.JG_ZZ_RGRH_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

    SELECT etbp.party_id INTO x_me_party_id FROM XLE_ETB_PROFILES etbp
    WHERE etbp.main_establishment_flag = 'Y'
    AND etbp.legal_entity_id = P_LEGAL_ENTITY_ID;

Line: 59

    Select legalauth_name into C_GR_TAX_OFFICE from xle_registrations_v
    where legal_entity_id= P_legal_entity_id and IDENTIFYING='Y';

Line: 61

    select activity_code into C_GR_COMPANY_ACTIVITY
    from xle_entity_profiles where legal_entity_id = P_legal_entity_id;

Line: 63

    select issuing_authority_site_id into site_id from xle_registrations
    where  source_id= P_LEGAL_ENTITY_ID and  source_table='XLE_ENTITY_PROFILES' and IDENTIFYING_FLAG='Y';

Line: 65

    select SUBSTR(address1,1,30) || country into C_GR_TAX_AREA from hz_locations
    where location_id = ( select location_id from hz_party_sites where party_site_id = site_id) ;