DBA Data[Home] [Help]

APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on HR_ORGANIZATION_UNITS

Line 147: FROM hr_organization_units hou

143: IS
144: CURSOR c_tan_number
145: IS
146: SELECT hou.organization_id
147: FROM hr_organization_units hou
148: ,hr_organization_information hoi
149: WHERE hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
150: AND hoi.organization_id = hou.organization_id
151: AND hoi.org_information_context = 'PER_IN_INCOME_TAX_DF'

Line 205: FROM hr_organization_units hou

201: IS
202: CURSOR c_tan_number
203: IS
204: SELECT hoi.org_information1
205: FROM hr_organization_units hou
206: ,hr_organization_information hoi
207: ,per_assignments_f asg
208: ,hr_soft_coding_keyflex scl
209: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id