DBA Data[Home] [Help]

APPS.INVIDIT1 dependencies on HR_ORGANIZATION_INFORMATION

Line 128: hr_organization_information hoi

124:
125: SELECT lgr.CHART_OF_ACCOUNTS_ID
126: into X_master_chart_of_accounts
127: FROM gl_ledgers lgr,
128: hr_organization_information hoi
129: where hoi.organization_id = master_org
130: and (HOI.ORG_INFORMATION_CONTEXT|| '') ='Accounting Information'
131: and TO_NUMBER(DECODE(RTRIM(TRANSLATE(HOI.ORG_INFORMATION1,'0123456789',' ')), NULL, HOI.ORG_INFORMATION1,-99999)) = LGR.LEDGER_ID
132: and lgr.object_type_code = 'L'

Line 288: from hr_organization_information

284: 'Accounting Information',
285: TO_NUMBER(ORG_INFORMATION3),
286: TO_NUMBER(NULL)) operating_unit
287: into V_operating_unit
288: from hr_organization_information
289: where organization_id = X_org_id
290: and (org_information_context|| '') ='Accounting Information';
291:
292: