APPS.CST_SLA_UPDATE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2150: hr_organization_information hoi2,

2146: distinct
2147: mta.transaction_id, mta.organization_id, mta.transaction_source_type_id
2148: from mtl_transaction_accounts mta,
2149: xla_upgrade_dates xud,
2150: hr_organization_information hoi2,
2151: org_acct_periods oap,
2152: mtl_material_transactions mmt
2153: where mmt.transaction_id >= X_min_id
2154: and mmt.transaction_id <= X_max_id

Line 2664: hr_organization_information hoi2,

2660: from mtl_transaction_accounts mta,
2661: mtl_material_transactions mmt,
2662: gl_code_combinations gcc,
2663: mtl_parameters mp,
2664: hr_organization_information hoi2,
2665: gl_ledgers sob,
2666: org_acct_periods oap,
2667: org_gl_batches ogb,
2668: cst_xla_seq_gt cxs

Line 2956: HR_ORGANIZATION_INFORMATION HOI2,

2952: where wta.transaction_id >= X_min_id
2953: and wta.transaction_id <= X_max_id
2954: and exists (select null
2955: from xla_upgrade_dates xud,
2956: HR_ORGANIZATION_INFORMATION HOI2,
2957: ORG_ACCT_PERIODS oap,
2958: wip_transactions wt
2959: where HOI2.organization_id = oap.organization_id
2960: and HOI2.ORG_INFORMATION_CONTEXT ='Accounting Information'

Line 3377: HR_ORGANIZATION_INFORMATION HOI2,

3373: cst_xla_wip_event_map cem,
3374: wip_transactions wt,
3375: GL_CODE_COMBINATIONS gcc,
3376: mtl_parameters mp,
3377: HR_ORGANIZATION_INFORMATION HOI2,
3378: gl_ledgers sob,
3379: ORG_ACCT_PERIODS oap,
3380: org_gl_batches ogb,
3381: cst_xla_seq_gt cxs

Line 3546: hr_organization_information hoi2,

3542: nvl(rae.org_id,
3543: DECODE(l_multi_org_flag,'Y',TO_NUMBER(HOI2.ORG_INFORMATION3),TO_NUMBER(NULL)))
3544: from rcv_transactions rt,
3545: rcv_accounting_events rae,
3546: hr_organization_information hoi2,
3547: gl_ledgers sob,
3548: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */
3549: distinct rcv_transaction_id,
3550: accounting_event_id