APPS.PAY_CA_ARCHIVE_UTILS SQL Statements

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

Line: 17

select fai.value
from 	ff_archive_items fai,
	ff_database_items fdi
where fai.context1 = p_archive_action_id
and 	fai.user_entity_id=fdi.user_entity_id
and 	fdi.user_name=p_db_name;

Line: 67

select fai.value
from 	ff_archive_items 	fai,
	ff_database_items fdi,
	ff_archive_item_contexts fac,
      ff_contexts		ffc
where fai.context1  =  p_asg_act_id
and   fai.archive_item_id = fac.archive_item_id
and   fai.user_entity_id  = fdi.user_entity_id
and 	fdi.user_name = p_db_name
and   fac.context   = p_context
and   fac.context_id = ffc.context_id
and   ffc.context_name = p_context_name;