3107: ,1,240)
3108: FROM hr_organization_information hoi
3109: ,hr_organization_units hou
3110: ,hr_organization_units hou1
3111: ,hr_locations_all hla
3112: WHERE hoi.organization_id=p_organization_id
3113: AND hoi.org_information_context = DECODE(p_context,'PF','PER_IN_PF_DF','ESI','PER_IN_ESI_DF')
3114: AND hou.organization_id = DECODE (p_context,'PF',hoi.org_information8,'ESI',hoi.org_information2)
3115: AND hla.location_id=hou1.location_id
3793: ,1,240)
3794: FROM hr_organization_information hoi
3795: ,hr_organization_units hou
3796: ,hr_organization_units hou1
3797: ,hr_locations_all hla
3798: WHERE hoi.organization_id = p_organization_id
3799: AND hoi.org_information_context = 'PER_IN_PROF_TAX_DF'
3800: AND hou.organization_id = hoi.org_information2
3801: AND hla.location_id = hou1.location_id