APPS.CSTPPCIT dependencies on CST_PAC_PERIODS

Line 122: FROM CST_PAC_PERIODS

118: l_stmt_num := 60;
119: /* Validate transaction_date */
120: SELECT NVL(MAX(pac_period_id),-1)
121: INTO l_period_id
122: FROM CST_PAC_PERIODS
123: WHERE legal_entity = l_legal_entity
124: AND cost_type_id = i_cost_type_id
125: AND i_transaction_date between period_start_date and period_end_date;
126:

Line 131: FROM CST_PAC_PERIODS

127: IF (l_period_id <> -1) THEN
128: l_stmt_num := 70;
129: SELECT decode(open_flag,'Y',decode(period_close_date,NULL,'Y','N'),'N')
130: INTO l_open_flag
131: FROM CST_PAC_PERIODS
132: WHERE pac_period_id = l_period_id;
133:
134: IF (l_open_flag = 'N') THEN
135: l_err_num := 999;

Line 360: FROM CST_PAC_PERIODS

356: WHERE cost_group_id = i_org_cost_group_id;
357:
358: SELECT NVL(MAX(pac_period_id),-1)
359: INTO l_pac_period_id
360: FROM CST_PAC_PERIODS
361: WHERE cost_type_id = i_cost_type_id
362: AND legal_entity = l_legal_entity
363: AND i_transaction_date between period_start_date and period_end_date;
364:

Line 505: FROM CST_PAC_PERIODS

501:
502: /* Find last close period */
503: SELECT NVL(MAX(pac_period_id), -1)
504: INTO l_prior_close_period_id
505: FROM CST_PAC_PERIODS
506: WHERE cost_type_id = i_cost_type_id AND legal_entity = i_legal_entity
507: AND open_flag = 'N' AND period_close_date IS NOT NULL;
508:
509: IF (l_prior_close_period_id <> -1) THEN