APPS.PAY_PAYHKMPF_XMLP_PKG SQL Statements

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

Line: 97

select substr(hoi.org_information2, 1, 52)                      scheme_name,
       substr(hoi.org_information1, 1, 17)                      scheme_registration_no,
       substr(hoi.org_information5, 1, 32)                      contact_person,
       substr(hoi.org_information6, 1, 17)                      employer_participation_no
into   cp_scheme_name,
       cp_scheme_reg_number,
       cp_contact,
       cp_participation_no
from hr_organization_information  hoi
where hoi.org_information20 = p_scheme_id
and   hoi.org_information_context = 'HK_MPF_SCHEMES';

Line: 119

select substr(hou.name, 1, 32)                                  employer_name,
       hl.address_line_1 ||
       decode(hl.address_line_2, null, null, ', ' || hl.address_line_2) ||
       decode(hl.address_line_3, null, null, ', ' || hl.address_line_3) ||
       decode(hl.town_or_city, null, null, ', '   || hl.town_or_city) address,
       substr(hl.telephone_number_1, 1, 32)                     telephone_number
into   cp_employer_name,
       cp_address,
       cp_telephone_no
from hr_organization_units        hou,
     hr_locations                 hl
where hou.organization_id = p_legal_employer_id
and   hou.location_id     = hl.location_id;