APPS.PAY_FR_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 205: from hr_organization_information hoi

201: where assignment_action_id = p_assignment_action_id;
202: --
203: cursor csr_get_company is
204: select fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
205: from hr_organization_information hoi
206: where hoi.organization_id = g_estab_id
207: AND hoi.org_information_context = 'FR_ESTAB_INFO';
208: --
209: cursor csr_check_opm_effective(p_opm_id in number, p_date in date) is

Line 225: hr_organization_information ori,

221: --
222: cursor csr_get_org_info is
223: select substrb(NAME,1,60), substrb(hrl.meaning,1,20)
224: from hr_all_organization_units_tl org,
225: hr_organization_information ori,
226: hr_lookups hrl
227: where org.ORGANIZATION_ID = p_org_id
228: and org.language = userenv('LANG')
229: and org.ORGANIZATION_ID = ori.ORGANIZATION_ID

Line 269: FROM hr_organization_information hoi,

265: -- get replacement org paymeth from estab
266: BEGIN
267: SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
268: INTO p_org_method_id
269: FROM hr_organization_information hoi,
270: hr_all_organization_units org
271: WHERE hoi.organization_id = g_estab_id
272: AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
273: AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'

Line 300: FROM hr_organization_information hoi,

296: Close csr_get_company;
297:
298: SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
299: INTO p_org_method_id
300: FROM hr_organization_information hoi,
301: hr_all_organization_units org
302: WHERE hoi.organization_id = l_company_id
303: AND hoi.ORG_INFORMATION2 = l_gen_org_method_id_chr
304: AND hoi.org_information_context = 'FR_DYN_PAYMETH_MAPPING_INFO'