DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on HR_ORGANIZATION_INFORMATION

Line 1402: FROM hr_organization_information hoi,

1398: WHERE ORGANIZATION_ID = p_organization_id ;
1399: */
1400: SELECT lgr.chart_of_accounts_id chart_of_accounts_id
1401: INTO l_chart_of_accounts_id
1402: FROM hr_organization_information hoi,
1403: gl_ledgers lgr
1404: WHERE hoi.organization_id = p_organization_id
1405: and hoi.org_information_context = 'Accounting Information'
1406: and (ltrim(hoi.org_information1,'0123456789') is null