DBA Data[Home] [Help]

APPS.CST_ACCRUALSUMMARYREPORT_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 348: HR_ORGANIZATION_INFORMATION hoi

344: :i_title TITLE_NAME,
345: :i_bal_segment_from from_seg,
346: :i_bal_segment_to to_seg
347: FROM XLA_GL_LEDGERS_V xla,
348: HR_ORGANIZATION_INFORMATION hoi
349: WHERE hoi.ORGANIZATION_ID = :l_current_org_id
350: and hoi.ORG_INFORMATION_CONTEXT = ''Operating Unit Information''
351: and xla.LEDGER_ID = hoi.ORG_INFORMATION3 '
352: USING l_org_code,

Line 526: hr_organization_information hr

522: SELECT fav.application_column_name
523: INTO l_bal_segment
524: FROM gl_sets_of_books gl,
525: fnd_segment_attribute_values fav,
526: hr_organization_information hr
527: WHERE hr.org_information_context = 'Operating Unit Information'
528: AND hr.organization_id = l_current_org_id
529: AND to_number(hr.org_information3) = gl.set_of_books_id
530: AND fav.segment_attribute_type = 'GL_BALANCING'