DBA Data[Home] [Help]

APPS.PAY_FI_TC_DP_UPLOAD dependencies on HR_ORGANIZATION_UNITS

Line 158: from HR_ORGANIZATION_UNITS o1

154: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
155: AND SCL.ENABLED_FLAG = 'Y'
156: AND SCL.SEGMENT2 in
157: ( select to_char(hoi1.organization_id)
158: from HR_ORGANIZATION_UNITS o1
159: , HR_ORGANIZATION_INFORMATION hoi1
160: , HR_ORGANIZATION_INFORMATION hoi2
161: , HR_ORGANIZATION_INFORMATION hoi3
162: , HR_ORGANIZATION_INFORMATION hoi4

Line 198: from HR_ORGANIZATION_UNITS o1

194: AND fnd_date.canonical_to_date(p_effective_date) between PAP.EFFECTIVE_START_DATE and PAP.EFFECTIVE_END_DATE
195: AND SCL.ENABLED_FLAG = 'Y'
196: AND SCL.SEGMENT2 in
197: ( select to_char(hoi1.organization_id)
198: from HR_ORGANIZATION_UNITS o1
199: , HR_ORGANIZATION_INFORMATION hoi1
200: , HR_ORGANIZATION_INFORMATION hoi2
201: , HR_ORGANIZATION_INFORMATION hoi3
202: , HR_ORGANIZATION_INFORMATION hoi4