APPS.CSTPAPBR dependencies on CST_PAC_PERIODS

Line 425: cst_pac_periods

421: period_name
422: INTO
423: l_period_name
424: FROM
425: cst_pac_periods
426: WHERE
427: pac_period_id = i_period_id;
428:
429: l_ae_txn_rec.description := l_ae_txn_rec.description ||' : '||l_cost_type_name||' : '||l_cost_group_name||' : '||l_period_name;

Line 471: cst_pac_periods

467: period_name
468: INTO
469: l_ae_txn_rec.accounting_period_name
470: FROM
471: cst_pac_periods
472: WHERE
473: pac_period_id = l_ae_txn_rec.accounting_period_id AND
474: cost_type_id = l_ae_txn_rec.cost_type_id AND
475: legal_entity = l_ae_txn_rec.legal_entity_id;

Line 2820: FROM cst_pac_periods cpp

2816:
2817: /* Get prior period id */
2818: SELECT nvl(max(cpp.pac_period_id), -1)
2819: INTO l_prev_period_id
2820: FROM cst_pac_periods cpp
2821: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
2822: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
2823: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
2824:

Line 3646: FROM cst_pac_periods cpp

3642:
3643: /* Prior period id */
3644: SELECT nvl(max(cpp.pac_period_id), -1)
3645: INTO l_prev_period_id
3646: FROM cst_pac_periods cpp
3647: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
3648: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
3649: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
3650:

Line 4918: FROM cst_pac_periods cpp

4914: l_stmt_num := 460;
4915:
4916: SELECT nvl(max(cpp.pac_period_id), -1)
4917: INTO l_prev_period_id
4918: FROM cst_pac_periods cpp
4919: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
4920: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
4921: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
4922:

Line 10726: FROM cst_pac_periods cpp

10722:
10723: /* Get prior period id */
10724: SELECT nvl(max(cpp.pac_period_id), -1)
10725: INTO l_prev_period_id
10726: FROM cst_pac_periods cpp
10727: WHERE cpp.cost_type_id = i_ae_txn_rec.cost_type_id
10728: AND cpp.legal_entity = i_ae_txn_rec.legal_entity_id
10729: AND cpp.pac_period_id < i_ae_txn_rec.accounting_period_id;
10730: