APPS.PN_SCHEDULES_ITEMS dependencies on DUAL

Line 1396: FROM DUAL;

1392: IF check_sch%NOTFOUND THEN
1393:
1394: SELECT pn_payment_schedules_s.NEXTVAL
1395: INTO l_sch_id
1396: FROM DUAL;
1397:
1398: l_pymnt_st_lkp_cd := 'DRAFT';
1399:
1400: INSERT INTO pn_payment_schedules_all

Line 1461: FROM DUAL;

1457: AND ROWNUM = 1;
1458:
1459: EXCEPTION WHEN NO_DATA_FOUND THEN
1460: SELECT pn_payment_schedules_s.NEXTVAL INTO l_sch_id
1461: FROM DUAL;
1462:
1463: INSERT INTO pn_payment_schedules_all(
1464: payment_schedule_id,
1465: last_update_date,

Line 3031: FROM DUAL

3027:
3028: BEGIN
3029: SELECT 'Y'
3030: INTO l_exists
3031: FROM DUAL
3032: WHERE EXISTS (SELECT NULL
3033: FROM pn_space_assign_cust_all psa
3034: WHERE psa.tenancy_id = p_tenancy_id
3035: AND (EXISTS (SELECT NULL

Line 7045: FROM DUAL

7041:
7042: CURSOR bkhd_exists_cur
7043: IS
7044: select 'x'
7045: FROM DUAL
7046: where exists (select BKHD_DEFAULT_ID
7047: from pn_var_bkpts_head_all
7048: where period_id IN (select PERIOD_ID
7049: FROM pn_var_periods_all

Line 7068: FROM DUAL

7064: AND details.lease_change_id = det_history.new_lease_change_id;
7065:
7066: CURSOR no_periods_exist_cur IS
7067: SELECT 'Y'
7068: FROM DUAL
7069: WHERE NOT EXISTS ( SELECT NULL
7070: FROM pn_index_leases_all ilease, pn_index_lease_periods_all period
7071: WHERE ilease.lease_id = p_lease_id
7072: AND period.index_lease_id = ilease.index_lease_id);

Line 7143: into l_end_pos from dual;

7139:
7140: WHILE(l_start_pos <= length(p_lease_context))
7141: LOOP
7142: select decode(instr(p_lease_context,':',l_start_pos),0,length(p_lease_context),instr(p_lease_context,':',l_start_pos)-1)
7143: into l_end_pos from dual;
7144: l_lease_context := substr(p_lease_context,l_start_pos,l_end_pos - l_start_pos + 1);
7145: l_start_pos := l_end_pos + 2;
7146:
7147: IF l_lease_context = 'CON' AND p_called_from = 'MAIN' THEN