DBA Data[Home] [Help]

APPS.PAY_US_VALIDATE_INFO dependencies on HR_ORGANIZATION_UNITS

Line 32: from HR_ORGANIZATION_UNITS hou

28: and hoi1.org_information_context = 'CLASS'
29: and hoi1.org_information1 = 'HR_LEGAL'
30: and hoi1.org_information2 = 'Y')
31: and exists (select hou.organization_id
32: from HR_ORGANIZATION_UNITS hou
33: where hou.organization_id = hoi.organization_id
34: and hou.business_group_id = p_business_group_id);
35:
36:

Line 66: from HR_ORGANIZATION_UNITS hou

62: and hoi1.org_information_context = 'CLASS'
63: and hoi1.org_information1 = 'HR_ESTAB'
64: and hoi1.org_information2 = 'Y')
65: and exists (select hou.organization_id
66: from HR_ORGANIZATION_UNITS hou
67: where hou.organization_id = hoi.organization_id
68: and hou.business_group_id = p_business_group_id);
69:
70: begin

Line 110: from HR_ORGANIZATION_UNITS hou

106: and hoi.org_information3 = l_run
107: and hoi.org_information1 = 'Y'
108: and hoi.org_information_context = p_context
109: and exists (select hou.organization_id
110: from HR_ORGANIZATION_UNITS hou
111: where hou.organization_id = hoi.organization_id
112: and hou.business_group_id = p_business_group_id);
113:
114: