APPS.PER_RO_AEI_INFO SQL Statements

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

Line: 9

select min(effective_start_date),max(effective_end_date) from per_all_assignments_f where ASSIGNMENT_ID=P_ASSIGNMENT_ID;

Line: 13

select min(effective_start_date) from per_contracts_f pcf where contract_id=P_CONTRACT_ID;

Line: 22

	select contract_id from per_all_assignments_f paaf
	where paaf.assignment_id=p_assignment_id
	and paaf.effective_end_date = l_assignment_end_date;

Line: 87

select 'x' from per_assignment_extra_info
where information_type = p_information_type
and  aei_information_category = p_aei_information_category
and assignment_id=p_assignment_id;

Line: 125

 procedure UPDATE_RO_ASSGT_EXTRA_INFO(

 P_ASSIGNMENT_EXTRA_INFO_ID   in   NUMBER,
 p_aei_information_category   in   VARCHAR2,
 P_AEI_INFORMATION1           in   varchar2
 )
 as
	cursor csr_get_assignment_id IS
	select assignment_id from per_assignment_extra_info
	where aei_information_category = p_aei_information_category
	and ASSIGNMENT_EXTRA_INFO_ID = P_ASSIGNMENT_EXTRA_INFO_ID;

Line: 140

	l_proc:=  g_package||'UPDATE_RO_ASSGT_EXTRA_INFO';

Line: 161

END UPDATE_RO_ASSGT_EXTRA_INFO; --end procedure update