DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on WIP_SCHEDULE_GROUPS_VAL_V

Line 715: from wip_schedule_groups_val_v sg

711: WIP_CONSTANTS.CREATE_NS_JOB)
712: and wjsi.schedule_group_id is null
713: and wjsi.schedule_group_name is not null
714: and not exists (select 1
715: from wip_schedule_groups_val_v sg
716: where sg.schedule_group_name = wjsi.schedule_group_name
717: and sg.organization_id = wjsi.organization_id)
718: returning wjsi.interface_id bulk collect into l_interfaceTbl;
719:

Line 729: from wip_schedule_groups_val_v sg

725:
726: update wip_job_schedule_interface wjsi
727: set wjsi.schedule_group_id =
728: (select sg.schedule_group_id
729: from wip_schedule_groups_val_v sg
730: where sg.schedule_group_name = wjsi.schedule_group_name
731: and sg.organization_id = wjsi.organization_id),
732: wjsi.last_update_date = sysdate
733: where wjsi.group_id = p_groupID

Line 840: from wip_schedule_groups_val_v sg

836: WIP_CONSTANTS.RESCHED_JOB,
837: WIP_CONSTANTS.CREATE_NS_JOB)
838: and wjsi.schedule_group_id is not null
839: and not exists (select 1
840: from wip_schedule_groups_val_v sg
841: where sg.schedule_group_id = wjsi.schedule_group_id
842: and sg.organization_id = wjsi.organization_id)
843: returning wjsi.interface_id bulk collect into l_interfaceTbl;
844: