APPS.AMW_PROC_APPROVAL_PKG dependencies on DUAL

Line 569: select pid from dual;

565: where process_id = pid
566: and up_down_ind = 'D'
567: and hierarchy_type = 'L'
568: union
569: select pid from dual;
570:
571: cursor ass_risks (pid number) is
572: select risk_id from amw_risk_associations where pk1 = pid and object_type = 'PROCESS';
573:

Line 892: select pid from dual;

888: where process_id = pid
889: and up_down_ind = 'D'
890: and hierarchy_type = 'L'
891: union
892: select pid from dual;
893:
894: std_process varchar2(1);
895: st_var_pid number;
896: l_dummy number;

Line 992: select pid from dual;

988: where process_id = pid
989: and up_down_ind = 'D'
990: and hierarchy_type = 'L'
991: union
992: select pid from dual;
993:
994: std_process varchar2(1);
995: l_std_variation amw_process.STANDARD_VARIATION%TYPE;
996: l_dummy number;