APPS.CST_SLA_UPDATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1894: hr_organization_information hoi2,

1890: distinct
1891: mta.transaction_id, mta.organization_id, mta.transaction_source_type_id
1892: from mtl_transaction_accounts mta,
1893: xla_upgrade_dates xud,
1894: hr_organization_information hoi2,
1895: org_acct_periods oap,
1896: mtl_material_transactions mmt
1897: where mmt.transaction_id >= X_min_id
1898: and mmt.transaction_id <= X_max_id

Line 2385: hr_organization_information hoi2,

2381: from mtl_transaction_accounts mta,
2382: mtl_material_transactions mmt,
2383: gl_code_combinations gcc,
2384: mtl_parameters mp,
2385: hr_organization_information hoi2,
2386: gl_ledgers sob,
2387: org_acct_periods oap,
2388: org_gl_batches ogb,
2389: cst_xla_seq_gt cxs

Line 2700: HR_ORGANIZATION_INFORMATION HOI2,

2696: where wta.transaction_id >= X_min_id
2697: and wta.transaction_id <= X_max_id
2698: and exists (select null
2699: from xla_upgrade_dates xud,
2700: HR_ORGANIZATION_INFORMATION HOI2,
2701: ORG_ACCT_PERIODS oap,
2702: wip_transactions wt
2703: where HOI2.organization_id = oap.organization_id
2704: and HOI2.ORG_INFORMATION_CONTEXT ='Accounting Information'

Line 3079: HR_ORGANIZATION_INFORMATION HOI2,

3075: cst_xla_wip_event_map cem,
3076: wip_transactions wt,
3077: GL_CODE_COMBINATIONS gcc,
3078: mtl_parameters mp,
3079: HR_ORGANIZATION_INFORMATION HOI2,
3080: gl_ledgers sob,
3081: ORG_ACCT_PERIODS oap,
3082: org_gl_batches ogb,
3083: cst_xla_seq_gt cxs

Line 3271: hr_organization_information hoi2,

3267: nvl(rae.org_id,
3268: DECODE(l_multi_org_flag,'Y',TO_NUMBER(HOI2.ORG_INFORMATION3),TO_NUMBER(NULL)))
3269: from rcv_transactions rt,
3270: rcv_accounting_events rae,
3271: hr_organization_information hoi2,
3272: gl_ledgers sob,
3273: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */
3274: distinct rcv_transaction_id
3275: from xla_upgrade_dates xud,