DBA Data[Home] [Help]

APPS.CSTPAPPR dependencies on CST_RCV_ACQ_COSTS_ADJ

Line 1442: FROM cst_rcv_acq_costs_adj craca

1438: l_dr_flag := not l_dr_flag;
1439: l_stmt_num := 1020;
1440: SELECT nvl(max(craca.period_id),-1)
1441: INTO l_lcm_adj_period
1442: FROM cst_rcv_acq_costs_adj craca
1443: WHERE craca.rcv_transaction_id = l_par_rcv_txn
1444: AND craca.cost_type_id = i_ae_txn_rec.cost_type_id
1445: AND craca.cost_group_id = i_ae_txn_rec.cost_group_id;
1446:

Line 1451: FROM cst_rcv_acq_costs_adj craca

1447: IF (l_lcm_adj_period <> -1) THEN
1448: l_stmt_num := 1030;
1449: SELECT craca.acquisition_cost
1450: INTO l_acq_cost
1451: FROM cst_rcv_acq_costs_adj craca
1452: WHERE craca.rcv_transaction_id = l_par_rcv_txn
1453: AND craca.cost_type_id = i_ae_txn_rec.cost_type_id
1454: AND craca.cost_group_id = i_ae_txn_rec.cost_group_id
1455: AND craca.period_id = l_lcm_adj_period;