APPS.JTF_IH_PURGE dependencies on DUAL

Line 137: SELECT p_End_Date-p_Start_Date INTO n_Res FROM DUAL;

133: -- Compare p_End_Date and p_Start_Date. p_End_Date shouldn't be less then p_Start_Date
134: -- This comparation I'll make if p_Active flag is 'N', otherwise let pass it.
135: IF p_Start_Date IS NOT NULL AND p_End_Date IS NOT NULL AND l_Active = 'N' THEN
136: BEGIN
137: SELECT p_End_Date-p_Start_Date INTO n_Res FROM DUAL;
138: IF n_Res < 0 THEN
139: RAISE ErrStartEndDate;
140: END IF;
141: EXCEPTION

Line 151: SELECT TO_NUMBER(REPLACE(REPLACE(p_Party_IDs,',',''),' ','')) INTO n_Res FROM DUAL;

147: -- Add Party_IDs to major select statement if they are setup.
148: IF p_Party_Ids IS NOT NULL THEN
149: -- Make data validation for PartyIds
150: BEGIN
151: SELECT TO_NUMBER(REPLACE(REPLACE(p_Party_IDs,',',''),' ','')) INTO n_Res FROM DUAL;
152: EXCEPTION
153: WHEN OTHERS THEN
154: RAISE ErrPatyIdsDescription;
155: END;

Line 548: FROM dual

544: l_jtf_activity := 'JTF_ACTIVITY';
545:
546: SELECT JTF_OBJECT_PURGE_PROC_SET_S.NEXTVAL
547: INTO l_processing_set_id
548: FROM dual
549: WHERE rownum = 1;
550:
551:
552: FORALL i IN l_activity_id.FIRST..l_activity_id.LAST

Line 681: FROM dual

677: l_jtf_interaction := 'JTF_INTERACTION';
678:
679: SELECT JTF_OBJECT_PURGE_PROC_SET_S.NEXTVAL
680: INTO l_processing_set_id
681: FROM dual
682: WHERE rownum = 1;
683:
684:
685: FORALL i IN l_inter_int_ids.FIRST..l_inter_int_ids.LAST