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 615: from dual;

611: -- Return the transaction_id.
612: --
613: select pay_pss_transactions_s.nextval
614: into l_transaction_id
615: from dual;
616: p_transaction_id := to_char(l_transaction_id);
617: add2wf(l_item_type, l_item_key, C_PSS_TXID_WF_ATTRIBUTE, l_transaction_id);
618: p_msg_count := 0;
619: p_return_status := fnd_api.G_RET_STS_SUCCESS;

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

958: end loop;
959: else
960: if not l_found then
961: --
962: l_sql_stat:='select '||p_function||'('||p_assignment_id||','''||to_char(p_effective_date)||''','''||l_category||''') from sys.dual';
963: --
964: begin
965: execute immediate l_sql_stat into l_opmid;
966: exception