[Home] [Help]
108: is
109: select
110: ap1.application_period_id
111: from
112: hxc_tc_ap_links ap1
113: where ap1.timecard_id = p_timecard_id
114: and not exists (
115: select
116: 'x'
114: and not exists (
115: select
116: 'x'
117: from
118: hxc_tc_ap_links ap2
119: where ap2.application_period_id = ap1.application_period_id
120: and ap2.timecard_id <> p_timecard_id );
121:
122: Begin