APPS.PAY_IE_LE_MIGRATE dependencies on HR_ORGANIZATION_INFORMATION

Line 27: hr_organization_information hoi

23: ,'Y','YN',
24: 'YYY','YYY'
25: ,'NN') migrated_flag
26: FROM hr_organization_units hou,
27: hr_organization_information hoi
28: WHERE hou.organization_id = l_bg_id
29: AND hoi.organization_id = hou.organization_id
30: AND hoi.org_information_context = 'IE_ORG_INFORMATION'
31: AND NVL(hoi.org_information11,'NN') <> 'NN';

Line 36: ,hr_organization_information hoi1

32:
33: CURSOR c_get_er_details(l_bg_id NUMBER,l_name VARCHAR2) IS
34: SELECT hou.organization_id,hou.name
35: FROM hr_organization_units hou
36: ,hr_organization_information hoi1
37: ,hr_organization_information hoi2
38: WHERE hou.organization_id = hoi1.organization_id
39: AND hou.organization_id = hoi2.organization_id
40: AND hou.business_group_id = l_bg_id

Line 37: ,hr_organization_information hoi2

33: CURSOR c_get_er_details(l_bg_id NUMBER,l_name VARCHAR2) IS
34: SELECT hou.organization_id,hou.name
35: FROM hr_organization_units hou
36: ,hr_organization_information hoi1
37: ,hr_organization_information hoi2
38: WHERE hou.organization_id = hoi1.organization_id
39: AND hou.organization_id = hoi2.organization_id
40: AND hou.business_group_id = l_bg_id
41: AND hoi1.org_information_context = 'CLASS'

Line 378: hr_organization_information hoi

374: ,'Y','YN',
375: 'YYY','YYY'
376: ,'NN') migrated_flag
377: FROM hr_organization_units hou,
378: hr_organization_information hoi
379: WHERE hou.organization_id = l_bg_id
380: AND hoi.organization_id = hou.organization_id
381: AND hoi.org_information_context = 'IE_ORG_INFORMATION'
382: AND (

Line 404: ,hr_organization_information hoi1

400: /* Cursor to fetch the migrated employers in the bg */
401: CURSOR c_get_er_details(l_bg_id number,l_name varchar2) IS
402: SELECT hou.organization_id,hou.name
403: FROM hr_organization_units hou
404: ,hr_organization_information hoi1
405: ,hr_organization_information hoi2
406: WHERE hou.organization_id = hoi1.organization_id
407: AND hou.organization_id = hoi2.organization_id
408: AND hou.business_group_id = l_bg_id

Line 405: ,hr_organization_information hoi2

401: CURSOR c_get_er_details(l_bg_id number,l_name varchar2) IS
402: SELECT hou.organization_id,hou.name
403: FROM hr_organization_units hou
404: ,hr_organization_information hoi1
405: ,hr_organization_information hoi2
406: WHERE hou.organization_id = hoi1.organization_id
407: AND hou.organization_id = hoi2.organization_id
408: AND hou.business_group_id = l_bg_id
409: AND hoi1.org_information_context = 'CLASS'