APPS.PAY_NL_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 78: from hr_organization_information hoi

74:
75: Cursor c_retro_method(p_business_group_id in number)
76: is
77: Select hoi.org_information2
78: from hr_organization_information hoi
79: where hoi.org_information_context = 'NL_BG_INFO'
80: and hoi.organization_id = p_business_group_id;
81:
82:

Line 193: FROM hr_organization_information

189: FUNCTION get_object_group_type RETURN VARCHAR2 IS
190: --
191: CURSOR get_type IS
192: SELECT org_information6
193: FROM hr_organization_information
194: WHERE organization_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
195: AND org_information_context = 'NL_BG_INFO';
196: --
197: l_type VARCHAR2(20);