DBA Data[Home] [Help]

APPS.PAY_NO_PAYPROC dependencies on HR_ORGANIZATION_INFORMATION

Line 131: , HR_ORGANIZATION_INFORMATION hoi1

127: and hsk.enabled_flag = 'Y'
128: and hsk.segment2 in (
129: select hoi2.org_information1
130: from HR_ORGANIZATION_UNITS o1
131: , HR_ORGANIZATION_INFORMATION hoi1
132: , HR_ORGANIZATION_INFORMATION hoi2
133: WHERE o1.business_group_id = pa1.business_group_id
134: and hoi1.organization_id = o1.organization_id
135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter

Line 132: , HR_ORGANIZATION_INFORMATION hoi2

128: and hsk.segment2 in (
129: select hoi2.org_information1
130: from HR_ORGANIZATION_UNITS o1
131: , HR_ORGANIZATION_INFORMATION hoi1
132: , HR_ORGANIZATION_INFORMATION hoi2
133: WHERE o1.business_group_id = pa1.business_group_id
134: and hoi1.organization_id = o1.organization_id
135: and hoi1.organization_id = to_number(PAY_NO_PAYPROC_UTILITY.get_parameter
136: (pa1.payroll_action_id,'LEGAL_EMPLOYER'))