DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYRS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 305: from hr_all_organization_units hou,

301: --
302: cursor csr_get_smb_eligibility_flag(p_business_group_id in number) is
303: select
304: nvl(hoi.org_information1,'N')
305: from hr_all_organization_units hou,
306: hr_organization_information hoi
307: where hoi.organization_id = hou.organization_id
308: and hou.business_group_id = p_business_group_id
309: and hoi.org_information_context = 'KR_YEA_ER_SMB_ELIGIBILITY_INFO';