APPS.HR_FULL_SYNC_MESSAGES dependencies on PER_ORG_MANAGER_V

Line 879: p_person_id per_org_manager_v.person_id%type;

875: p_bg_id hr_all_organization_units.business_group_id%type;
876: p_dept_id hr_all_organization_units.organization_id%type;
877: p_eff_date date;
878: p_loc_id hr_all_organization_units.location_id%type;
879: p_person_id per_org_manager_v.person_id%type;
880: p_full_name per_org_manager_v.full_name%type;
881: p_bg_name hr_all_organization_units.name%type;
882: p_eff_status varchar2(10);
883: p_effective_date date default sysdate;

Line 880: p_full_name per_org_manager_v.full_name%type;

876: p_dept_id hr_all_organization_units.organization_id%type;
877: p_eff_date date;
878: p_loc_id hr_all_organization_units.location_id%type;
879: p_person_id per_org_manager_v.person_id%type;
880: p_full_name per_org_manager_v.full_name%type;
881: p_bg_name hr_all_organization_units.name%type;
882: p_eff_status varchar2(10);
883: p_effective_date date default sysdate;
884:

Line 897: ,per_org_manager_v mgr,hr_organization_information hrorg

893: org.location_id,
894: mgr.person_id,
895: mgr.full_name
896: from hr_all_organization_units org
897: ,per_org_manager_v mgr,hr_organization_information hrorg
898: where org.business_group_id = mgr.business_group_id(+)
899: and org.organization_id = mgr.organization_id(+)
900: and hrorg.organization_id = org.organization_id
901: and hrorg.org_information1 = 'HR_ORG'