DBA Data[Home] [Help]

APPS.PAY_PYUCSLIS_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 413: structure element table per_org_structure_elements takes place and

409: build_organization_list
410: DESCRIPTION
411: Insert values into the organization list for the security profile.
412: Starting with the organization specified a tree walk of the organization
413: structure element table per_org_structure_elements takes place and
414: all organization below that specified are inserted into the organization
415: list. If the include_top_org option is specified then that organisation
416: is explicitly inserted into the list. The business group is
417: inserted into the organisation list if not previously inserted.

Line 465: FROM per_org_structure_elements o

461: p_request_id,
462: p_program_application_id,
463: p_program_id,
464: l_update_date
465: FROM per_org_structure_elements o
466: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
467: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
468: START WITH o.organization_id_parent = l_organization_id
469: AND o.org_structure_version_id =