APPS.RCI_ORG_CERT_ETL_PKG dependencies on DUAL

Line 40: select 1 from dual where exists /*select count(process_id) from*/ (

36: ,p_organization_id in number
37: ,p_process_id in number) is
38: /*12.30.2005 npanandi: changed below query according to changes
39: in datamodel for financial statements */
40: select 1 from dual where exists /*select count(process_id) from*/ (
41: SELECT DISTINCT ctrls.pk1 as certification_id /*fin_certification_id*/
42: ,o.organization_id
43: ,ctrls.pk3
44: ---,all_ctrls.control_id

Line 322: select /*count(process_id)*/ 1 from dual where exists (

318: **/
319: cursor c_proc_certified_w_issues(p_fin_certification_id in number,p_organization_id in number
320: ,p_process_id in number)
321: is
322: select /*count(process_id)*/ 1 from dual where exists (
323: select distinct o.organization_id,
324: proc.process_id,
325: finprocsum.FIN_CERTIFICATION_ID,
326: evalopn.pk2_value, /*project_id*/

Line 361: select /*count(process_id)*/ 1 from dual where exists (

357:
358: cursor c_proc_certified(p_fin_certification_id in number,p_organization_id in number
359: ,p_process_id in number)
360: is
361: select /*count(process_id)*/ 1 from dual where exists (
362: select distinct o.organization_id,
363: proc.process_id,
364: finprocsum.FIN_CERTIFICATION_ID,
365: evalopn.pk2_value, /*project_id*/

Line 400: select /*count(process_id)*/ 1 from dual where exists (

396:
397: cursor c_proc_not_certified(p_fin_certification_id in number,p_organization_id in number
398: ,p_process_id in number)
399: is
400: select /*count(process_id)*/ 1 from dual where exists (
401: select distinct o.organization_id,
402: proc.process_id,
403: finprocsum.FIN_CERTIFICATION_ID,
404: evalopn.pk2_value, /*project_id*/