APPS.PA_PROGRESS_REPORT_UTILS dependencies on DUAL

Line 328: dual

324: WHERE page_id = p_page_id;
325:
326: CURSOR check_update_report_ok
327: IS SELECT 'N' FROM
328: dual
329: WHERE exists
330: (SELECT * FROM
331: pa_progress_report_vers
332: WHERE page_id = p_page_id

Line 528: FROM dual

524: IS
525:
526: CURSOR get_progress_report
527: IS SELECT 'Y'
528: FROM dual
529: WHERE exists(
530: SELECT version_id
531: FROM pa_progress_report_vers
532: WHERE object_id = p_object_id

Line 562: FROM dual

558: IS
559:
560: CURSOR get_page_layout
561: IS SELECT 'Y'
562: FROM dual
563: WHERE exists(
564: SELECT page_id
565: FROM pa_object_page_layouts
566: WHERE object_id = p_object_id

Line 572: FROM dual

568: );
569:
570: CURSOR get_obj_region
571: IS SELECT 'Y'
572: FROM dual
573: WHERE exists(
574: SELECT placeholder_reg_code
575: FROM pa_object_regions
576: WHERE object_id = p_object_id

Line 765: select substr(l_page_id_tmp,1,4) into l_model from dual;

761: close C2;
762: END IF;
763: end if;
764: /*
765: select substr(l_page_id_tmp,1,4) into l_model from dual;
766: IF (l_model='PAGE') THEN
767: select substr(l_page_id_tmp,6) into l_page_id_s from dual;
768: l_page_id := to_number(l_page_id_s);
769: END IF;

Line 767: select substr(l_page_id_tmp,6) into l_page_id_s from dual;

763: end if;
764: /*
765: select substr(l_page_id_tmp,1,4) into l_model from dual;
766: IF (l_model='PAGE') THEN
767: select substr(l_page_id_tmp,6) into l_page_id_s from dual;
768: l_page_id := to_number(l_page_id_s);
769: END IF;
770: */
771: END IF;

Line 849: from dual

845: -- which is not published nor cancelled
846:
847: CURSOR get_ppr_pagelayout_delete_ok IS
848: select 'N'
849: from dual
850: where exists
851: (
852: select version_id
853: FROM PA_PROGRESS_REPORT_VERS

Line 891: from dual

887: -- which is not published nor cancelled
888:
889: CURSOR get_ppr_pagelayout_edit_ok IS
890: select 'N'
891: from dual
892: where exists
893: (
894: select version_id
895: FROM PA_PROGRESS_REPORT_VERS