[Home] [Help]
2631: begin
2632: select org.organization_id
2633: into l_organization_id
2634: from hr_all_organization_units org
2635: , hr_all_organization_units_tl orgtl
2636: where orgtl.name = p_organization_name
2637: and orgtl.language = p_language_code
2638: and org.organization_id = orgtl.organization_id
2639: and org.business_group_id + 0 = p_business_group_id;
3278: into l_id
3279: from pay_user_columns puc,
3280: hr_organization_information hoi,
3281: hr_all_organization_units org
3282: , hr_all_organization_units_tl orgtl
3283: where orgtl.name = p_organization_name
3284: and orgtl.language = p_language_code
3285: and org.organization_id = orgtl.organization_id
3286: and org.business_group_id + 0 = p_business_group_id
4063: begin
4064: select org.object_version_number
4065: into l_ovn
4066: from hr_all_organization_units org
4067: , hr_all_organization_units_tl orgtl
4068: where orgtl.name = p_organization_name
4069: and orgtl.language = p_language_code
4070: and org.organization_id = orgtl.organization_id
4071: and org.business_group_id + 0 = p_business_group_id;
5695:
5696: select org.organization_id
5697: into l_organization_id
5698: from hr_all_organization_units org
5699: , hr_all_organization_units_tl orgtl
5700: where orgtl.name = p_parent_organization_name
5701: and orgtl.language = p_language_code
5702: and org.organization_id = orgtl.organization_id
5703: and (org.business_group_id = p_business_group_id
5731: ELSE
5732: select org.organization_id
5733: into l_organization_id
5734: from hr_all_organization_units org
5735: , hr_all_organization_units_tl orgtl
5736: where orgtl.name = p_child_organization_name
5737: and orgtl.language = p_language_code
5738: and org.organization_id = orgtl.organization_id
5739: and (org.business_group_id = p_business_group_id