APPS.GHR_SS_ASG_EIT SQL Statements

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

Line: 42

    select count(1)
    from   hr_organization_information oi
    where  oi.org_information_context = 'GHR_US_ORG_INFORMATION'
    and    oi.org_information1 is not null
    and    oi.org_information2 is not null
    and    oi.org_information3 is not null
    and    oi.org_information4 is not null
    and    oi.org_information5 is not null;

Line: 52

    select rowid
    from   PER_ASSIGNMENT_EXTRA_INFO
    where  assignment_extra_info_id = p_assignment_extra_info_id;

Line: 89

					                     p_operation    => 'insert',
					                     p_row_id	    => l_row_id);

Line: 93

       ghr_history_api.post_update_process;

Line: 138

    select count(1)
    from   hr_organization_information oi
    where  oi.org_information_context = 'GHR_US_ORG_INFORMATION'
    and    oi.org_information1 is not null
    and    oi.org_information2 is not null
    and    oi.org_information3 is not null
    and    oi.org_information4 is not null
    and    oi.org_information5 is not null;

Line: 148

    select rowid
    from   PER_ASSIGNMENT_EXTRA_INFO
    where  assignment_extra_info_id = p_assignment_extra_info_id;

Line: 186

					                     p_operation    => 'update',
					                     p_row_id	    => l_row_id);

Line: 190

       ghr_history_api.post_update_process;

Line: 202

    SELECT aei_information9,
           aei_information5,
           aei_information1,
           aei_information2,
	   aei_information3,
	   aei_information6
   FROM    PER_ASSIGNMENT_EXTRA_INFO
   WHERE   assignment_extra_info_id = p_assignment_extra_info_id;