APPS.PAY_IE_LE_MIGRATE dependencies on HR_ORGANIZATION_UNITS

Line 26: FROM hr_organization_units hou,

22: decode(hoi.org_information11,'YY','YY'
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'

Line 35: FROM hr_organization_units hou

31: AND NVL(hoi.org_information11,'NN') <> 'NN';
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

Line 377: FROM hr_organization_units hou,

373: decode(hoi.org_information11,'YY','YY'
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'

Line 403: FROM hr_organization_units hou

399:
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