DBA Data[Home] [Help]

APPS.PAY_KR_YEA_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2763: hr_organization_information hoi

2759: select
2760: nvl(hoi.org_information1,'Y'),
2761: nvl(hoi.org_information2,'Y')
2762: from hr_all_organization_units hou,
2763: hr_organization_information hoi
2764: where hoi.organization_id = hou.organization_id
2765: and hou.business_group_id = p_business_group_id
2766: and hoi.org_information_context = 'KR_YEA_DON_CARRY_OVER_CALC';
2767:

Line 3511: hr_organization_information hoi

3507: cursor csr_get_smb_eligibility_flag(p_business_group_id in number) is
3508: select
3509: nvl(hoi.org_information1,'N')
3510: from hr_all_organization_units hou,
3511: hr_organization_information hoi
3512: where hoi.organization_id = hou.organization_id
3513: and hou.business_group_id = p_business_group_id
3514: and hoi.org_information_context = 'KR_YEA_ER_SMB_ELIGIBILITY_INFO';
3515: --