154:
155: select count(*)
156: into l_totalNum
157: from wip_job_schedule_interface wjsi,
158: wip_job_dtls_interface wjdi
159: where wjdi.parent_header_id = wjsi.header_id
160: and wjdi.group_id = wjsi.group_id
161: and wjdi.process_phase = wip_constants.ml_validation
162: and wjdi.process_status = wip_constants.pending
502:
503: select count(*)
504: into l_totalNum
505: from wip_job_schedule_interface wjsi,
506: wip_job_dtls_interface wjdi
507: where wjdi.parent_header_id = wjsi.header_id
508: and wjdi.group_id = wjsi.group_id
509: and wjdi.process_phase = wip_constants.ml_validation
510: and wjdi.process_status = wip_constants.pending