973: AND hoi2.ORG_INFORMATION_CONTEXT='DK_LEGAL_ENTITY_DETAILS' ;
974:
975: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
976:
977: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
978: SELECT lei_information1
979: FROM hr_location_extra_info
980: WHERE location_id = p_location_id
981: AND information_type='DK_LOCATION_INFO';
975: rg_Legal_Emp_Details csr_Legal_Emp_Details%rowtype;
976:
977: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS
978: SELECT lei_information1
979: FROM hr_location_extra_info
980: WHERE location_id = p_location_id
981: AND information_type='DK_LOCATION_INFO';
982: /* 9489806 */
983: CURSOR csr_asg_payroll