APPS.WIP_JOB_DTLS_VALIDATIONS dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 13: from wip_job_schedule_interface wjsi

9: and wjdi.parent_header_id = p_parent_header_id
10: and wjdi.process_phase = wip_constants.ml_validation
11: and wjdi.process_status in (wip_constants.running, wip_constants.warning)
12: and not exists (select 1
13: from wip_job_schedule_interface wjsi
14: where wjdi.group_id = wjsi.group_id
15: and wjdi.parent_header_id = wjsi.header_id);
16:
17: cursor c_wdj_invalid_rows is

Line 88: from wip_job_schedule_interface wjsi

84: and process_phase = wip_constants.ml_validation
85: and process_status in (wip_constants.running,
86: wip_constants.warning)
87: and not exists (select 1
88: from wip_job_schedule_interface wjsi
89: where wjsi.group_id = p_group_id
90: and wjdi.parent_header_id = wjsi.header_id);
91: end if;
92: end if;