[Home] [Help]
APPS.PER_ROL_BUS dependencies on HR_ORGANIZATION_INFORMATION
Line 28: from hr_organization_information hoi
24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select null
28: from hr_organization_information hoi
29: , per_roles rol
30: , per_people_f per
31: where rol.role_id = p_role_id
32: and per.person_id = rol.person_id
Line 444: from hr_organization_information hoi
440: l_rep_jgr varchar2(30);
441: --
442: cursor csr_rep_jgr is
443: select 'X'
444: from hr_organization_information hoi
445: where org_information1 = to_char(p_job_group_id)
446: and organization_id = p_organization_id;
447: --
448: begin