APPS.HR_FULL_SYNC_MESSAGES dependencies on PER_ORG_MANAGER_V

Line 880: p_person_id per_org_manager_v.person_id%type;

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

Line 881: p_full_name per_org_manager_v.full_name%type;

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

Line 898: ,per_org_manager_v mgr,hr_organization_information hrorg

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