DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_CRITERIA dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 151: from per_org_structure_elements a

147:
148:
149: cursor c_org_hier is
150: select 'x'
151: from per_org_structure_elements a
152: where a.ORG_STRUCTURE_VERSION_ID = p_org_structure_version_id
153: and a.business_group_id = p_business_group_id
154: and (a.organization_id_parent = p_organization_id
155: or a.organization_id_child = p_organization_id)

Line 162: from per_org_structure_elements a

158: -- if the least organization defined as start postion
159: -- this cursor make sure the person belongs to the org
160: cursor c_org is
161: select 'x'
162: from per_org_structure_elements a
163: where a.organization_id_child = p_organization_id
164: and a.organization_id_child = p_start_organization_id
165: and a.business_group_id = p_business_group_id
166: and a.ORG_STRUCTURE_VERSION_ID = p_org_structure_version_id