APPS.CSTPAPBR dependencies on CST_PAC_PERIODS

Line 415: cst_pac_periods

411: period_name
412: INTO
413: l_period_name
414: FROM
415: cst_pac_periods
416: WHERE
417: pac_period_id = i_period_id;
418:
419: l_ae_txn_rec.description := l_ae_txn_rec.description ||' : '||l_cost_type_name||' : '||l_cost_group_name||' : '||l_period_name;

Line 461: cst_pac_periods

457: period_name
458: INTO
459: l_ae_txn_rec.accounting_period_name
460: FROM
461: cst_pac_periods
462: WHERE
463: pac_period_id = l_ae_txn_rec.accounting_period_id AND
464: cost_type_id = l_ae_txn_rec.cost_type_id AND
465: legal_entity = l_ae_txn_rec.legal_entity_id;

Line 2538: FROM cst_pac_periods cpp

2534:
2535: /* Get prior period id */
2536: SELECT nvl(max(cpp.pac_period_id), -1)
2537: INTO l_prev_period_id
2538: FROM cst_pac_periods cpp
2539: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
2540: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
2541: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
2542:

Line 3364: FROM cst_pac_periods cpp

3360:
3361: /* Prior period id */
3362: SELECT nvl(max(cpp.pac_period_id), -1)
3363: INTO l_prev_period_id
3364: FROM cst_pac_periods cpp
3365: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
3366: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
3367: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
3368:

Line 4636: FROM cst_pac_periods cpp

4632: l_stmt_num := 460;
4633:
4634: SELECT nvl(max(cpp.pac_period_id), -1)
4635: INTO l_prev_period_id
4636: FROM cst_pac_periods cpp
4637: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
4638: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
4639: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
4640:

Line 10251: FROM cst_pac_periods cpp

10247:
10248: /* Get prior period id */
10249: SELECT nvl(max(cpp.pac_period_id), -1)
10250: INTO l_prev_period_id
10251: FROM cst_pac_periods cpp
10252: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
10253: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
10254: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
10255: