DBA Data[Home] [Help]

APPS.INVPVDR5 dependencies on HR_ORGANIZATION_INFORMATION

Line 462: hr_organization_information hoi

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