eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DELTA_SYNC_MESSAGES dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2139: p_bg_id hr_all_organization_units.business_group_id%type;

2135: procedure hr_organizaton_delta_sync(errbuf OUT NOCOPY VARCHAR2
2136: ,retcode OUT NOCOPY VARCHAR2
2137: ,p_party_site_id in NUMBER)
2138: is
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;

Line 2140: p_dept_id hr_all_organization_units.organization_id%type;

2136: ,retcode OUT NOCOPY VARCHAR2
2137: ,p_party_site_id in NUMBER)
2138: is
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;

Line 2142: p_loc_id hr_all_organization_units.location_id%type;

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

Line 2145: p_bg_name hr_all_organization_units.name%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;
2149: p_last_update_date date;

Line 2168: from hr_all_organization_units org

2164: org.location_id,
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

Line 2213: from hr_all_organization_units org

2209: org.location_id,
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

Line 2429: from hr_all_organization_units org

2425: else date_to end,
2426: case when date_to is null then 'ACTIVE'
2427: else 'INACTIVE' end,
2428: last_update_date
2429: from hr_all_organization_units org
2430: where last_update_date > p_max_run_date
2431: and org.organization_id = org.business_group_id
2432: and (business_group_id) not in (select business_group_id
2433: from hr_bgrp_delta_sync bg

Line 2456: from hr_all_organization_units org

2452: else date_to end,
2453: case when date_to is null then 'ACTIVE'
2454: else 'INACTIVE' end,
2455: last_update_date
2456: from hr_all_organization_units org
2457: where business_group_id = p_bgrp_id
2458: and business_group_id = organization_id
2459: and last_update_date >= p_lstupd_date;
2460: