APPS.OTA_CLASSIC_UPGRADE dependencies on HR_ORGANIZATION_UNITS

Line 250: From hr_organization_units org, hr_all_organization_units_tl orgtl

246: orgtl.Creation_date,
247: orgtl.Last_Updated_By,
248: orgtl.Last_Update_Date,
249: orgtl.Last_Update_Login
250: From hr_organization_units org, hr_all_organization_units_tl orgtl
251: Where orgtl.organization_id = p_business_group_id
252: and org.organization_id = org.business_group_id
253: and org.organization_id = orgtl.organization_id
254: And Not Exists (Select '1'

Line 670: From hr_organization_units hou

666: Group by ctu.business_group_id ;
667:
668: Cursor Csr_Bg_name(p_bg_id number) is
669: Select hou.name Bg_name
670: From hr_organization_units hou
671: Where hou.business_group_id = p_bg_id
672: and hou.business_group_id = hou.organization_id ;
673:
674: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;

Line 676: l_bg_name hr_organization_units.name%Type ;

672: and hou.business_group_id = hou.organization_id ;
673:
674: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;
675: l_root_cat_usage_id ota_category_usages.category_usage_id%Type;
676: l_bg_name hr_organization_units.name%Type ;
677:
678: begin
679:
680: For Cat_Bg in csr_Category_bg Loop

Line 1268: --l_bg_name hr_organization_units.name%Type ;

1264: hr_dflex_utility.l_ignore_dfcode_varray();
1265: --l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;
1266: --l_default_dm_name Hr_lookups.Meaning%Type ;
1267: --l_root_cat_usage_id ota_category_usages.category_usage_id%Type;
1268: --l_bg_name hr_organization_units.name%Type ;
1269: Begin
1270:
1271: -- Ignore Category Dff Validation while creating Category from Activity.
1272: l_add_struct_d.extend(1);

Line 2513: From hr_organization_units hou

2509: Group by tad.business_group_id ;
2510:
2511: Cursor Csr_Bg_name(p_bg_id number) is
2512: Select hou.name Bg_name
2513: From hr_organization_units hou
2514: Where hou.business_group_id = p_bg_id
2515: and hou.business_group_id = hou.organization_id ;
2516:
2517: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;

Line 2519: l_bg_name hr_organization_units.name%Type ;

2515: and hou.business_group_id = hou.organization_id ;
2516:
2517: l_default_dm Ota_Category_usages_tl.Category_usage_id%Type;
2518: l_root_cat_usage_id ota_category_usages.category_usage_id%Type;
2519: l_bg_name hr_organization_units.name%Type ;
2520:
2521: begin
2522:
2523: For Act_Bg in csr_Activity_bg Loop