APPS.CSTPPACQ dependencies on CST_PAC_PERIODS

Line 487: from cst_pac_periods

483: l_stmt_num := 40;
484: BEGIN /* to handle the case of no prev pac periods */
485: select NVL(MAX(pac_period_id), -1)
486: into l_prev_period_id
487: from cst_pac_periods
488: where legal_entity = l_legal_entity
489: and open_flag = 'N'
490: and cost_type_id = i_cost_type_id ;
491:

Line 496: from cst_pac_periods

492: select period_close_date,
493: i_end_date
494: into l_start_date,
495: l_end_date
496: from cst_pac_periods
497: where pac_period_id = l_prev_period_id
498: and legal_entity = l_legal_entity
499: and cost_type_id = i_cost_type_id;
500:

Line 516: FROM cst_pac_periods cpp

512: select period_start_date,
513: i_end_date
514: INTO l_start_date,
515: l_end_date
516: FROM cst_pac_periods cpp
517: where cpp.pac_period_id = i_period
518: and cpp.legal_entity = l_legal_entity
519: and cpp.cost_type_id = i_cost_type_id;
520:

Line 4294: from cst_pac_periods

4290:
4291: l_stmt_num := 60;
4292:
4293: select NVL(MAX(pac_period_id), -1) into l_prev_period_id
4294: from cst_pac_periods
4295: where legal_entity = l_legal_entity
4296: and open_flag = 'N'
4297: and cost_type_id = i_cost_type_id;
4298:

Line 4366: from CST_PAC_PERIODS

4362:
4363: l_stmt_num := 80;
4364:
4365: select NVL(period_end_date,sysdate) into l_period_close_date
4366: from CST_PAC_PERIODS
4367: where pac_period_id = i_pac_period_id
4368: and legal_entity = l_legal_entity
4369: and cost_type_id = i_cost_type_id;
4370: