APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_SCHEDULE_GROUPS_VAL_V

Line 7830: from wip_schedule_groups_val_v

7826: v_wlji_schedule_group_id(v_idx) is null then
7827: begin
7828: select schedule_group_id
7829: into v_wlji_schedule_group_id(v_idx)
7830: from wip_schedule_groups_val_v
7831: where organization_id = v_wlji_org_id(v_idx)
7832: and schedule_group_name =v_wlji_schedule_group_name(v_idx);
7833: exception
7834: when others then

Line 7897: from wip_schedule_groups_val_v wsg

7893: l_stmt_num := 170.3;
7894: begin
7895: select 1
7896: into l_temp_num
7897: from wip_schedule_groups_val_v wsg
7898: where wsg.schedule_group_id = v_wlji_schedule_group_id(v_idx)
7899: and wsg.organization_id = v_wlji_org_id(v_idx);
7900: exception
7901: when too_many_rows then

Line 7966: from wip_schedule_groups_val_v

7962: begin
7963:
7964: select schedule_group_id
7965: into v_wlji_schedule_group_id(v_idx)
7966: from wip_schedule_groups_val_v
7967: where organization_id = v_wlji_org_id(v_idx)
7968: and schedule_group_name =v_wlji_schedule_group_name(v_idx);
7969:
7970: exception

Line 7992: from wip_schedule_groups_val_v wsg

7988: l_stmt_num := 170.5;
7989: begin
7990: select 1
7991: into l_temp_num
7992: from wip_schedule_groups_val_v wsg
7993: where wsg.schedule_group_id = v_wlji_schedule_group_id(v_idx)
7994: and wsg.organization_id = v_wlji_org_id(v_idx);
7995: exception
7996: when too_many_rows then