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 638: from dual

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