DBA Data[Home] [Help]

APPS.PAY_IN_PROF_TAX_PKG dependencies on HR_ORGANIZATION_UNITS

Line 32: , hr_organization_units hou

28:
29: CURSOR csr_state (p_pt_org IN VARCHAR2) IS
30: select hoi.org_information4
31: from hr_organization_information hoi
32: , hr_organization_units hou
33: where hoi.organization_id = p_pt_org
34: and hoi.organization_id = hou.organization_id
35: and hou.business_group_id = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
36: and org_information_context ='PER_IN_PROF_TAX_DF';