APPS.PAY_GB_P46V6_EDI_BIP SQL Statements

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

Line: 9

    Select nvl(upper(substr(addr.action_information5,1,35)),' '),
           nvl(upper(substr(addr.action_information6,1,35)),' '),
           nvl(upper(substr(addr.action_information7,1,35)),' '),
           nvl(upper(addr.action_information8),' ')
    From pay_action_information addr
    where  addr.action_context_id = p_assignment_action_id
    and    addr.action_information_category = 'ADDRESS DETAILS'
    and    addr.action_context_type = 'AAP';