APPS.CN_QUOTA_PAY_ELEMENTS_PVT dependencies on DUAL

Line 47: select 1 into l_found FROM dual

43: RETURN NUMBER IS
44: l_found NUMBER := 0;
45: BEGIN
46: begin
47: select 1 into l_found FROM dual
48: where not exists
49: ( select 1
50: from cn_pay_element_inputs
51: where quota_pay_element_id = p_quota_pay_element_id);

Line 81: FROM dual

77: AND p_pay_element_type_id IS NOT NULL)
78: THEN
79: BEGIN
80: SELECT 0 INTO l_found
81: FROM dual
82: WHERE NOT EXISTS
83: (
84: SELECT 1 --if query returns row, then we can't allow update/delete.
85: --if query doesnot return anything, we can do update/delete.

Line 149: FROM dual

145:
146: ELSE
147: BEGIN
148: SELECT 0 INTO l_found
149: FROM dual
150: WHERE NOT EXISTS
151: (
152: SELECT 1 --if query returns row, then we can't allow update/delete.
153: --if query doesnot return anything, we can do update/delete.

Line 438: SELECT 1 INTO l_dummy FROM dual

434:
435:
436: -- Check for duplicate
437: BEGIN
438: SELECT 1 INTO l_dummy FROM dual
439: WHERE NOT EXISTS
440: ( SELECT 1
441: FROM cn_quota_pay_elements
442: WHERE quota_id = p_quota_pay_element_rec.quota_id

Line 478: SELECT 1 INTO l_dummy FROM dual

474: END IF;
475:
476: -- Check for Overlap
477: BEGIN
478: SELECT 1 INTO l_dummy FROM dual
479: WHERE NOT EXISTS
480: ( SELECT 1
481: FROM cn_quota_pay_elements
482: WHERE (((end_date IS NULL)

Line 681: FROM dual;

677: l_quota_pay_element_rec.quota_name,
678: l_quota_pay_element_rec.pay_element_name,
679: l_quota_pay_element_rec.pay_start_date,
680: l_quota_pay_element_rec.pay_end_date
681: FROM dual;
682:
683: -- get the quota id
684:
685: l_quota_pay_element_rec.quota_id :=

Line 863: FROM dual;

859: l_quota_pay_element_rec.start_date,
860: l_quota_pay_element_rec.end_date,
861: l_quota_pay_element_rec.quota_name,
862: l_quota_pay_element_rec.pay_element_name
863: FROM dual;
864:
865: l_quota_pay_element_rec.quota_id :=
866: get_quota_id(l_quota_pay_element_rec.quota_name);
867: