APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on WIP_DISCRETE_JOBS

Line 1033: -- else check in wip_discrete_jobs

1029: /* WIP_REPETITIVE_SCHEDULE_ID is not null then the record must be a */
1030: /* repetitive_schedule. If WIP_REPETITIVE_SCHEDULE_ID is NULL, then it */
1031: /* must be a discrete job */
1032: -- Bug 3083961. If x_wip_repetitive_schedule_id is not null check in wip_repetitive_schedules.
1033: -- else check in wip_discrete_jobs
1034:
1035: if x_wip_repetitive_schedule_id is not null then
1036: begin
1037: SELECT distinct 'Y' into x_valid

Line 1053: FROM wip_discrete_jobs wdj

1049: end;
1050: else
1051: begin
1052: SELECT distinct 'Y' into x_valid
1053: FROM wip_discrete_jobs wdj
1054: WHERE wdj.organization_id=x_destination_organization_id
1055: AND wdj.wip_entity_id = x_wip_entity_id
1056: AND wdj.status_type IN (3,4,6)
1057: AND x_wip_repetitive_schedule_id is NULL;