APPS.MSC_X_CVMI_REPLENISH dependencies on MSC_PLAN_ORG_STATUS

Line 56: from msc_plan_org_status

52: -- last netting run
53:
54: select status
55: into l_last_max_refresh_number
56: from msc_plan_org_status
57: where plan_id = -1
58: and organization_id = -1
59: and sr_instance_id = -1;
60: exception

Line 64: insert into msc_plan_org_status (plan_id,

60: exception
61: when no_data_found then
62: l_last_max_refresh_number := 0;
63:
64: insert into msc_plan_org_status (plan_id,
65: organization_id,
66: sr_instance_id,
67: status,
68: status_date,

Line 99: update msc_plan_org_status

95: print_debug_info(' Error when launch workflow process = ' || sqlerrm);
96: END;
97:
98:
99: update msc_plan_org_status
100: set status = l_curr_max_refresh_number,
101: status_date = sysdate
102: , number1 = p_replenish_time_fence
103: where plan_id = -1