APPS.IGS_PR_GEN_004 dependencies on DUAL

Line 3707: FROM DUAL;

3703: v_dummy VARCHAR2(1);
3704:
3705: CURSOR c_spo IS
3706: SELECT IGS_PR_SPO_SEQ_NUM_S.NEXTVAL
3707: FROM DUAL;
3708:
3709: CURSOR c_crv IS
3710: SELECT crv.responsible_org_unit_cd,
3711: crv.responsible_ou_start_dt

Line 5259: cst_manual, cst_manual)FROM DUAL;

5255: SELECT DECODE(
5256: p_application_type,
5257: cst_initial, cst_system,
5258: cst_todo, cst_todo,
5259: cst_manual, cst_manual)FROM DUAL;
5260:
5261: LV_ROWID VARCHAR2(25);
5262: BEGIN
5263: OPEN c_decode;

Line 5284: 'Y', NULL)FROM DUAL;

5280: CURSOR c_decode2 IS
5281: SELECT DECODE (
5282: v_passed_ind,
5283: 'N', v_message_text,
5284: 'Y', NULL)FROM DUAL;
5285:
5286: lv_rowid VARCHAR2(25);
5287: l_org_id NUMBER(15);
5288: BEGIN