DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on HR_ORGANIZATION_INFORMATION

Line 460: hr_organization_information hoi

456: begin
457: --Perf Issue : Replaced org_organizations_definitions view.
458: SELECT lgr.CHART_OF_ACCOUNTS_ID into chart_of_acc_id
459: FROM gl_ledgers lgr,
460: hr_organization_information hoi
461: where hoi.organization_id = cr.organization_id
462: and (HOI.ORG_INFORMATION_CONTEXT|| '') ='Accounting Information'
463: and TO_NUMBER(DECODE(RTRIM(TRANSLATE(HOI.ORG_INFORMATION1,'0123456789',' ')), NULL, HOI.ORG_INFORMATION1,-99999)) = LGR.LEDGER_ID
464: and lgr.object_type_code = 'L'