DBA Data[Home] [Help]

APPS.CSTPAPPR dependencies on CST_ORG_COST_GROUP_ACCOUNTS

Line 1330: FROM CST_ORG_COST_GROUP_ACCOUNTS coga

1326:
1327: BEGIN
1328: SELECT nvl(max(LANDED_COST_ABS_ACCOUNT),-1)
1329: INTO l_landed_cost_abs_account
1330: FROM CST_ORG_COST_GROUP_ACCOUNTS coga
1331: WHERE coga.legal_entity_id = i_ae_txn_rec.legal_entity_id
1332: AND coga.cost_type_id = i_ae_txn_rec.cost_type_id
1333: AND coga.cost_group_id = i_ae_txn_rec.cost_group_id;
1334:

Line 2703: CST_ORG_COST_GROUP_ACCOUNTS

2699: nvl(RETRO_PRICE_ADJ_ACCOUNT, -1)
2700: INTO
2701: l_debit_account
2702: FROM
2703: CST_ORG_COST_GROUP_ACCOUNTS
2704: WHERE
2705: LEGAL_ENTITY_ID = P_AE_TXN_REC.LEGAL_ENTITY_ID
2706: AND COST_TYPE_ID = P_AE_TXN_REC.COST_TYPE_ID
2707: AND COST_GROUP_ID = P_AE_TXN_REC.COST_GROUP_ID;