3319: ,1,240)
3320: FROM hr_organization_information hoi
3321: ,hr_organization_units hou
3322: ,hr_organization_units hou1
3323: ,hr_locations_all hla
3324: WHERE hoi.organization_id=p_organization_id
3325: AND hoi.org_information_context = DECODE(p_context,'PF','PER_IN_PF_DF','ESI','PER_IN_ESI_DF')
3326: AND hou.organization_id = DECODE (p_context,'PF',hoi.org_information8,'ESI',hoi.org_information2)
3327: AND hla.location_id=hou1.location_id
4013: ,1,240)
4014: FROM hr_organization_information hoi
4015: ,hr_organization_units hou
4016: ,hr_organization_units hou1
4017: ,hr_locations_all hla
4018: WHERE hoi.organization_id = p_organization_id
4019: AND hoi.org_information_context = 'PER_IN_PROF_TAX_DF'
4020: AND hou.organization_id = hoi.org_information2
4021: AND hla.location_id = hou1.location_id