APPS.PAY_NO_PAYPROC dependencies on HR_ORGANIZATION_UNITS

Line 122: from HR_ORGANIZATION_UNITS o1

118: and hsk.SOFT_CODING_KEYFLEX_ID = paf.SOFT_CODING_KEYFLEX_ID
119: and hsk.enabled_flag = 'Y'
120: and hsk.segment2 in (
121: select hoi2.org_information1
122: from HR_ORGANIZATION_UNITS o1
123: , HR_ORGANIZATION_INFORMATION hoi1
124: , HR_ORGANIZATION_INFORMATION hoi2
125: WHERE o1.business_group_id = ppa.business_group_id
126: and hoi1.organization_id = o1.organization_id

Line 202: from HR_ORGANIZATION_UNITS o1

198: and hsk.SOFT_CODING_KEYFLEX_ID = asg.SOFT_CODING_KEYFLEX_ID
199: and hsk.enabled_flag = 'Y'
200: and hsk.segment2 in (
201: select hoi2.org_information1
202: from HR_ORGANIZATION_UNITS o1
203: , HR_ORGANIZATION_INFORMATION hoi1
204: , HR_ORGANIZATION_INFORMATION hoi2
205: WHERE o1.business_group_id = pa1.business_group_id
206: and hoi1.organization_id = o1.organization_id

Line 281: from HR_ORGANIZATION_UNITS o1

277: and hsk.SOFT_CODING_KEYFLEX_ID = asg.SOFT_CODING_KEYFLEX_ID
278: and hsk.enabled_flag = 'Y'
279: and hsk.segment2 in (
280: select hoi2.org_information1
281: from HR_ORGANIZATION_UNITS o1
282: , HR_ORGANIZATION_INFORMATION hoi1
283: , HR_ORGANIZATION_INFORMATION hoi2
284: WHERE o1.business_group_id = pa1.business_group_id
285: and hoi1.organization_id = o1.organization_id

Line 328: from HR_ORGANIZATION_UNITS o1

324: and paa.assignment_id = paf.assignment_id
325: and hsk.SOFT_CODING_KEYFLEX_ID = paf.SOFT_CODING_KEYFLEX_ID
326: and hsk.segment2 in (
327: select hoi2.org_information1
328: from HR_ORGANIZATION_UNITS o1
329: , HR_ORGANIZATION_INFORMATION hoi1
330: , HR_ORGANIZATION_INFORMATION hoi2
331: WHERE o1.business_group_id = ppa.business_group_id
332: and hoi1.organization_id = o1.organization_id