APPS.HR_NEW_USER_REG_SS dependencies on HR_ORGANIZATION_INFORMATION

Line 533: from hr_organization_information oi,

529: l_bg_id varchar2(20);
530:
531: cursor struct_code_csr(bg_id varchar2) is
532: select fs.id_flex_structure_code people_grp_f_struct_code
533: from hr_organization_information oi,
534: fnd_id_flex_structures fs
535: where oi.organization_id = bg_id
536: and oi.org_information_context = 'Business Group Information'
537: and oi.org_information5 = fs.id_flex_num(+)