APPS.PAY_SA_USER_FUNCTION SQL Statements

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

Line: 77

    select  HOI2.org_information1
    from    hr_organization_units HOU
            ,hr_organization_information HOI1
            ,hr_organization_information HOI2
            ,hr_soft_coding_keyflex HSCK
            ,per_all_assignments_f PAA
    where   HOU.business_group_id = p_business_group_id
    and    trunc(p_date_earned) between HOU.date_from and nvl(HOU.date_to,
	to_date('4712/12/31','YYYY/MM/DD'))
    and   HOU.organization_id = HOI1.organization_id
    and   HOI1.org_information_context = 'CLASS'
    and   HOI1.org_information1 = 'HR_LEGAL'
    and   HOI1.organization_id = HOI2.organization_id
    and   PAA.assignment_id = p_assignment_id
    and   trunc(p_date_earned) between PAA.effective_start_date and PAA.effective_end_date
    and   PAA.soft_coding_keyflex_id = HSCK.soft_coding_keyflex_id
    and   HSCK.id_flex_num = 20
    and   decode(HSCK.id_flex_num,20,to_number(HSCK.segment1),-9999) = HOU.organization_id
    and   HOI2.org_information_context = 'SA_GOSI_REFERENCE_FORMULA';