APPS.PAY_NO_SSB_CODES SQL Statements

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

Line: 9

select pet.element_type_id,
       pxi.eei_information1 input_value_id,
       prr.run_result_id,
       pxi.eei_information2 ssb_code,
       pxi.eei_information3 add_detail
from
pay_assignment_actions paa,
pay_run_results prr,
pay_element_types_f pet,
pay_element_type_extra_info pxi
where
paa.assignment_action_id =p_assignment_action_id
and paa.assignment_action_id = prr.assignment_action_id
and prr.element_type_id = pet.element_type_id
and p_effective_date between pet.effective_start_date and pet.effective_end_date
and pet.element_type_id = pxi.element_type_id
and pxi.eei_information_category = 'NO_SSB_CODES'
and pxi.eei_information3 = 'SUMMARY'
UNION
select pet.element_type_id,
       pxi.eei_information4 input_value_id,
       prr.run_result_id,
       pxi.eei_information3 ssb_code,
       'AMOUNT' add_detail
from
pay_assignment_actions paa,
pay_run_results prr,
pay_element_types_f pet,
pay_element_type_extra_info pxi
where
paa.assignment_action_id =p_assignment_action_id
and paa.assignment_action_id = prr.assignment_action_id
and prr.element_type_id = pet.element_type_id
and p_effective_date between pet.effective_start_date and pet.effective_end_date
and pet.element_type_id = pxi.element_type_id
and to_char(p_effective_date,'YYYY') between pxi.eei_information1 and nvl(pxi.eei_information2,'4712')
and pxi.eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING'
order by ssb_code;

Line: 145

    g_ssb_codes_table.delete(l_cache_index);

Line: 165

select row_low_range_or_name
from pay_user_tables put,
pay_user_rows_f pur,
fnd_sessions fs
where
put.user_table_name ='NO_SSB_CODE_RULES'
and put.user_table_id = pur.user_table_id
and fs.session_id = userenv('sessionid')
and fs.effective_date between pur.effective_start_date
and pur.effective_end_date;

Line: 177

SELECT to_number (result_value)
FROM pay_run_result_values
WHERE run_result_id = p_run_result_id
AND input_value_id = p_input_value_id;

Line: 308

	g_ssb_codes_table.delete(l_cache_index);