APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 105: FROM hr_all_organization_units org

101: cv_business_group_id NUMBER
102: )
103: IS
104: SELECT NAME
105: FROM hr_all_organization_units org
106: WHERE org.organization_id = cv_start_org_id
107: AND business_group_id = p_business_group_id;
108: --
109: CURSOR c_pos_stru_name (

Line 2328: from hr_all_organization_units

2324: and hoi.org_information_context || '' ='CLASS' ;
2325:
2326: cursor c_organization_start_date(c_organization_id number) is
2327: select date_from
2328: from hr_all_organization_units
2329: where organization_id = c_organization_id;
2330:
2331: l_organization_start_date hr_all_organization_units.date_from%type;
2332: ---------------------------------------------------------------

Line 2331: l_organization_start_date hr_all_organization_units.date_from%type;

2327: select date_from
2328: from hr_all_organization_units
2329: where organization_id = c_organization_id;
2330:
2331: l_organization_start_date hr_all_organization_units.date_from%type;
2332: ---------------------------------------------------------------
2333: -- END OF BEN_ELIG_LGL_ENTY_PRTE_F ----------------------
2334: ---------------------------------------------------------------
2335: ---------------------------------------------------------------

Line 2594: from hr_all_organization_units_vl

2590: -- pabodla : mapping data - Bug 2716749
2591: --
2592: cursor c_get_mapping_name7(p_id in number,p_date in date) is
2593: select name
2594: from hr_all_organization_units_vl
2595: where business_group_id = business_group_id
2596: and organization_id = p_id
2597: and internal_external_flag = 'INT'
2598: and p_date between nvl(date_from, p_date)