DBA Data[Home] [Help]

APPS.CST_SLA_UPDATE_PKG dependencies on ORG_ACCT_PERIODS

Line 2151: org_acct_periods oap,

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
2155: and mmt.acct_period_id = oap.acct_period_id

Line 2666: org_acct_periods oap,

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
2669: where mta.transaction_id = cxs.source_id_int_1
2670: and mta.organization_id = cxs.source_id_int_2

Line 2957: ORG_ACCT_PERIODS oap,

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'
2961: AND HOI2.ORG_INFORMATION1 = TO_CHAR(xud.ledger_ID)

Line 3379: ORG_ACCT_PERIODS oap,

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
3382: where wta.transaction_id=cxs.source_id_int_1
3383: and wt.transaction_id=cxs.source_id_int_1