APPS.HR_FULL_SYNC_MESSAGES dependencies on HR_ALL_ORGANIZATION_UNITS

Line 875: p_bg_id hr_all_organization_units.business_group_id%type;

871: /*Procedure to extract the organization data for full synch process begins*/
872: procedure hr_organizaton_full_sync(errbuf OUT NOCOPY VARCHAR2
873: ,retcode OUT NOCOPY VARCHAR2)
874: is
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;

Line 876: p_dept_id hr_all_organization_units.organization_id%type;

872: procedure hr_organizaton_full_sync(errbuf OUT NOCOPY VARCHAR2
873: ,retcode OUT NOCOPY VARCHAR2)
874: is
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;

Line 878: p_loc_id hr_all_organization_units.location_id%type;

874: is
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);

Line 881: p_bg_name hr_all_organization_units.name%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:
885: cursor fet_org_fsync is

Line 896: from hr_all_organization_units org

892: org.name,
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