DBA Data[Home] [Help]

APPS.PAY_NL_NSI_PROCESS dependencies on PER_ORGANIZATION_STRUCTURES

Line 1850: per_organization_structures pos,

1846: CURSOR csr_org_hierarchy(lp_business_group_id number,lp_process_date date) IS
1847: select
1848: posv.org_structure_version_id
1849: from
1850: per_organization_structures pos,
1851: per_org_structure_versions posv
1852: where pos.organization_structure_id = posv.organization_structure_id
1853: and to_char(pos.organization_structure_id) IN (select org_information1
1854: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'