APPS.PNP_UTIL_FUNC dependencies on DUAL

Line 2205: FROM DUAL;

2201: begin
2202:
2203: SELECT pn_locations_s.NEXTVAL
2204: INTO l_seqnum
2205: FROM DUAL;
2206:
2207: RETURN l_seqnum;
2208:
2209: exception

Line 2227: FROM dual;

2223: begin
2224:
2225: SELECT PN_SPACE_ASSIGN_EMP_S.NEXTVAL
2226: INTO l_seqnum
2227: FROM dual;
2228:
2229: RETURN l_seqnum;
2230:
2231: exception

Line 2636: FROM DUAL;

2632: , 'QTR', 3
2633: , 'SA', 6
2634: , 'YR', 12
2635: , -1)) AS freq_num
2636: FROM DUAL;
2637:
2638: l_sched_tbl PNP_UTIL_FUNC.virtual_sched_tbl_type;
2639:
2640: l_frequency NUMBER;

Line 2778: FROM dual

2774: */
2775: CURSOR exists_norm_term( p_lease_ID IN NUMBER
2776: ,p_termination_date IN DATE) IS
2777: SELECT 1
2778: FROM dual
2779: WHERE EXISTS
2780: (SELECT 1
2781: FROM pn_payment_schedules_all s,
2782: pn_payment_items_all i

Line 7266: FROM DUAL

7262: USER_DEF_ERROR Exception;
7263:
7264: CURSOR validate_start_date_cursor IS
7265: SELECT 'x'
7266: FROM DUAL
7267: WHERE EXISTS (SELECT 'x'
7268: FROM pn_space_assign_emp_all
7269: WHERE location_id IN (SELECT location_id
7270: FROM pn_locations_all

Line 7291: FROM DUAL

7287: AND NVL(cust_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) >= p_start_date_old);
7288:
7289: CURSOR validate_end_date_cursor IS
7290: SELECT 'x'
7291: FROM DUAL
7292: WHERE EXISTS (SELECT 'x'
7293: FROM pn_space_assign_emp_all
7294: WHERE location_id IN (SELECT location_id
7295: FROM pn_locations_all

Line 7762: FROM dual

7758: RETURN BOOLEAN IS
7759:
7760: CURSOR tenancy_exists IS
7761: SELECT 'Y'
7762: FROM dual
7763: WHERE exists
7764: (select tenancy_id
7765: from pn_tenancies_all
7766: where location_id in

Line 7808: FROM dual

7804: RETURN BOOLEAN IS
7805:
7806: CURSOR tenancy_exists IS
7807: SELECT 'Y'
7808: FROM dual
7809: WHERE exists
7810: (select tenancy_id
7811: from pn_tenancies_all
7812: where location_id in

Line 7855: FROM dual

7851: RETURN BOOLEAN IS
7852:
7853: CURSOR Area_Class_Dtls_Exist IS
7854: SELECT 'Y'
7855: FROM dual
7856: WHERE exists
7857: (select area_class_dtl_line_id
7858: from pn_rec_arcl_dtlln_all
7859: where location_id in

Line 7868: from dual

7864: );
7865:
7866: CURSOR Area_CLass_Dtls_Exist_For_Dt IS
7867: select 'Y'
7868: from dual
7869: where exists
7870: (select arclDtl.area_class_dtl_line_id
7871: from pn_rec_arcl_dtlln_all arclDtl
7872: where arclDtl.location_id = p_location_id

Line 8041: FROM dual

8037: AND trm.start_date BETWEEN loc.active_start_date AND loc.active_end_date;
8038:
8039: CURSOR search_for_items (p_payment_term_id NUMBER) IS
8040: SELECT 'Y' answer
8041: FROM dual
8042: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all
8043: WHERE payment_term_id = p_payment_term_id);
8044:
8045: BEGIN

Line 8279: FROM dual

8275: AND start_date BETWEEN p_start_date AND p_end_date;
8276:
8277: CURSOR search_for_items (p_payment_term_id NUMBER) IS
8278: SELECT 'Y' answer
8279: FROM dual
8280: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all
8281: WHERE payment_term_id = p_payment_term_id);
8282:
8283: -- note that the old office area is excluded

Line 8700: FROM DUAL;

8696: ELSIF trunc(last_day(p_from_date)) <> trunc(p_from_date) THEN
8697:
8698: SELECT ADD_MONTHS(p_from_date, NVL(p_yrs,0) * 12 + NVL(p_mths,0)) + NVL(p_days,0)
8699: INTO l_to_date
8700: FROM DUAL;
8701:
8702: RETURN l_to_date - 1;
8703:
8704: ELSE

Line 8708: FROM DUAL;

8704: ELSE
8705: -- Bug 9345928
8706: SELECT ADD_MONTHS( (p_from_date - 1), NVL(p_yrs,0) * 12 + NVL(p_mths,0)) + NVL(p_days,0)
8707: INTO l_to_date
8708: FROM DUAL;
8709:
8710: RETURN l_to_date;
8711: END IF;
8712: ELSE