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 4385: from cst_pac_periods

4381:
4382: l_stmt_num := 60;
4383:
4384: select NVL(MAX(pac_period_id), -1) into l_prev_period_id
4385: from cst_pac_periods
4386: where legal_entity = l_legal_entity
4387: and open_flag = 'N'
4388: and cost_type_id = i_cost_type_id;
4389:

Line 4457: from CST_PAC_PERIODS

4453: /* get the period close date for the current open period */
4454:
4455: l_stmt_num := 100;
4456: select NVL(period_end_date,sysdate) into l_period_close_date
4457: from CST_PAC_PERIODS
4458: where pac_period_id = i_pac_period_id
4459: and legal_entity = l_legal_entity
4460: and cost_type_id = i_cost_type_id;
4461: