DBA Data[Home] [Help]

APPS.CST_MISCACCRUALREPORT_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 483: HR_ORGANIZATION_INFORMATION hoi

479: ''Last Receipt Date'',
480: ''Last Activity Date'') age_option
481: FROM cst_reconciliation_codes crs,
482: XLA_GL_LEDGERS_V xla,
483: HR_ORGANIZATION_INFORMATION hoi
484: WHERE hoi.ORGANIZATION_ID = :l_current_org_id
485: and hoi.ORG_INFORMATION_CONTEXT = ''Operating Unit Information''
486: and xla.LEDGER_ID = hoi.ORG_INFORMATION3
487: AND crs.lookup_type = ''SRS ACCRUAL ORDER BY''

Line 700: hr_organization_information hr

696: SELECT fav.application_column_name
697: INTO l_bal_segment
698: FROM gl_sets_of_books gl,
699: fnd_segment_attribute_values fav,
700: hr_organization_information hr
701: WHERE hr.org_information_context = 'Operating Unit Information'
702: AND hr.organization_id = l_current_org_id
703: AND to_number(hr.org_information3) = gl.set_of_books_id
704: AND fav.segment_attribute_type = 'GL_BALANCING'