1230: AND hoi2.ORG_INFORMATION_CONTEXT='DK_LEGAL_ENTITY_DETAILS' ;
1231:
1232: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
1233:
1234: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
1235: SELECT lei_information1
1236: FROM hr_location_extra_info
1237: WHERE location_id = p_location_id
1238: AND information_type='DK_LOCATION_INFO';
1232: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
1233:
1234: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
1235: SELECT lei_information1
1236: FROM hr_location_extra_info
1237: WHERE location_id = p_location_id
1238: AND information_type='DK_LOCATION_INFO';
1239:
1240: /* 9489806 */