DBA Data[Home] [Help]

APPS.PAY_MIX_ROLLBACK_PKG dependencies on DUAL

Line 99: from dual

95: to_char(null) assignment_number,
96: to_number(null) element_type_id,
97: to_date(null) effective_date,
98: to_date(null) effective_start_date
99: from dual
100: where not exists
101: (select null
102: from pay_batch_headers pbh
103: where pbh.batch_id = p_batch_header_id);

Line 636: from dual

632: where pbh1.batch_id = ppa.batch_id);
633: --
634: cursor csr_reset_control_total (p_batch_id number) is
635: select 'Y'
636: from dual
637: where exists
638: (select null
639: from pay_batch_control_totals pct
640: where pct.batch_id = p_batch_id