DBA Data[Home] [Help]

APPS.CST_ACCRUALWRITEOFFREPORT_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 482: HR_ORGANIZATION_INFORMATION hoi

478: :i_bal_segment_from bal_seg_from,
479: :i_bal_segment_to bal_seg_to
480: FROM cst_reconciliation_codes crs,
481: XLA_GL_LEDGERS_V xla,
482: HR_ORGANIZATION_INFORMATION hoi
483: WHERE hoi.ORGANIZATION_ID = :l_current_org_id
484: and hoi.ORG_INFORMATION_CONTEXT = ''Operating Unit Information''
485: and xla.LEDGER_ID = hoi.ORG_INFORMATION3
486: AND crs.lookup_type = ''SRS ACCRUAL ORDER BY''

Line 674: hr_organization_information hr

670: SELECT fav.application_column_name
671: INTO l_bal_segment
672: FROM gl_sets_of_books gl,
673: fnd_segment_attribute_values fav,
674: hr_organization_information hr
675: WHERE hr.org_information_context = 'Operating Unit Information'
676: AND hr.organization_id = l_current_org_id
677: AND to_number(hr.org_information3) = gl.set_of_books_id
678: AND fav.segment_attribute_type = 'GL_BALANCING'

Line 707: HR_ORGANIZATION_INFORMATION hoi

703:
704: select xla.currency_code
705: into l_currency
706: from XLA_GL_LEDGERS_V xla,
707: HR_ORGANIZATION_INFORMATION hoi
708: where hoi.ORGANIZATION_ID = l_current_org_id
709: and hoi.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
710: and xla.LEDGER_ID = hoi.ORG_INFORMATION3;
711: