APPS.CN_PLAN_ELEMENT_PUB dependencies on DUAL

Line 203: FROM SYS.DUAL;

199:
200: -- Convert x_payee_assign_flag
201: SELECT DECODE (p_payee_assign_flag, fnd_api.g_miss_char, 'No', NULL, 'No', LTRIM (RTRIM (p_payee_assign_flag)))
202: INTO l_flag
203: FROM SYS.DUAL;
204:
205: BEGIN
206: SELECT lookup_code
207: INTO x_payee_assign_flag

Line 219: FROM SYS.DUAL;

215:
216: -- Convert x_vesting_flag
217: SELECT DECODE (p_vesting_flag, fnd_api.g_miss_char, 'No', NULL, 'No', LTRIM (RTRIM (p_vesting_flag)))
218: INTO l_flag
219: FROM SYS.DUAL;
220:
221: BEGIN
222: SELECT lookup_code
223: INTO x_vesting_flag

Line 235: FROM SYS.DUAL;

231:
232: -- Convert x_addup_rev_class_flag
233: SELECT DECODE (p_addup_from_rev_class_flag, fnd_api.g_miss_char, 'No', NULL, 'No', LTRIM (RTRIM (p_addup_from_rev_class_flag)))
234: INTO l_flag
235: FROM SYS.DUAL;
236:
237: BEGIN
238: SELECT lookup_code
239: INTO x_addup_from_rev_class_flag

Line 251: FROM SYS.DUAL;

247:
248: -- Convert x_rate_cust_flag
249: SELECT DECODE (p_rt_sched_custom_flag, fnd_api.g_miss_char, 'No', NULL, 'No', LTRIM (RTRIM (p_rt_sched_custom_flag)))
250: INTO l_flag
251: FROM SYS.DUAL;
252:
253: BEGIN
254: SELECT lookup_code
255: INTO x_rt_sched_custom_flag

Line 386: FROM SYS.DUAL;

382:
383: -- Assign Default value if null or G_MISS_NUM
384: SELECT DECODE (p_plan_element_rec.target, fnd_api.g_miss_num, 0, NULL, 0, p_plan_element_rec.target)
385: INTO l_pe_rec.target
386: FROM SYS.DUAL;
387:
388: -- Assign Default value if null or G_MISS_NUM
389: SELECT DECODE (p_plan_element_rec.payment_amount, fnd_api.g_miss_num, 0, NULL, 0, p_plan_element_rec.payment_amount)
390: INTO l_pe_rec.payment_amount

Line 391: FROM SYS.DUAL;

387:
388: -- Assign Default value if null or G_MISS_NUM
389: SELECT DECODE (p_plan_element_rec.payment_amount, fnd_api.g_miss_num, 0, NULL, 0, p_plan_element_rec.payment_amount)
390: INTO l_pe_rec.payment_amount
391: FROM SYS.DUAL;
392:
393: -- Assign Default value if null or G_MISS_NUM
394: SELECT DECODE (p_plan_element_rec.performance_goal, fnd_api.g_miss_num, 0, NULL, 0, p_plan_element_rec.performance_goal)
395: INTO l_pe_rec.performance_goal

Line 396: FROM SYS.DUAL;

392:
393: -- Assign Default value if null or G_MISS_NUM
394: SELECT DECODE (p_plan_element_rec.performance_goal, fnd_api.g_miss_num, 0, NULL, 0, p_plan_element_rec.performance_goal)
395: INTO l_pe_rec.performance_goal
396: FROM SYS.DUAL;
397:
398: -- Return the Converted Value
399: RETURN l_pe_rec;
400: END convert_pe_user_input;

Line 4349: FROM dual where exists

4345: pe_start_date DATE
4346: )
4347: IS
4348: SELECT 'Y'
4349: FROM dual where exists
4350: (Select period_id from cn_acc_period_statuses_v
4351: WHERE pe_start_date BETWEEN start_date and end_date
4352: AND period_status IN ('F', 'O') and org_id = p_org_id);
4353: