DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EIN dependencies on HR_LOCATION_EXTRA_INFO

Line 977: CURSOR csr_location_info (p_location_id hr_location_extra_info.location_id%TYPE) IS

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';

Line 979: FROM hr_location_extra_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