APPS.PQP_UK_UNION_TEMPLATE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 142: FROM hr_all_organization_units hou

138:
139: CURSOR csr_or_unnorg(p_or_unnorg_nm VARCHAR2
140: ,p_bg_unnddn_id NUMBER ) IS
141: SELECT hou.organization_id
142: FROM hr_all_organization_units hou
143: WHERE hou.name = p_or_unnorg_nm
144: AND hou.business_group_id = p_bg_unnddn_id;
145:
146: row_or_unnorg csr_or_unnorg%ROWTYPE;

Line 218: -- FROM hr_all_organization_units hou

214: AND hrl.enabled_flag = 'Y';
215:
216: -- CURSOR get_user_table_id is
217: -- SELECT to_number(hoi.org_information1)
218: -- FROM hr_all_organization_units hou
219: -- ,hr_organization_information hoi
220: -- WHERE hou.organization_id = hoi.organization_id
221: -- AND org_information_context = 'GB_TRADE_UNION_INFO'
222: -- AND hou.name = p_union_name;

Line 849: -- ,hr_all_organization_units horg

845: FROM pay_element_templates pets
846: ,pay_shadow_element_types pset
847: ,pay_template_core_objects ptco
848: ,pay_element_type_extra_info peei
849: -- ,hr_all_organization_units horg
850: WHERE pets.template_id = p_te_usrstr_id -- For the given user structure
851: AND pset.template_id = pets.template_id -- find the base element
852: AND pset.element_name = pets.base_name
853: AND ptco.template_id = pset.template_id -- For the base element

Line 870: FROM hr_all_organization_units horg

866: --
867:
868: CURSOR csr_or_unionm (p_or_unnorg_id NUMBER) IS
869: SELECT horg.organization_id
870: FROM hr_all_organization_units horg
871: WHERE horg.organization_id = p_or_unnorg_id
872: AND horg.name = p_frm_union_name
873: AND ( horg.business_group_id = p_frm_business_group_id
874: OR horg.business_group_id IS NULL);