DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EHOL dependencies on HR_LOCATION_EXTRA_INFO

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

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

Line 1236: FROM hr_location_extra_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 */