APPS.CST_SLA_UPDATE_PKG dependencies on ORG_ACCT_PERIODS

Line 1895: org_acct_periods oap,

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

Line 2387: org_acct_periods oap,

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

Line 2701: ORG_ACCT_PERIODS oap,

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

Line 3081: ORG_ACCT_PERIODS oap,

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