DBA Data[Home] [Help]

APPS.CST_APPOACCRUALREPORT_PVT dependencies on HR_ORGANIZATION_INFORMATION

Line 465: HR_ORGANIZATION_INFORMATION hoi

461: ''Last Receipt Date'',
462: ''Last Activity Date'') age_option
463: FROM cst_reconciliation_codes crs,
464: XLA_GL_LEDGERS_V xla,
465: HR_ORGANIZATION_INFORMATION hoi
466: WHERE hoi.ORGANIZATION_ID = :l_current_org_id
467: and hoi.ORG_INFORMATION_CONTEXT = ''Operating Unit Information''
468: and xla.LEDGER_ID = hoi.ORG_INFORMATION3
469: AND crs.lookup_type = ''SRS ACCRUAL ORDER BY''

Line 693: hr_organization_information hr

689: SELECT fav.application_column_name
690: INTO l_bal_segment
691: FROM gl_sets_of_books gl,
692: fnd_segment_attribute_values fav,
693: hr_organization_information hr
694: WHERE hr.org_information_context = 'Operating Unit Information'
695: AND hr.organization_id = l_current_org_id
696: AND to_number(hr.org_information3) = gl.set_of_books_id
697: AND fav.segment_attribute_type = 'GL_BALANCING'

Line 744: HR_ORGANIZATION_INFORMATION hoi

740:
741: select xla.currency_code
742: into l_currency
743: from XLA_GL_LEDGERS_V xla,
744: HR_ORGANIZATION_INFORMATION hoi
745: where hoi.ORGANIZATION_ID = l_current_org_id
746: and hoi.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
747: and xla.LEDGER_ID = hoi.ORG_INFORMATION3;
748: