DBA Data[Home] [Help]

APPS.PA_PERIOD_MASKS_PUB dependencies on DUAL

Line 173: SELECT pa_period_masks_s.nextval INTO l_period_masks_s FROM DUAL;

169: /**if period_mask_id is null, then we need to INSERT
170: *Populate both the master record in pa_period_masks_s + pa_period_masks_tl
171: *and detail record in pa_period_mask_details*/
172: IF p_period_mask_id = 0 THEN
173: SELECT pa_period_masks_s.nextval INTO l_period_masks_s FROM DUAL;
174: SELECT userenv('LANG') INTO l_language FROM dual;
175: /*populating table pa_period_masks_b*/
176: INSERT INTO pa_period_masks_b (
177: PERIOD_MASK_ID,

Line 174: SELECT userenv('LANG') INTO l_language FROM dual;

170: *Populate both the master record in pa_period_masks_s + pa_period_masks_tl
171: *and detail record in pa_period_mask_details*/
172: IF p_period_mask_id = 0 THEN
173: SELECT pa_period_masks_s.nextval INTO l_period_masks_s FROM DUAL;
174: SELECT userenv('LANG') INTO l_language FROM dual;
175: /*populating table pa_period_masks_b*/
176: INSERT INTO pa_period_masks_b (
177: PERIOD_MASK_ID,
178: EFFECTIVE_START_DATE,