APPS.HR_DELTA_SYNC_MESSAGES dependencies on PER_ORG_MANAGER_V

Line 2143: p_person_id per_org_manager_v.person_id%type;

2139: p_bg_id hr_all_organization_units.business_group_id%type;
2140: p_dept_id hr_all_organization_units.organization_id%type;
2141: p_eff_date date;
2142: p_loc_id hr_all_organization_units.location_id%type;
2143: p_person_id per_org_manager_v.person_id%type;
2144: p_full_name per_org_manager_v.full_name%type;
2145: p_bg_name hr_all_organization_units.name%type;
2146: p_eff_status varchar2(10);
2147: p_effective_date date default sysdate;

Line 2144: p_full_name per_org_manager_v.full_name%type;

2140: p_dept_id hr_all_organization_units.organization_id%type;
2141: p_eff_date date;
2142: p_loc_id hr_all_organization_units.location_id%type;
2143: p_person_id per_org_manager_v.person_id%type;
2144: p_full_name per_org_manager_v.full_name%type;
2145: p_bg_name hr_all_organization_units.name%type;
2146: p_eff_status varchar2(10);
2147: p_effective_date date default sysdate;
2148: l_params WF_PARAMETER_LIST_T;

Line 2169: ,per_org_manager_v mgr,hr_organization_information hrorg

2165: mgr.person_id,
2166: mgr.full_name,
2167: org.last_update_date
2168: from hr_all_organization_units org
2169: ,per_org_manager_v mgr,hr_organization_information hrorg
2170: where org.business_group_id = mgr.business_group_id(+)
2171: and org.organization_id = mgr.organization_id(+)
2172: and hrorg.organization_id = org.organization_id
2173: and hrorg.org_information1 = 'HR_ORG'

Line 2214: ,per_org_manager_v mgr,hr_organization_information hrorg

2210: mgr.person_id,
2211: mgr.full_name,
2212: org.last_update_date
2213: from hr_all_organization_units org
2214: ,per_org_manager_v mgr,hr_organization_information hrorg
2215: where org.business_group_id = mgr.business_group_id(+)
2216: and org.organization_id = mgr.organization_id(+)
2217: and hrorg.organization_id = org.organization_id
2218: and hrorg.org_information1 = 'HR_ORG'