APPS.PNP_UTIL_FUNC dependencies on DUAL

Line 2050: FROM DUAL;

2046: begin
2047:
2048: SELECT pn_locations_s.NEXTVAL
2049: INTO l_seqnum
2050: FROM DUAL;
2051:
2052: RETURN l_seqnum;
2053:
2054: exception

Line 2072: FROM dual;

2068: begin
2069:
2070: SELECT PN_SPACE_ASSIGN_EMP_S.NEXTVAL
2071: INTO l_seqnum
2072: FROM dual;
2073:
2074: RETURN l_seqnum;
2075:
2076: exception

Line 2481: FROM DUAL;

2477: , 'QTR', 3
2478: , 'SA', 6
2479: , 'YR', 12
2480: , -1)) AS freq_num
2481: FROM DUAL;
2482:
2483: l_sched_tbl PNP_UTIL_FUNC.virtual_sched_tbl_type;
2484:
2485: l_frequency NUMBER;

Line 2623: FROM dual

2619: */
2620: CURSOR exists_norm_term( p_lease_ID IN NUMBER
2621: ,p_termination_date IN DATE) IS
2622: SELECT 1
2623: FROM dual
2624: WHERE EXISTS
2625: (SELECT 1
2626: FROM pn_payment_schedules_all s,
2627: pn_payment_items_all i

Line 7105: FROM DUAL

7101: USER_DEF_ERROR Exception;
7102:
7103: CURSOR validate_start_date_cursor IS
7104: SELECT 'x'
7105: FROM DUAL
7106: WHERE EXISTS (SELECT 'x'
7107: FROM pn_space_assign_emp_all
7108: WHERE location_id IN (SELECT location_id
7109: FROM pn_locations_all

Line 7130: FROM DUAL

7126: AND NVL(cust_assign_end_date,to_date('12/31/4712','mm/dd/yyyy')) >= p_start_date_old);
7127:
7128: CURSOR validate_end_date_cursor IS
7129: SELECT 'x'
7130: FROM DUAL
7131: WHERE EXISTS (SELECT 'x'
7132: FROM pn_space_assign_emp_all
7133: WHERE location_id IN (SELECT location_id
7134: FROM pn_locations_all

Line 7595: FROM dual

7591: RETURN BOOLEAN IS
7592:
7593: CURSOR tenancy_exists IS
7594: SELECT 'Y'
7595: FROM dual
7596: WHERE exists
7597: (select tenancy_id
7598: from pn_tenancies_all
7599: where location_id in

Line 7641: FROM dual

7637: RETURN BOOLEAN IS
7638:
7639: CURSOR tenancy_exists IS
7640: SELECT 'Y'
7641: FROM dual
7642: WHERE exists
7643: (select tenancy_id
7644: from pn_tenancies_all
7645: where location_id in

Line 7688: FROM dual

7684: RETURN BOOLEAN IS
7685:
7686: CURSOR Area_Class_Dtls_Exist IS
7687: SELECT 'Y'
7688: FROM dual
7689: WHERE exists
7690: (select area_class_dtl_line_id
7691: from pn_rec_arcl_dtlln_all
7692: where location_id in

Line 7701: from dual

7697: );
7698:
7699: CURSOR Area_CLass_Dtls_Exist_For_Dt IS
7700: select 'Y'
7701: from dual
7702: where exists
7703: (select arclDtl.area_class_dtl_line_id
7704: from pn_rec_arcl_dtlln_all arclDtl
7705: where arclDtl.location_id = p_location_id

Line 7874: FROM dual

7870: AND trm.start_date BETWEEN loc.active_start_date AND loc.active_end_date;
7871:
7872: CURSOR search_for_items (p_payment_term_id NUMBER) IS
7873: SELECT 'Y' answer
7874: FROM dual
7875: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all
7876: WHERE payment_term_id = p_payment_term_id);
7877:
7878: BEGIN

Line 8111: FROM dual

8107: AND start_date BETWEEN p_start_date AND p_end_date;
8108:
8109: CURSOR search_for_items (p_payment_term_id NUMBER) IS
8110: SELECT 'Y' answer
8111: FROM dual
8112: WHERE EXISTS (SELECT 'Y' FROM pn_payment_items_all
8113: WHERE payment_term_id = p_payment_term_id);
8114:
8115: -- note that the old office area is excluded

Line 8530: FROM DUAL;

8526: RETURN p_from_date;
8527: ELSE
8528: SELECT ADD_MONTHS(p_from_date, NVL(p_yrs,0) * 12 + NVL(p_mths,0)) + NVL(p_days,0)
8529: INTO l_to_date
8530: FROM DUAL;
8531:
8532: RETURN l_to_date - 1;
8533: END IF;
8534: ELSE