APPS.PAY_PPMV4_SS dependencies on DUAL

Line 30: from sys.dual

26: begin
27: --
28: select null
29: into l_dummy
30: from sys.dual
31: where not exists
32: (select null
33: from pay_pss_transaction_steps pts,
34: pay_org_payment_methods_f opm,

Line 546: from dual;

542: -- Return the transaction_id.
543: --
544: select pay_pss_transactions_s.nextval
545: into l_transaction_id
546: from dual;
547: p_transaction_id := to_char(l_transaction_id);
548: add2wf(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, l_transaction_id);
549: p_msg_count := 0;
550: p_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 887: l_sql_stat:='select '||p_function||'('||p_assignment_id||','''||to_char(p_effective_date)||''','''||l_category||''') from sys.dual';

883: end loop;
884: else
885: if not l_found then
886: --
887: l_sql_stat:='select '||p_function||'('||p_assignment_id||','''||to_char(p_effective_date)||''','''||l_category||''') from sys.dual';
888: --
889: begin
890: execute immediate l_sql_stat into l_opmid;
891: exception