APPS.AR_ARXGRL_XMLP_PKG SQL Statements

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

Line: 11

    SELECT substr(cp.user_concurrent_program_name,1,80)
    INTO   l_report_name
    FROM   FND_CONCURRENT_PROGRAMS_VL cp,
           FND_CONCURRENT_REQUESTS cr
    WHERE  cr.request_id = P_CONC_REQUEST_ID
    AND    cp.application_id = cr.program_application_id
    AND    cp.concurrent_program_id = cr.concurrent_program_id;

Line: 99

select max( segment.segment_num)
into   segment_num
from fnd_flex_value_sets vs,
     fnd_id_flex_segments segment,
     fnd_flex_validation_tables tab,
     fnd_segment_attribute_values qual
where segment.application_id = 222
and   segment.id_flex_code = 'RLOC'
and   segment.id_flex_num = location_structure_id
and   tab.flex_value_set_id = vs.flex_value_set_id
and   tab.application_table_name = 'AR_LOCATION_VALUES'
and   segment.application_id = qual.application_id
and   segment.id_flex_code = qual.id_flex_code
and   segment.id_flex_num  = qual.id_flex_num
and   segment.application_column_name = qual.application_column_name
and   segment.enabled_flag = 'Y'
and   qual.attribute_value = 'Y'
and   qual.segment_attribute_type = 'TAX_ACCOUNT';

Line: 145

select substrb(meaning ,1,50)
into  p_run_ordering_meaning
from  ar_lookups
where lookup_type = 'YES/NO'
and   lookup_code = p_run_ordering;

Line: 152

select substrb(meaning ,1,50)
into  p_run_grouping_meaning
from  ar_lookups
where lookup_type = 'YES/NO'
and   lookup_code = p_run_grouping;