DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 349: structure element table per_org_structure_elements takes place and

345: build_organization_list
346: DESCRIPTION
347: Insert values into the organization list for the security profile.
348: Starting with the organization specified a tree walk of the organization
349: structure element table per_org_structure_elements takes place and
350: all organization below that specified are inserted into the organization
351: list. If the include_top_org option is specified then that organisation
352: is explicitly inserted into the list. The business group is
353: inserted into the organisation list if not previously inserted.

Line 401: FROM per_org_structure_elements o

397: p_request_id,
398: p_program_application_id,
399: p_program_id,
400: l_update_date
401: FROM per_org_structure_elements o
402: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
403: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
404: START WITH o.organization_id_parent = l_organization_id
405: AND o.org_structure_version_id =