DBA Data[Home] [Help]

APPS.PAY_KR_YEA_REPORTS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 26: hr_organization_information hoi

22: select decode(p_report_name,'PAYKRYRS',hoi.org_information1
23: ,'PAYKRYTR',hoi.org_information2
24: ,'PAYKRYLG',hoi.org_information3)
25: from hr_all_organization_units hou,
26: hr_organization_information hoi
27: where hoi.organization_id = hou.organization_id
28: and hou.business_group_id= p_bus_grp_id
29: and hoi.org_information_context = 'KR_YEA_REPORT_TEMPLATE_INFO';
30: --