APPS.PAY_CA_ARCHIVE_UTILS dependencies on DUAL

Line 222: FROM DUAL;

218: l_gre_or_pre := 'TRANSFER_GRE';
219:
220: SELECT decode(p_report_type,'PAYCAT4AMPDF','CAEOY_T4_AMEND_PP','CAEOY_T4A_AMEND_PP')
221: INTO l_archive_type
222: FROM DUAL;
223:
224: ELSIF p_report_type IN ('PAYCARL1AMPDF','PAYCARL2AMPDF')
225: THEN
226:

Line 231: FROM DUAL;

227: l_gre_or_pre := 'PRE_ORGANIZATION_ID';
228:
229: SELECT decode(p_report_type,'PAYCARL1AMPDF','CAEOY_RL1_AMEND_PP','CAEOY_RL2_AMEND_PP')
230: INTO l_archive_type
231: FROM DUAL;
232:
233: END IF;
234: /*Added for Bug#10359114*/
235: IF p_report_type IN ('PAYCAT4CLPDF') THEN